Understanding Invoice Generation for JD Edwards EnterpriseOne Service Billing

When you run the Invoice Generation program (R48121), the system automatically summarizes the selected transactions in the Billing Detail Workfile table (F4812) and stores them in the Invoice Summary Work File table (F4822). The system uses the sequence and summarization rules that you defined to control how the workfile transactions are summarized. The system uses the invoice summary entries to create transactions in the Customer Ledger table (F03B11) when you run the Create A/R Entries program (R48199).

During invoice generation, the system:

  • Creates a record in the Service Billing Batch Control table (F48011).

    The current activity field is set to 1, indicating that invoice generation is in progress.

  • Uses processing options and data selection criteria to select transactions in the F4812 table and summarizes and stores them in the F4822 table.

    The workfile transactions are updated with the invoice information (batch number, invoice number, pay item, document type, and invoice date) to indicate that these transactions are included in an invoice.

  • Uses the rules from the Invoice Sequence/Summarization Table Header (F4805) and Invoice Sequence/Summarization Table Detail (F48051) tables that you have defined to control the invoice and pay item summarization logic.

  • Uses the rules from the G/L Offset and Retainage Information table (F48128) that you have defined to calculate retainage information for the invoice, if applicable.

  • Prints invoices (optional).

  • Creates preliminary journal entries or, if a version is entered in the Create A/R Entries Version (R48199) processing option, creates final journal entries.

  • Updates table F48011 with the amount and the number of documents in the batch when the Invoice Generation program finishes.

    The current activity field in the batch header is reset to 0 to enable additional processes to be performed against this batch.

    Note: When you specify a version to run the Create A/R Entries program automatically from the Invoice Generation program and the system detects no errors, the system does not perform this action. Instead, it deletes the record in the F48011 table.
  • Produces a report that lists the invoices that it created.

Note: The reports generated (including the Invoice Register) when you run the Invoice Generation program (R48121) are printed in domestic amounts, regardless of the currency mode.