Missing Data Maybe 1

[villica]

Hi

I am wondering if someone can help me figure this out
In the summary inquiry screen, you can the debit, credit etc period totals. Which tables in GP has this data

villica

 

[villica]

sorry I did not word it properly

there is an inquiry summary screen in the financial module

inquiry\financial\summary\

it shows all the periods

my question is, which tables in GP has this summary data and the detail data

villica

 

[VictoriaYudin]

Villica,

The summary GL data is in the following 2 tables:
GL10110 – Open Year Summary Master
GL10111 – Historical Year Summary Master

The detail GL data is in:
GL10000 – Transaction Work/Unposted (header)
GL10001 – Transaction Work/Unposted (line detail)
GL20000 – Open Year Posted Transactions
GL30000 – Historical Year Transactions

To my knowledge, there is no table in GP that stores the beginning or ending balances, those are all calculated as needed.

All of this information (and more about reporting on GL data) can be found on:

http://victoriayudin.com/gp-reports/gl-tables/

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

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

blog:

http://victoriayudin.com