GL Integrity Reports

JamesGH

Member
What are the essential GL Integrity reports and how often should they be run.

I have been told that you only need to run the following on a regular basis
- Companies in Balance
- Intercompanies in Balance

Only if there are errors on them, should the following be run to detect the reason for the errors.

- Account w/o Account Master
- Transactions w/o Account Master
- Acct Balance to Transaction
- Account w/o Business Unit

What is the correct answer and are there reports missing from this list.
 
We run those reports at the period end of each month. They are some mandatory steps of our month end procedure. Yes, the reports on the second list would help a lot when there are something you don't like on those reports on the first list. I always take the Transactions to Balance Integrity Report as the most important and would rise my ear when something appear on it.



What are the essential GL Integrity reports and how often should they be run.

I have been told that you only need to run the following on a regular basis
- Companies in Balance
- Intercompanies in Balance

Only if there are errors on them, should the following be run to detect the reason for the errors.

- Account w/o Account Master
- Transactions w/o Account Master
- Acct Balance to Transaction
- Account w/o Business Unit

What is the correct answer and are there reports missing from this list.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=44921
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World?nbsp;mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards?/DIV>

+ - - - - - - - - - - - - - - - - - - - - - - - -+
 
James:
We run the GL Integrities weekly. We run all the financial integrities
weekly and at month end. These are the ones we run and in that order :
1 Batch to Detail & Out of Balance Batch Header Integrity
P007031
2 Transactions to Batch Headers Batch Header Integrity P007021
3 Unposted Batches Batch Header Integrity P007011
4 Companies in Balance G/L Integrity P097001
5 Company by Batch Out of Balance Batch Header Integrity P09706
6 Intercompany Accts in Balance G/L Integrity P097011
7 A/R to G/L by Offset Account A/R Integrity P037001
8 A/R to G/L by Batch A/R Integrity P03701
9 A/P to G/L by Offset Account A/P Integrity P047001
10 A/P Orig Doc to G/L by Batch A/P Integrity P04701
11 A/P Payments to G/L by Batch A/P Integrity P04702
12 Acct Bal to Transactions G/L Integrity P09705
14 Accounts w/o Business Units G/L Integrity P097041
15 Acct Balance w/o Acct Master G/L Integrity P097031
16 Transactions w/o Acct Master G/L Integrity P097021
Hope it helps
 
We automated the running of the GL integrity reports on a weekly basis (Sun) using a % menu via Sleeper. They are generated on HOLD and directed to the individual responsible for their review. If there are no issues they are just deleted. Issues can then be resolved in a very timely manner. Works great!

I have attached a copy of the % Menu and Sleeper setup for your review.
 

Attachments

  • 45218-GL Integrity Automation.doc
    80.5 KB · Views: 156
Just to complement:

The umposted batch is mandatory to ensure that all batchs are posted before month close.

If you have AR and/or AP implemented, the correspondents reports are too much important to check the integrity between voucher/invoice transactions (amounts) and GL transactions.

The traditional way to automatize the report`s launch is put it into AS400 sleeper. If you have any doubt in how to do that, I can send you a script.

Hope I cooperated,

R.P.G.
 
Back
Top