Automatic Entries Created by the Invoice Post

When you post invoice batches, the system creates automatic entries to the tax, intercompany settlement, and A/R trade accounts. The offset amount to the A/R trade account is controlled by the AAI item RC. The program uses the company number and the G/L offset from each invoice to locate the AAI item RC. This item contains the offset account to which you are posting.

During the post process, the system retrieves this information for the automatic entry record based on the offset method that you specify in the A/R Constants:

  • Automatic offset amounts.

    • If the offset method is B, the system accumulates invoice amounts and creates one automatic entry for the entire batch of invoices.

    • If the offset method is S, the system accumulates pay item amounts and creates one automatic entry for each invoice.

    • If the offset method is Y, the system creates one automatic entry for each invoice pay item.

  • Document number.

    • If the offset method is B, the system assigns the batch number as the document number of the AE entry.

    • If the offset method is Y or S, the system assigns the document number of the invoice as the document number of the automatic entry.

  • Account number description.

    • If the offset method is B, the system writes Accounts Receivable - Trade/Offset by Batch IB (invoice batch number).

    • If the offset method is Y or S, the system writes Accounts Receivable - Trade/Offset by Document RI (invoice document number).

  • G/L Date - The system always uses the G/L date of the invoice, regardless of the offset method.

If the invoice includes taxes, the system generates an automatic offset with the same characteristics, except that the account description is from the AAI item RT (receivables tax). It records the tax amount in the Taxes table (F0018), based on a processing option.

Note: Although posting out-of-balance batches prevents the system from creating intercompany settlements, posting out-of-balance does create AE entries to the A/R trade account.