Understanding Invoice Generation for JD Edwards EnterpriseOne Contract Billing

When you run the Invoice Generation program (R52121) from the Invoice Processing menu, the system automatically summarizes the selected workfile transactions and stores the summarized records in the Invoice Summary Work File table (F4822). The system uses the contract billing lines that you have defined to control the invoice and pay item summarization logic. If you specify a version of the Create A/R Entries program (R48199) and do not specify a version of the Journal Generation program (R48131) in the processing options of the Invoice Generation program, the system uses the Invoice summary entries to create transactions in the Customer Ledger table (F03B11).

Note: Workfile transactions that support T and M billing are created during workfile generation. Workfile transactions supporting non-T and M billing (lump sum, unit price, milestone, progress, draws, and fees) are calculated and created when you generate invoices automatically, if you have set up cross-reference information.

You can define recurring billing invoices for lump sum billing lines. When you generate invoices, the system calculates the recurring amount if you have specified from one to five recurring codes in the processing options and you have not initialized the invoice amount to zero.

During invoice generation, the system:

  • Creates a billing batch header 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 summarize selected workfile transactions and store the summarized records in the F4822 table for T and M billing lines.

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

  • Creates workfile transactions to support non-T and M billing lines with cross-reference information, calculates billing amounts, and updates table F4822.

  • Retrieves the customer record from the contract and the general ledger offset from the billing line to assign to the invoice.

  • Updates the contract master with the invoice batch number.

    Note: Because of the cumulative nature of JD Edwards EnterpriseOne Contract Billing, a contract cannot participate in more than one invoice batch at a time.
  • Runs either the Journal Generation program (R48131) to create preliminary journal entries or the Create A/R Entries program (R48199) to create final journal entries, depending on how the processing options are set.

  • Updates the billing batch header in the F48011 table with the amount and the number of documents in the batch when the Invoice Generation program (R52121) finishes.

    The current activity field in the batch header is reset to 0 to enable the system to perform additional actions with this batch.

    Note: The system does not perform this step when you enter a version to run the Create A/R program automatically from the Invoice Generation program and no errors are detected, because the billing batch header is deleted.
  • Produces a report that lists the contracts that were processed and any errors that occurred during processing.

When you generate invoices, the system assigns invoice numbers and summarizes active workfile transactions to create pay items. Pay items are the billing lines that summarize one or more workfile transactions. The pay items for a specific invoice make up the total amount of the invoice. The system stores pay item information in the F4822 table.

After you run the Invoice Generation program, the system generates a report that includes:

  • The contract number, invoice number, and related pay items.

  • Totals by invoice.

  • The batch number.

  • Whether a not-to-exceed limit has been reached.

  • Whether a Bill When Paid rule has been satisfied.

  • Any applicable tax information.