- Events, Blogs & News
This is the final article of a three-part series focused on JD Edwards Financial Integrity reports. In this article, our partner Syntax reviews the subsidiary JD Edwards integrity reports for Fixed Assets, Inventory, and Payroll. These reports are useful in comparing each JD Edwards financial subsystem to the General Ledge.
To learn more about JD Edwards General Ledger and Batch Header integrity reports please view the first article in this series.
To learn more about JD Edwards Accounts Payable and Accounts Receivable integrity reports please view the second article in this series, JD Edwards Financial Integrity Reports for Accounts Payable and Accounts Receivable. How Do They Add Up?
Compares balance records in the Fixed Assets Item Balances File F1202 to the General Ledger Account Balances File F0902.
This report displays a list of all transactions that have been posted to the General Accounting System but have not yet been posted to Fixed Assets.
Reports a detail list of all transaction records from the F0911 Account Ledger for an Like a detail G/L report, this report is normally used to investigate outages.
Compares the General Ledger Account Balances File to balance records in the Fixed Assets Item Balances File.
Shows discrepancies that exist between the Item Ledger File F4111 and the Account Ledger F0911.
Compares the Item Ledger File F4111 to the Item Balance File F41021. Shows variance in amounts, quantities, or both.
Identify errors in your Tax History table (F06136).
Identify errors in the Employee Transaction History Summary table (F06146).
Run these two reports during the Final Update process of every payroll.
There are many reasons why integrity issues can arise within JD Edwards. See below for the most common.
Below is the integrity report order and cadence per the current JD Edwards recommendations.
There are two things that need to happen during the month to ensure your files in the general ledger and subledger systems are in balance. The first is to make sure all general ledger transaction files are posted, both in the GL and the subsystem. The second is to make sure that the companies within the trial balance file are balanced. It is recommended to run JD Edwards integrity reports or interactive applications throughout the month to catch any errors before month end, giving you more time to analyze errors and to determine the required corrections.
If you have the financials set up correctly, the general ledger file and trial balance should stay in sync and in balance, allowing you to complete efficient, error-free month end closes.