Understanding the A/R to G/L by Batch Report

The A/R to G/L by Batch integrity report (R03B701) compares the batch amount of the transactions in the F03B11 table with the batch amount of the corresponding records in the F0911 table. This integrity test:

• Adds all gross amounts (posted) to the F03B11 table for each batch and accounts for variations based on tax types and tax amounts.

• Accumulates all pay items that are posted to the F0911 table for each batch.

• Compares the F03B11 amount with the F0911 amount. The net difference should be zero.

• Compares the F03B11 amount with the automatic offset amount. The net difference should be zero.

Discrepancies are printed on the report.

The A/R to G/L by Batch Integrity report also verifies that the pay status is correct for each F03B11 transaction. The report validates the relationship between the pay status and open amount for these conditions:

• The invoice does not have an open amount, but the pay status is not P (paid).

• The invoice has an open amount, but the pay status is P (paid).

If any discrepancies exist, the invoice records print on the integrity report.

Before you run this program, post all invoice batches (batch type IB). The report does not process unposted or excluded batches. You can force the system to exclude a batch from processing by turning on the option on the Batch Overrides form.