Understanding the Batch to Detail Report

The Batch to Detail report (R007031) compares the status of the batch header records for each batch in the F0011 table to the status of the corresponding transactions in these tables:

• F0911

• F0411, F0413, and F0414

• F03B11, F03B13, and F03B14

The system does one of the these:

• Updates the status of the batch header to D in the F0011 table if all corresponding transaction records in the batch are marked as posted.

  For example, if all F0911 records for batch type G are posted, but the batch header record for the batch in the F0011 table is not posted, the report updates the status of the F0011 record to D (posted).

• Deletes the batch header and prints a message on the report indicating that the batch was deleted if one of these situations apply:

  • No records exist for batch type G in the F0911 table.

  • No records exist in either the F03B11 table or the F03B13 and F03B14 tables and the A/R Integrity Check Flag processing option is set to 1.

  • No records exist in either the F0411 table or the F0413 and F0414 tables and the A/P Integrity Check Flag processing option is set to 1.

    Note: If the A/R or A/P Integrity Check Flag processing option is blank, the report ignores the batch regardless of whether unposted records exist in the AR or AP tables. A blank processing option indicates that the batch is not eligible for the integrity check.