What populates the GL10110

[brendasql]

I was wondering if anyone could tell me what tables are used to populate the GL10110. The GL10110 table is used to populate the Summary Inquiry Report. I have a crystal report that I created to show our sales by customer class and my sales figures are not matching the General Ledger Summary Inquiry report. The accounting manager is trying to balance out the books for the year and is concern about these differences. Any help is appreciated.....

Thanks,
Brenda

 

[winthropdc]

The GL_Account_SUM_MSTR (GL10110) table is updated by the code whenever a transaction is posted. It is a running total by period of the transactions.

If you run a financial reconciliation the values of this table are refreshed.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[brendasql]

Thanks. I still do not understand why my report is not the same as the information in this table.

I have written a command in Crystal to pull from the sales transaction line items (SOP30300) and selecting the sum(QTY) for my number of items sold and SUM(XTNDPRCE) for my total sales. I believe this table(SOP30300) would be like the trigger (or starting point) in the population of the GL10110 table. Is this not a good assumation? I would also like to say that my figures are close to the totals in this table for the year, actually I had some months (or periods) that actually matched.

Can anyone think of anything that I may be missing.....

 

[VictoriaYudin]

What EXACTLY are you trying to match up? If you are trying to verify a number in a SALES GL account, then first take a look at where all those GL transactions are coming from. I would look in the GL20000 to get those details. The ORDOCNUM field in GL20000 should match up to the SOPNUMBE field in the SOP30300 table. If there is anything else in the GL20000 besides what's in the SOP30300 table, then you are not looking at all the relevant data and need to look at additional tables besides SOP30300.

Hope that helps.

Victoria
Flexible Solutions, Inc.