1. Accounts Payable Implementation Guide
  2. Report Amounts Do Not Net to Zero

Report Amounts Do Not Net to Zero

You might receive an error message stating that amounts do not net to zero when you run the A/P Orig Doc to G/L by Batch or A/P To G/L Integrity By Offset Account report. These reports compare the data in the F0411 table to the F0911 table (A/P Orig Doc to G/L by Batch), or to the F0902 table (A/P To G/L Integrity By Offset Account). The error is usually caused by unposted AP batches.

To correct amounts that do not net to zero, post all AP batches.

The following example illustrates why the integrity report shows amounts that are out of balance unless the transactions are posted.

Suppose you enter and post voucher #1234 for 1000. The system data would include:

  • Document Type = PV (voucher).

  • Gross Amount = 1,000 (F0411).

  • Open Amount = 1,000 (F0411).

  • Posted Code = D (F0411).

  • Amount = 1,000 (F0902).

The open amount in the F0411 table and the amount in the F0902 table are in balance.

If you void voucher #1234, the system data would include:

  • Document Type = PV (voucher).

  • Gross Amount = Blank (zero) (F0411).

  • Open Amount = Blank (zero) (F0411).

  • Posted Code = D (F0411).

  • Amount = 1,000 (F0902).

Because the open amount is now zero, and the F0902 amount is 1,000, the integrity report shows the amounts as out of balance.

To correct the imbalance, post the voided transaction. The system data would include:

  • Matching Document Type = PE (change the voucher amount).

  • Gross Amount = -1,000 (F0411).

  • Open Amount = Blank (zero) (F0411).

  • Posted Code = D (F0411).

  • Amount = Blank (zero) (F0902).

The −1,000 in the F0411 table is applied to the amount in the F0902 table. The open amount in the F0411 table and the amount in the F0902 table are now in balance (both are at zero).