Customer Invoice Processing

When you generate the work order workfile using SWM Work Order Workfile Generation (R1775), the system gathers the orders that are eligible for billing from these tables:

  • Work Order Master File (F4801).

  • Service Order Extension (F4817).

  • Work Order Parts List (F3111).

  • Parts Extension (F31171).

  • Work Order Routing (F3112).

  • Routing Instructions - Extension (F31172).

The system then creates records in the Billing Detail Workfile table (F4812).

After you generate the work order workfile, you must continue the standard billing process, which includes:

  • Generating the invoice workfile using the Service Billing Invoice Generation program (P48121).

  • Printing invoices using the Invoice Print Selection program (R48504).

  • Generating the Invoice Journal using the Journal Generation program (R48131).

  • Creating accounts receivable (AR) and GL entries using the Create A/R Entries program (R48199).

  • Posting the AR and GL entries using the General Ledger Post Report program (R09801).

Run the Service Billing Invoice Generation program to group workfile transactions and assign invoice numbers. When you run the this program, the system summarizes one or more workfile transactions into pay item records. Pay items are the billing lines that make up the total amount of a specific invoice. The system stores pay item information in the Invoice Summary Work File table (F4822), and updates the workfile transaction records with the new invoice information and the sequence and summarization key information.

After you run the Service Billing Invoice Generation program, you can print invoices for customers for services provided to them.

To complete the billing process, you must create accounts receivable and general ledger entries. You first create preliminary accounts receivable and general ledger entries using the Journal Generation program (R48131). When the system creates preliminary accounts receivable and general ledger entries, you can review the resulting reports, the Billing Journal Register and the Invoice Journal Generation Report, to determine whether the entries were generated with errors.

After you ensure that no errors are within the batch, you can create the final accounts receivable entries, using Create AR Entries, and then post invoices to the general ledger.