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
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].
The Summary Report and the SmartList I am running is for the month of November which has not been closed yet
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.
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).
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?
Try running GL Reconcile.
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.
Am I the only one having this issue?
It returns only 7 rows and I have it setup to pull 1000 records
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
