Auditing Information where is stored 1

[villica]

Hi everyone

I was wondering on which table can I find this information
Journal Entry
TRX Date
Account Description
Debit Amount
Credit Amount
Account Number
Reference
Originating Document Number.


thanks


villica

 

[VictoriaYudin]

These are in various tables depending on the status of the fiscal year and whether the transaction is posted or not.

Posted transactions for historical years: GL30000.
Posted transactions for open years: GL20000.
Unposted transactions: GL10000 (header) and GL10001 (detail).

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

 

[villica]

Can I obtain this information from Explorer in Great Plains


villica

 

[VictoriaYudin]

Yes, this is available in SmartList (what used to be Explorer) under Account Transactions.

Victoria Yudin
Dynamics GP MVP 2005 - 2008
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html