Invoice Detail Subtask

Use the Invoice Detail subtask on the View Receivables and Collections screen to view invoice and cash receipt detail for the selected invoice and customer after invoices and cash receipts are posted. You can view all of the detailed activity information for an invoice and the payments made on that invoice.

This detail is located in the AR_DETL_HS table, which is updated when you post the Billing Journal and the Cash Receipts Journal. You can maintain the AR_DETL_HS table on the Manage Accounts Receivable History screen.

You cannot edit any of the fields on this screen.

You can view invoice detail at any time. On the View Receivables and Collections Inquiry screen, highlight the row in the table window that contains the customer invoice for which you would like to see detail and select the Invoice Detail link.

Contents

Field Description
Invoice Number

This displays the invoice number that is entered for this transaction on the Manage Accounts Receivable History screen.

Customer Account

This displays the customer account from the View Receivables and Collections Inquiry screen.

Customer Name

This displays the customer name from the View Receivables and Collections screen.

Table Window

Field Description
Trans Date

This non-editable field displays the date on which the invoice was posted to the ledger.

Trans Curr

This field displays the abbreviation of the transaction currency used for billing or cash receipts.

You set the billing currency by project on the Other Info tab of the Manage Project Billing Information screen.

You set the pay currency to be used when entering cash receipts in the Exchange Rates subtask of the Manage Cash Receipts screen.

You can initialize and maintain abbreviation names on the Manage Currencies screen.

Fiscal Year

This non-editable field displays the fiscal year in which the invoice was posted. The system uses this information when calculating and aging receivables.

Period

This non-editable field displays the period in which the invoice was posted. The system uses this information when calculating and aging receivables.

Subperiod

This non-editable field displays the subperiod in which the invoice was posted. The system uses this information when calculating and aging receivables.

Source

This non-editable field displays the two-character ID of the journal from which this record was posted. The system updates this information when billings and cash receipts are posted.

Posting Seq No

This non-editable field displays the posting sequence of the journal from which this record was posted. The system updates this information when billings and cash receipts are posted.

Invoice Date

For posted records, this non-editable field displays the original date for which the invoice was calculated. Please note that the due date, rather than the invoice date, is used when calculating days outstanding.

Invoice Amount

This non-editable field displays the total amount of the receivable, as posted to the system or as entered into the Manage Accounts Receivable History screen for this transaction.

Discount Amount

This non-editable field displays the original discount offered to the project for the invoice shown. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Receipt Date

This non-editable field displays the date you received payment for this invoice.

Amount Received

This non-editable field displays the amount of the payment received for this invoice. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Discount Taken

This non-editable field displays the discount taken by the client in payment of this invoice. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Check Number

This field displays the check number of the cash receipt. It is a display-only field.

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 displays 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. This field is used by delivery invoices for projects that bill using progress payments. This field is updated when Delivery invoices are posted through the Manage Project Product Bills screen in Costpoint Billing or by DD250 invoice postings from Costpoint Sales Order Entry.

Liquidation Taken

This field initially displays a value that represents 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. This field is used by delivery invoices for projects that bill using progress payments.

Due Date

This non-editable field displays the due date that is calculated when the billing is posted, based on the terms of the project. This date is used to age receivables.

Transaction Description

This non-editable field displays the transaction description from the billing or cash receipts journal.

Receipt Number

This field displays the cash receipt number for the monies received.

Func Invoice Amount

This non-editable field displays, in your company's functional currency, the total amount of the receivable as posted to the system or as entered into the Manage Accounts Receivable History screen for this transaction.

Func Discount Amount

This non-editable field displays, in your company's functional currency, the original discount offered to the project/customer for the invoice shown. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Func Amount Received

This non-editable field displays, in your company's functional currency, the amount of the payment received for this invoice. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Func Discount Taken

This non-editable field displays, in your company's functional currency, the discount taken by the client in payment of this invoice. This column's total amount should match the amount stored on the Manage Accounts Receivable History screen for this transaction.

Func Adjustment Amt

This field displays the adjustment amount to be written off, expressed in terms of your company's functional currency. The functional adjustment amount cannot be greater than the FunctionalBalance Due amount.

Realized Gain

This field displays 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. 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 Receipt Detail Open the Cash Receipt Detail subtask to view the detail of the cash receipt in relationship to the posting of the bills and the invoices.
Finance Info Open the Finance Info subtask to view the details of finance charge information for selected invoices in relationship to the posting of the bills and the invoices.
Exchange Rates Open the Exchange Rates subtask to review AR transactions that occur in a currency other than your company's functional currency.