Invoice Detail Subtask

Use the Invoice Detail subtask on the Manage Accounts Receivable History screen to initialize additional project A/R detail.

This subtask is used 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 that are 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 before your system conversion.

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

Contents

Field Description
Invoice Number

This field displays the invoice number from the main screen.

Customer Account

This field displays the customer account that is entered on the main screen, if applicable.

Customer Name

This field displays the customer name that is entered on the main screen, if applicable.

Table Window

Field Description
Trans Date

This field stores the date that the invoice was posted to the ledger. Initialization is optional.

Trans Curr

This field displays the abbreviation of the transaction currency. The currency names are maintained on the Manage Currencies screen in Costpoint Multicurrency.

Fiscal Year

Enter the fiscal year in which the invoice was posted. The system uses this field in the calculation and aging of receivables. Therefore, it is required if you want the system to include the invoice in this calculation.

Period

Enter the period in which the invoice was posted. The system uses this field in the calculation and aging of receivables. Therefore, it is required if you want the system to include the invoice in this calculation.

Subperiod

Enter the subperiod in which the invoice was posted. The system uses this field in the calculation and aging of receivables. Therefore, it is required if you want the system to include the invoice in this calculation.

Source

This field displays the two-character ID of the journal from which this record was posted. The system updates this field when you post billings and cash receipts. You should not initialize this field as part of the A/R History initialization.

Posting Seq No

This field displays the posting sequence of the journal from which this record was posted. The system updates this field when you post billings and cash receipts. You should not initialize this field as part of the A/R History initialization.

Invoice Date

For posted records, this field displays the original date for which the invoice was calculated. Please note that the system uses the Due Date, rather than the Invoice Date to calculate the days outstanding. This date should match the date that is entered on the Manage Accounts Receivable History screen. If you enter an amount in the Invoice Amount field, an invoice date is required.

Invoice Amount

Enter the total amount of the receivable. This column's total amount must match the amount that is entered on the Manage Accounts Receivable History screen for this transaction. If you enter an invoice amount, you cannot 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 that is entered into the main screen for this transaction.

Receipt Date

Enter, or click to select, the date that you received payment for this invoice. If you enter an amount received, this field is required. If you already entered an invoice amount on this line, you must add a new line for receipt information.

Amount Received

Enter the amount of the payment that you received for this invoice. This column's total amount must match the amount that is entered on the Manage Accounts Receivable History screen for this transaction. If you already entered an invoice amount on this line, you must 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 that is entered on the Manage Accounts Receivable History screen for this transaction.

Check Number

Enter the check number of the cash receipt.

Adjustment Amt

This field 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. Rate groups identify the source of exchange rate data.

Liquidation Amount

This field is used by delivery invoices for projects that bill using progress payments. The Liquidation Amount field is updated when you post delivery invoices from the Manage Project Product Bills screen in Costpoint Billing or post DD250 invoices from Costpoint Sales Order Entry. 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 for 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 differ from the Liquidation Amount only when the payment of an invoice has been adjusted to reflect a different liquidation amount than invoiced.

Due Date

The system calculates the due date when the billing is posted, based on the terms of the project. For records initialized, enter the anticipated due date. The system uses this date to age receivables.

Transaction Description

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

Receipt Number

This field displays the receipt number for the monies received.

Func Invoice Amount

This field displays the total amount of the receivable in your company's functional currency.

Func Discount Amount

This field displays the original discount offered to the project/customer for the invoice shown in your company's functional currency.

Func Amount Received

This field displays the amount of cash received for this invoice in your company's functional currency.

Func Discount Taken

This field displays, in your company's functional currency, the discount taken by the client in payment of this invoice.

Func Adjustment Amt

This field displays the adjustment amount to be written off in your company's functional currency. The adjustment amount cannot be greater than the Func Balance Due amount.

Realized Gain

This field displays any realized gains on currency exchange from the invoice. Gains are displayed as a positive number, even though they were posted to the G/L as a credit when the cash receipt was posted. This field is not editable.

Realized Loss

This field displays any realized losses on currency exchange from the invoice detail. Losses are displayed as a negative number, even though they were posted to the G/L as a debit when the cash receipt was posted. This field is not editable.

Note: The Realized Gain and Realized Loss values will not be recalculated if the exchange rate or other amounts on the invoice are changed.

Subtasks

Subtask Description
Cash Receipts Detail Click the Cash Receipt Detail subtask link to view the detail of the cash receipt in relationship to the posting of the bills and the invoices.
Finance Info Click this link to open the Finance Info subtask. Use this to view the details of finance charge information for selected invoice.
Exchange Rates Click this link to open the Exchange Rates subtask. Use this to review AR transactions that occur in a currency other than your company's functional currency.