Common Fields Used in This Chapter

A/R Company (accounts receivable company)

Specify the invoice document company.

Adjustment No (adjustment number)

The system assigns this number to control changes to closed applications. Closed applications represent invoices that have been sent. This number is always zero unless you reopen a previous application.

Application No (application number)

Enter the last or current application number for the specified contract. (The system assigns a new application number each time an invoice is issued for the contract.)

Bill From Date

Enter the from date to use to determine whether a transaction is billed. The transaction is billed if the general ledger date falls between the from date and the through date.

Bill Through Date

Enter the cutoff date. The transactions that you enter after this date will not be billed in this billing cycle.

If you leave this field blank, the system provides a default cutoff date based on the G/L date. The invoice generation process uses this cutoff date to compare against the table basis date (WDTBDT) stored on the workfile transaction. If the table basis date is greater than the cutoff date, the workfile transaction is not included in the invoice batch

Contract/Type/Co (contract/type/company)

Enter a number to uniquely identify this contract on the system. If you leave this field blank during contract entry, the system uses the Next Numbers facility (system 52, index 01) to assign the number.

Customer

Enter the address book number to which the system posts billing and accounts receivable transactions.

Document Type

Specify a document type from user-defined code (UDC) table 00/DI, document type for invoice entry. Any document type set up for invoice-only entry should begin with the letter R (receivables). The default is RI,RR, or RM. Reserved document types have been defined for vouchers, invoices, receipts, and time sheets.

The reserved document types are:

P_: Accounts Payable documents

R_: Accounts Receivable documents

T_: Payroll documents

I_: Inventory documents

O_: Order Processing documents

Note: Verify that the default document type for invoices is set up in both UDC 00/DT and UDC 00/DI.

Exchange Rate Date Basis

Enter 1 to use the invoice date to retrieve the exchange rate for the invoice.

Enter 2 to use the G/L date of the invoice to retrieve the exchange rate for the invoice.

G/L Date (general ledger date)

Enter the date that identifies the financial period to which the source transaction should be posted. Based on the company's fiscal year and current accounting period, the system validates the date for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and PACO (post way after cutoff).

Invoice Date

Enter the date that the invoice is printed. The system updates this date when you run the invoice print program in the JD Edwards EnterpriseOne Sales Order Management system.

Invoice Type

Enter the document type of the invoice. If you leave this field blank, the system supplies the default document type for invoices from the system constants for JD Edwards EnterpriseOne Service Billing and Contract Billing.

LS Calc Method/Ledger Type (lump sum calculation method and ledger type)

In the first field, enter a code to determine how lump sum lines are calculated. Values are:

Blank: Use the greater of methods 1 and 2. The system default is blank.

1: Calculate using the Percent Complete method. This method is calculated in this manner: ((Actual Cost/Projected Final Cost) × Schedule of Values) – Prior Billed.

2: Calculate using the Markup Percent of Cost method. This method is calculated in this manner: (((Schedule of Values – Projected Final Cost) ÷ Projected Final Cost) × (Actual Cost This Period)) – (Prior Billed This Period).

3: Calculate using the Defined Ledger method. This method is calculated in this manner: ((Percent Complete from Defined Ledger) × Schedule of Values) – Prior Billed.

The Defined Ledger method considers only the first cross-reference account. If the account includes wild cards, the calculation is not performed. If the ledger is not entered, the F% ledger is used.

9: Use the lesser of methods 1 and 2.

In the second field, enter a code from UDC 09/LT to specify the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

Payment Terms

Enter a code that specifies the terms of payment, including the percentage of discount available, if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include:

Blank: Net 15

001: 1/10 net 30

002: 2/10 net 30

003: Due on the 10th day of every month

006: Due upon receipt

This code prints on customer invoices.

Tax Area/Expl (tax area and explanation)

In the first field, enter a tax area code to identify a tax or geographic area that has common tax rates and tax distribution. The tax area must be defined to include the tax authorities (for example, state, county, city, rapid transit district, province) and their rates. To be valid, a code must be set up in the Tax Rate/Area table (F4008).

In the second field, enter a tax explanation code from UDC 00/EX to control the algorithm that the system uses to calculate tax and G/L distribution amounts. The system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each transaction pay item can be defined with a different tax explanation code.

Zero Invoice Processing

Leave this field blank to create invoices only for contracts with billing activity, which prevents invoices with all amounts equal to zero from being created.

Enter 1 to create invoices regardless of billing activity. Invoices with all amounts equal to zero are created.

Enter 2 to create invoices with all amounts initialized to zero regardless of billing activity.