Understanding Final Invoice Journal Entries

The system creates final invoice journal entries when you run the Create A/R Entries program (R48199) to process invoice information and transfer it from JD Edwards EnterpriseOne Service Billing to JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne General Accounting. The system creates the Customer Ledger table (F03B11) and Account Ledger table (F0911) transactions from the Invoice Summary Work File table (F4822) and Summarized Journal Workfile table (F48S911), respectively. The JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing systems use the A/R functional server and G/L functional server to validate all accounting information.

Important:

Create A/R Entries is a batch program. The invoice batch is processed as a unit. If one or more errors are detected, no invoices are created in JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne General Accounting, and the billing system sets the invoice batch to an error status. You must correct the error conditions and then rerun the Create A/R Entries program. Depending on the error, you might need to rerun the Journal Generation program (R48131) before you rerun Create A/R Entries. You can run Create A/R Entries as many times as necessary to correct all errors so that invoice information can be transferred to JD Edwards EnterpriseOne Accounts Receivable and General Accounting.

Create A/R Entries writes the invoice information to JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne General Accounting. You must run the Post Invoices to G/L program (R09801) to post the transactions, create automatic offsets, and update the posted codes and batch status. You post the transactions automatically by specifying a version of the Post Invoices to G/L program in the processing options of the Create A/R Entries program, or you can post the transactions manually.

You can post invoice batches, G/L batches, or both by specifying a version of the Post Invoices to G/L program and a batch status for each type of batch in the processing options of the Create A/R Entries program.

During the Create A/R process, the system runs the Journal Generation program if the batch is in error or if the proof journals have not been created.

If no errors are detected, the system:

• Creates a record in the Batch Control Records table (F0011) in General Accounting, using the batch number assigned in the billing system.

  The amount of the batch and the number of documents are also passed to the new record in the F0011 table.

• Writes transactions in the F0911 table using entries from the F48S911 table.

• Writes the transactions in the F03B11 table using entries in the F4822 table.

  Note: If you are using draft and final invoice numbering, the system assigns the final document types and final invoice numbers to the invoices and journal entries in the F0911 table and the F03B11 table.

• For JD Edwards EnterpriseOne Contract Billing only, updates revenue records to the Contract Revenue Summary table (F5280) using the Contract Revenue Summary Work File table (F5280W).

• Writes records in the Billing Workfile History table (F4812H) using the transactions from the Billing Detail Workfile table (F4812) for this invoice batch.

• Deletes transactions from the F4812 table for this invoice batch.

• Updates the F4822 table to indicate that the invoice has been transferred to JD Edwards EnterpriseOne Accounts Receivable.

• Writes invoice information to the Invoice Summary Access table (F48520) if the Invoice Summary Access Control option in the billing constants is selected.

• Writes transactions in the Employee Transaction History table (F0618) using the Payroll Reclassification Workfile table (F48S0618) if the Journal Reclassification Control option in the billing constants is selected and a payroll reclassification was detected during invoice journal generation.

  Note: The Create A/R Entries program supports multicurrency time accounting.

• Uses journal entries from the Billing Detail Journal Workfile table (F48S910) to write a record in the G/L Link table (F48S912).

• Deletes the transactions for this invoice batch in the F48S910 table.

• Deletes the transactions for this invoice batch in the Summarized Journal Workfile table (F48S911).

• Deletes the transactions for this invoice batch in the F48S0618 table.

• For JD Edwards EnterpriseOne Contract Billing only, deletes the revenue summary information for this invoice batch in the Contract Revenue Summary Work File table (F5280W).

• Deletes this invoice batch from the Service Billing Batch Control table (F48011).

  If errors are detected, the system deletes the record created in the Batch Control Records table (F0011) and sets the batch header record in the F48011 table to an error status.

• Produces a report that includes only headings.

  No errors are printed on the report. Refer to the Journal Edit Register report (R48300) or the Work Center for detailed information.