So here you are in your second week of your great new job in the accounting department of a company that uses JD Edwards World software and after spending time getting familiar with it week one, you’re feeling pretty confident...UNTIL … your boss comes by and tasks you with finding out why the trial balance she just ran is out of balance! She needs it cleared up by the end of the week because the auditors arrive early Monday morning.
Wow! It’s your first actual assignment! Yea! Uh oh! You suddenly realize that although you paid a great deal of attention during your training, you really only know the basics of getting around in JD Edwards World. Panic sets in! Your mind is a blank! You suddenly can’t even remember what a trial balance is! How are you going to find out what’s wrong?
Ok... take a deep breath, you can do this. Let’s take it a step at a time. Since the trial balance only reports posted amounts, the first thing you should do is run some integrity reports that check to see if you have any problems with batches:
1. Start with the Transactions to Batch Header report. This integrity will report discrepancies between the batch header’s status and the transactions within the batch. It will also show any transactions that are missing a batch header. It’s easy to fix these types of issues. If your transactions are unposted and the batch header is posted, just update the batch status on the batch header to “approved” and resubmit the post program. If a batch header is missing, you can add it very easily. Look at Doc ID 626947.1 - How to Add, Update, or Delete a Batch Header Record for complete steps.
2. Next, run the Batch to Detail and Out of Balance report. This report lists batches posted out of balance. If any batches are listed, you should investigate these batches and make correcting entries. What? How do I investigate, you are probably thinking. Don’t worry, we’ve got you covered. Have a look at Doc ID 662609.1 - Finding Batches Posted Out of Balance.
3. Now run the Unposted Batches integrity report. This integrity looks for any batch headers that are not posted. Sometimes it’s as simple as this - some batches just didn’t get posted!
4. After correcting any batch issues, run the Companies in Balance integrity report. This report will list all your companies. Companies that don’t balance will have amounts listed in any of three columns on this report. This can be a difficult integrity to clear because there are so many different reasons a company can be out of balance. But, you guessed it...we’ve got something to help: Take a look at Doc ID 657081.1Troubleshooting the Companies in Balance Integrity Report. This document lists the most common reasons a company may be out of balance which are:
- Journal entries are posted to the prior year after the Close Year program has been run.
- There are batches posted out of balance. (The three batch integrities you’ve already run may not have caught all of them.)
- Intercompany settlement records are missing.
- There has been a fiscal date pattern change to the company.
- Data is missing in records.
It then details steps to solve various scenarios found on the report.
Along with the documents just mentioned, you might want to bookmark this document that will guide you in keeping your data in sync on an on-going basis: Doc ID 950649.1 -Financial Integrity Reports - Preferred Order to Run and Functionality Overview.
Still need some guidance? We’re here to help! Post quick questions to our customer community, which is monitored by Support experts. If you think you need more in-depth help, open a service request with us!