Understanding the Deletion of Invoice Information

As you review invoice information, you might need to reduce or delete invoice information. You can delete invoice information at the batch, invoice, or workfile transaction level. For JD Edwards EnterpriseOne Service Billing transactions only, you can also delete invoice information at the pay item level. For example, you might need to delete the entire batch of invoices if the wrong document type was assigned during invoice generation.

When you delete a batch of invoices, the system:

  • Deletes the record from the Service Billing Batch Control table (F48011).

  • Deletes transactions from the Invoice Summary Work File table (F4822) for the invoice batch.

  • Removes invoice information from the transactions in the Billing Detail Workfile table (F4812) for the invoice batch.

    Note: For JD Edwards EnterpriseOne Contract Billing, the system removes invoice information from the F4812 table for T and M pay items and deletes workfile transactions for non-T and M pay items.
  • Deletes records from the Billing Detail Journal Workfile table (F48S910) and the Summarized Journal Workfile table (F48S911) for this invoice batch if invoice journal entries were created.

  • For JD Edwards EnterpriseOne Contract Billing transactions only, removes the invoice batch number from the Contract Master table (F5201) and resets the billed flag in the Milestone/Progress Billing Information table (F5216).

When you delete an invoice from a batch of invoices, the system:

  • Reduces the batch total amount stored in the F48011 table by the total amount of the invoice.

  • Deletes the transactions for the invoice from the F4822 table.

  • Removes invoice information from the transactions in the F4812 table for the invoice.

    Note: For JD Edwards EnterpriseOne Contract Billing, the system removes invoice information from the F4812 table for T and M pay items and deletes workfile transactions for non-T and M pay items.
  • Resets the batch status of the record in the F48011 table if invoice journal entries have been created. The batch status causes the system to rerun invoice journal entries.

  • If you delete the last invoice in a batch, deletes the F48011 record.

  • For JD Edwards EnterpriseOne Contract Billing transactions only, removes the invoice batch number from the F5201 table and resets the billed flag in the F5216 table.

When you delete an invoice pay item from an invoice, the system:

  • Reduces the batch total amount stored in the F48011 record by the total amount of the invoice pay item.

  • Deletes the F4822 transactions for that pay item.

  • Removes invoice information from the F4812 transactions for that pay item.

  • Resets the batch status of the F48011 record if invoice journals have been created; the batch status causes the system to rerun invoice journal entries.

  • Deletes the invoice if you delete the last pay item in an invoice.

    Note: You can delete invoice pay items from JD Edwards EnterpriseOne Service Billing invoices only.