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.
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.
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.
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.

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.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

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.
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.
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.
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.

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.