1. Contract and Service Billing Implementation Guide
  2. Understanding Workfile Generation

Understanding Workfile Generation

Invoices are based on billable costs. The first step in the billing process is to generate the workfile. Billable costs are represented by source transactions that the system stores in the Account Ledger table (F0911).

When you run the Workfile Generation program (R48120) to create workfile transactions, the system:

  • Identifies all of the unprocessed source transactions in the Account Ledger table (F0911).

  • Determines whether the account for each source transaction is billable, based on the value in the Billable (Y/N) field in the Account Master table (F0901).

  • Uses related tables when constants and source transactions indicate the need for additional information, such as when labor burden is associated with payroll transactions or when burdening is activated.

  • Updates the source transactions in the Account Ledger table as processed or non billable with either Z or N in the Bill Code field.

  • Updates the Employee Transaction History (F0618) and Employee Transaction Detail File (F06116) tables for all payroll-related source transactions in the Check Comment field (CMMT).

  • Calculates markup and tax amounts.

  • Creates copies of source transactions in the Billing Detail Workfile (F4812).

  • Assigns appropriate eligibility codes to the copied transactions based on the Journal Generation Control options in the Billing Constants and the Billable (Y/N) field in the Account Master table.

  • Assigns contract information (Contract Billing only).

  • Produces a report that lists any billable transactions that were not created in the workfile.

  • If the alternate tax rate/area assignment functionality is enabled, the system retrieves the applicable alternate tax rate/area.

    Note: See "Setting Up Alternate Tax/Rate Area Assignment Functionality" in the JD Edwards EnterpriseOne Applications Tax Processing Implementation Guide.

To indicate that the source transactions have been created in the billing workfile, the system marks the source transactions in the Account Ledger table with N (if the account is non billable) or Z (if the account is billable and has been processed by the billing system). The next time that you run the Workfile Generation program, the system creates workfile transactions for only the source transactions that have not been previously included in the Workfile Generation program.