1. Contract and Service Billing Implementation Guide
  2. Understanding Potential Workfile Errors

Understanding Potential Workfile Errors

After you generate the workfile, you can review the related workfile transactions to verify that the information that the system retrieved from the source transactions is correct. Source transactions are the transactions that the system stores in the Account Ledger table (F0911). The system might also require other information from the originating systems to process some source transactions.

When you review the transactions in the Billing Detail Workfile table (F4812), you should look for potential problems, such as:

  • Payroll transactions that are charged to an incorrect work order or job.

  • Incorrect markup amounts (if changes have been made to the markup tables since the creation of the workfile transactions).

  • Incorrect contract information (JD Edwards EnterpriseOne Contract Billing only).

When you run the Workfile Generation (R48120) or Workfile Re-extension (R481202) batch programs, and the system detects any of these errors, it updates workfile transactions with an E in the Hold Code field.

These messages print on the Workfile Generation report (R48120):

Error

Cause

Resolution

Customer Not Found

The system did not find a customer number for the business unit or work order that is assigned to the workfile transaction.

Perform one of these actions:

1) Add the customer number to the business unit or work order. You must reextend the workfile transaction to reapply the customer number.

2) Change the business unit or work order to one that has a customer number assigned to it. You must reextend the workfile transaction to reapply the customer number.

3) Change the Customer No Basis (customer number basis) option in the Billing Constants program (P48091) to properly retrieve the customer number from business unit or work order. You must reextend the workfile transaction to reapply the customer number to the workfile transaction.

Customer Master Information Missing

The customer number that is assigned to the workfile transaction is not set up in the Customer Master table (F0301).

Add the customer number to the Customer Master table (F0301). You must reextend the workfile transaction to accept this change.

Work Order Number Invalid

The work order number that is assigned to the workfile transaction does not currently exist in the Work Order Master File table (F4801).

Enter the work order number in the Work Order Master File table or change the work order that is assigned to the workfile transaction. You must reextend the workfile transaction to accept these changes.

Alternate Tax Area Error

The Address Book Number is blank for Business Unit or Branch Plant. This is invalid as it is used to retrieve the Alternate Tax Rate/Area for this transaction.

Set up a valid Address Book Number for the Business Unit or Branch Plant using the Business Unit Revisions (P0006) application.

Process Completed with Alternate Tax Area Warning

An Alternate Tax Rate/Area is not defined in the Alternate Tax Rate/Area Definition (F40081) table with the proper combination of Ship To and Ship From country codes, transaction source, company (optional), and customer/supplier number (optional).

Set up an Alternate Tax Rate/Area using the P40081 application for the following combination:

Entity 1 Country code: Business Unit Country

Entity 2 Country code: Customer Country

Transaction Source: 2

Company (optional):

Customer/Supplier Number (optional)

Work Order Number Non-Billable

The work order number that is assigned to the workfile transaction is identified as non billable. The system uses the value in the second description of the user-defined code (UDC) table 00/SS to determine whether a work order is billable. You enter the value X in the second position of the second description of a work order status value to identify a work order as non billable.

Perform one of these actions:

1) Change the status of the work order in the Work Order Master File table (F4801). You must reextend the workfile transaction to accept this change.

2) Remove the X from the second description of this work order status code in UDC 00/SS. You must reextend the workfile transaction to accept this change. Verify with the system administrator before making this change because other departments might be using the Work Order Master File table.

3) Change the work order number that is assigned to the workfile transaction. You must reextend the workfile transaction to accept this change.

Subledger Inactive

The work order number that is assigned to the workfile transaction is currently identified as inactive. The system uses the value in the Subledger Inactive field (WASBLI) in the Work Order Master File table to assign this error. You set up these values in UDC table 00/SI.

Change the value of the Subledger Inactive field in the Work Order Master File table for the work order that is assigned to the workfile transaction, or change the work order number that is assigned to the workfile transaction. You must reextend the workfile transaction to accept these changes.

If you work in a multicurrency environment, you can review the workfile in the domestic currency or in a foreign currency.

As you review workfile transactions, you can access these forms:

  • Burden Information

  • Burdening Transaction Inquiry

  • Component Transaction Inquiry

  • Source Document Information

  • Job/Amount Revisions

  • Internal Control Information

  • Table Information