GL Account Summary vs GL Detail SmartList

(0) Share

Report

Posted on by Community Member

I have generated a GL Detail SmartList for a specific account and a month (e.g. between 11/01/2017 and 11/30/2017). I then go to GP and bring up "Summary Inquiry" screen (Inquiry->Financial->Summary) for the same account. The total here for period 11 does not match the total in SmartList.

What ma I doing wrong?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

26P2ER 1,775 on at

Like (0)

Report

Jehan - Does your GL Detail Smartlist return 1000 rows?
I would start by extending the maximum records returned by the detail smart list, it typically defaults to 1000.

Hope this helps

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It returns only 7 rows and I have it setup to pull 1000 records

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Am I the only one having this issue?

Was this reply helpful? Yes No
Peter Bailey 84 on at

Like (1)

Report

Try adding the column "Document Status" to the GL Detail Smartlist and look for entries labelled Work. The Smartlist by default includes unposted (Document Status = Work) items but the Summary Inquiry screen excludes posted items.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Try running GL Reconcile.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have already run GL Reconcile and it didn't change anything

Do you happen to have a query for Account Summary that I can run in SQL and see the difference?

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Jehan,

See my reply from you other thread post:

community.dynamics.com/.../261650

Keep in mind that the Summary report works by 'periods', which may not align with the dates you entered in your SmartList filter.. (i.e. our periods end on the last Friday of the month.. not the last day of the months, and even some month ends on the next calendar month.. i.e. when having a 5-4-4 setup).

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Check your fiscal periods and make sure your dates are correct. I would delete the GL10110 and GL10111 tables and then run reconcile. Make sure you run a backup first.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The Summary Report and the SmartList I am running is for the month of November which has not been closed yet

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Is Your smartlist pulling the detailed transactions from GP ?

Your dates may not be aligned with the Fiscal Periods setup.. check your table SY40100..

select * from sy40100

where YEAR1 = 2017

and periodID = 11

I'm validating the transactions [GL10001] that are between the 2 dates making up the period 11 in our system and the details from the Debit & Credit columns sum up to what's returned in the account summary table [GL10110].

Was this reply helpful? Yes No