Field Descriptions

Table Information

 

Invoice Detail

What can I do in this subtask?

Use this subtask to initialize additional project A/R detail. Use this subtask extensively during system initialization, and to make corrections to project billing, cash receipt, and sales order history. This file stores additional detail for every transaction posted by the billing and cash receipt journal and is updated by the posting of these journals.

The programs used to calculate and age outstanding accounts receivable reference the Invoice Detail subtask for the transaction date, fiscal year, and period. Therefore, you should initialize invoice detail for receivables that were outstanding prior to your system conversion.

The lines in this subtask must sum to the invoice header records or you will be unable to save the record.

When should I use this screen?

Use this screen extensively during initialization, and to correct project billing, cash receipt, and sales order history.

Field Descriptions

Invoice Number, Customer Account, Customer Name

These non-editable fields display the invoice number, customer account, and customer name from the main screen.

Table Window

Trans Date *

This field stores the date on which you posted the invoice to the ledger. Initialization is optional.

Trans Curr

The abbreviation of the transaction currency will display in this column. The formal currency names are maintained in the Currencies screen (Administration\Maintain\Multicurrency).

Fiscal Year *

Enter the fiscal year in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.

Period *

Enter the period in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.

Subperiod *

Enter the subperiod in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.

Source

This field stores the ID of the journal from which this record was posted. It is updated by the system when you post billings, sales order entry invoices, and cash receipts. It should not be initialized as part of the A/R History initialization.

Posting Seq No

This field stores the posting sequence of the journal from which this record was posted. It is updated by the system when billings, sales order entry invoices, and cash receipts are posted. It should not be initialized as part of the A/R History initialization.

Invoice Date

For posted records, this field shows the original date for which the invoice was calculated. Note that the due date, not the invoice date, is used when calculating days outstanding. This date should match the date entered into the Initialize A/R History screen. If you enter an invoice amount, this field is required.

Invoice Amount

Enter the total amount of the receivable. This column's total amount must match the amount entered into the Initialize A/R History screen for this transaction.

If you enter an invoice amount, you will not be able to enter the amount received or receipt date on the same line. You must enter Invoice information and receipt information on separate lines.

Discount Amount

Enter the original discount offered to the project for the invoice shown. This column's total amount must match the amount you entered into the Initialize A/R History screen for this transaction.

Receipt Date

Enter the date you received payment for this invoice. If you enter an amount received, this field is required. If you have already entered an invoice amount on this line, you will need to add a new line for receipt information.

Amount Received

Enter the amount of the payment received for this invoice. This column's total amount must match the amount entered into the Initialize A/R History screen for this transaction. If you have already entered an invoice amount on this line, you will need to add a new line for receipt information.

Discount Taken

Enter the discount taken by the client in payment of this invoice. This column's total amount must match the amount you entered into the Initialize A/R History screen for this transaction.

Check Number

Enter check number of the cash receipt.

Adjustment Amt

This non-editable column displays the adjustment amount to be written off. The adjustment amount cannot be greater than the balance due amount.

Rate Group

This field displays the rate group code that is used for this customer's transactions. These rate groups identify the source of exchange rate data.

Liquidation Amount

This field is used by Delivery invoices of projects that bill using Progress Payments. It is updated when you post Delivery invoices through the Edit Project Product Bills screen (Projects\Transactions\Billing\Enter Project Product Bills) or by DD250 invoice postings.

This field represents the total calculated amount of progress payments liquidated against the delivery invoice. Liquidation amounts are progress payments that have been paid by the customer. They reduce the delivery amount to arrive at the net invoice amount.

Liquidation Taken

This field is used by delivery invoices of projects that bill using progress payments. The value initialized in this field should always represent the liquidation taken when the cash is received. It should only differ from the liquidation amount when the payment of an invoice has been adjusted to reflect a different liquidation amount than invoiced.

Due Date

This field is calculated when the billing is posted, based on the terms of the project. For records initialized, enter the anticipated due date. This date is used to age receivables.

Transaction Description

This field stores the transaction description from the billing or cash receipts journal. It can be optionally initialized with the system.

Receipt Number

This field displays the receipt number for the monies received.

Func Invoice Amount

This non-editable field displays the invoice amount expressed in terms of your company's functional currency.

Func Discount Amount

This non-editable field displays the discount amount expressed in terms of your company's functional currency.

Func Amount Received

This non-editable field displays the amount received expressed in terms of your company's functional currency.

Func Discount Taken

This non-editable field displays the discount taken expressed in terms of your company's functional currency.

Func Adjustment Amt

This non-editable field displays the adjustment amount expressed in terms of your company's functional currency.

Table Information

Changes in this screen update the AR_DETL_HS (AR Detail History) tables.

Top of Page