9 Correct Out-of-Balance Batches

This chapter contains these topics:

After you run the report and correct any discrepancies, you can prevent future out-of-balance postings by:

  • Placing security on the Batch Header Revisions form to prevent improper changes

  • Assigning responsibility for out-of-balance posting to one user

  • Submitting posts to only one, single-threaded job queue

9.1 Overview

You can review batches that have been posted out-of-balance. You can also remove or update batch records.

Run the Batch to Detail and Out of Balance report:

  • As part of your period-end procedures

  • After you purge your tables

  • If posted batches appear as approved or pending

9.2 Running the Report

Navigation

From General Accounting (G09), choose Integrity Reports and Updates

From Integrity Reports and Updates (G0922), choose Batch to Detail and Out of Balance

The Batch to Detail and Out of Balance report:

  • Updates posted batch records to batch status D when all transactions are posted

  • Deletes empty batch header records

  • Prints an exception report of all batches with transactions that do not net to zero

This is a DREAM Writer report.

This report is the result of a two-part process:

  • Batch to detail update

  • Post out of balance verification

The batch to detail update process searches for matching transactions in the following tables:

  • Account Ledger (F0911)

  • Accounts Payable Ledger (F0411)

  • Accounts Payable Matching Document (F0413)

  • Accounts Payable Matching Document Detail (F0414)

  • Batch A/R Cash Application (F0312)

  • Accounts Receivable Ledger (F0311)

If no matching transactions are found, the system deletes batch header records from the Batch Control Records table (F0011). If all transactions for a batch have been posted, the system updates the batch header records to D (posted).

The post out of balance verification process reviews the net amount (debits equal to credits) in each batch. If the net amount is not zero, the net difference, not the batch amount, prints on the report. If the amounts net to zero, the batch is in balance and does not print.

Figure 9-1 Batches Posted Out of Balance report

Description of Figure 9-1 follows
Description of "Figure 9-1 Batches Posted Out of Balance report"

9.2.1 What You Should Know About

Topic Description
Abbreviated column headings The report contains the following abbreviated column headings:

  • Bt Ty – Batch Type

  • BS – Batch Status
Deleting batch header records To not delete selected batch header records, enter an X in the first position of the Description-2 field for the batch type. The batch type is a user defined code (98/IT).
Analyzing batch detail To analyze batch detail, run the General Journal by Batch report.

See Printing General Journal by Batch in the JD Edwards World General Accounting I Guide.

9.3 Correcting Discrepancies

After running the Batch to Detail and Out of Balance integrity report, you should correct any discrepancies the system detects. Some typical discrepancies, reasons for occurring, and possible resolutions are:

Topic Description
Batches posted out of balance Reason:

  • Purposely posting a batch out-of-balance.

Resolution:

  • If the batch was purposely posted out of balance, you may prevent the batch from appearing on this report by updating the field, Include Batch on Integrity, in the Batch Revisions program (P0011), to a value of N. Maintain documentation for this batch.
Batch is partially posted Reason:

  • A computer failure or job cancellation.

Resolutions:

  • Change the Post Out of Balance field on Batch Header Revisions to Y for out-of-balance.

  • Post the partially posted batch again.
No offsetting entries were made during the post Reason:

  • More than one post was active at a time.

Resolutions:

  • Enter the balancing journal entries.

  • Change the Post Out of Balance field on the Batch Header Revisions form to allow for out-of-balance posting.

  • Post the batch.