Understanding the A/P Payments to G/L by Batch Report

The A/P Payments to G/L by Batch (R04702A) report verifies that each batch of F0414 payments is in balance with the corresponding batch of F0911 amounts and prints any discrepancies.

This test performs the following comparisons for each batch:

• Compares the gross amount in the F0414 table with the gross amount in the F0911 table.

• Compares the automatic offset amount with the AP control amount.

• Compares both of the preceding AP and GL amounts.

The net differences between these amounts should be zero, indicating that the payments are in balance. If they are in balance, the integrity report is blank. If they are not, the batch totals appear on the integrity report.

When the system totals gross amounts, it ignores gain and loss transactions because no offset accounts exist in the general ledger.

Because manual payments that are made without a matching voucher (type W) contain both voucher and payment information, the system identifies integrity problems for this batch type differently than for other batch types. The report columns include:

• Gross Amount column.

  When a difference exists between the payment and voucher amounts, the program prints the difference in this column, with an error message that specifies which amount is greater.

• Distribution Amount column.

  When a difference exists between the distribution amounts, the program prints the difference in this column, with an error message stating that the amounts in the F0911 table do not net to 0.

• Automatic Offsets column.

  When a difference exists between the automatic offset amounts, the program prints the difference in this column, with an error message stating that the amounts in the F0911 table do not net to 0.