ilkerjde
Member
I am working as a financial auditor and I want to manually compare journal entries on JDE with the year-end G/L. To do this, I want to extract all journal entry data on F0911 and sum them to reach G/L account balances. I am using a third party data analysis tool and the number of records or complexity of calculations is not a problem.
However, since I am not very experienced in JDE and there are a lot of document types, company codes..etc on F0911, I have no idea which records should I use to check G/L.
As some basic principles:
Sum of all records belong to each journal entry must be equal to zero
Sum of all records must be equal to zero
Sum of all journal entries belong to each account must be equal to the balance of that account on G/L
I would appreciate if you share any SQL scripts which can be used to extract data I require.
However, since I am not very experienced in JDE and there are a lot of document types, company codes..etc on F0911, I have no idea which records should I use to check G/L.
As some basic principles:
Sum of all records belong to each journal entry must be equal to zero
Sum of all records must be equal to zero
Sum of all journal entries belong to each account must be equal to the balance of that account on G/L
I would appreciate if you share any SQL scripts which can be used to extract data I require.
Last edited: