Understanding the A/P to G/L by Offset Account Report

The A/P to G/L by Offset Account integrity report compares the posted open amounts from the F0411 table with the balance in the offsetting AP trade accounts in the F0902 table. The open amounts in the F0411 table do not include taxes or discounts.

This comparison:

• Summarizes the open amounts in the F0411 table for each GL account. (The GL offset code in the voucher points to the AP control offset account, which is item PC in AAIs.)

• Compares the GL account amount with the corresponding AP control account.

  The net differences between these amounts should be zero, indicating that the amounts are in balance. If they are not, the totals for the GL offset account number appear on the integrity report. AAIs control which accounts appear on the report.

• Prints the sum of any GL offset code that cannot be associated with an account in the F0902 table.

  This usually occurs if an AAI is missing, if it has been changed, or if it points to an invalid account.

The A/P to G/L by Offset Account integrity report adds the balance forward from the prior year to any activity for the current year. Because the GL annual close provides the prior year balance forward amount, you must run the GL annual close process for the prior year before you run the A/P to G/L Integrity by Offset Account report.