or 
to populate the table window. This screen displays all the outstanding invoices for both projects and customers. The information displayed in the table window is driven by the number of days outstanding as entered in the Days Outstanding field.
The information displayed in this screen is stored in the Accounts Receivable History tables. If you want to enter or change information displayed in this screen, use the Maintain A/R History screen. Please note that changes made directly into the Maintain A/R History screen do not update the General Ledger or Project Ledger balances.
You will normally use this screen after posting all of the cash receipts and billings for the accounting period. It displays only invoices that have a balance due of greater than zero and that have been outstanding for at least the number of days entered in the Days Outstanding field. It does not show invoices or cash receipts that have not been posted.
Select this check box to include finance charges on your outstanding invoices. This checkbox is selected by default.
Select the All option to display all outstanding invoices.
Select the At
Least option and enter
up to four digits representing the minimum number of days outstanding
for your inquiry. Only invoices with a Days
Outstanding field equal to or greater than the number you enter will
be displayed. Note that the system calculates the Days
Outstanding by subtracting the due date from the system date.
Once you have entered the number of days outstanding, use or to populate the table window.
This display-only field shows the average number of days that the selected customer invoices are overdue.
This field displays the invoice number. The invoice number is a unique identifier that is used to identify the receivable amounts for projects and customers
This field displays the customer account number.
This field displays the customer name associated with the account.
This field displays the project number.
If your company enters a customer PO number on the billing, the system will post it into the accounts receivable history, and it displays here.
This field displays the bill number. The bill number is a second invoice identifier, separate from the system invoice number. It is usually used to track project-specific billing items required by a particular job.
This field displays the sales order number if an invoice is created because of a sales order.
This field displays the address code to which the invoice was billed.
This field displays the General Ledger account to which the invoice was posted during billing.
This field displays the organization to which the cash receipt was posted.
These fields display the reference number to which this cash receipt was posted, if reference numbers are used in posting cash receipts.
This 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.
This field displays the due date. The system calculates it, based on the terms of the project, when the billing is posted.
This field displays the abbreviation of the transaction currency. The currency names are maintained in the Maintain Currencies screen in Costpoint Multicurrency.
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.
This field displays the total amount of the receivable. The Balance Due column reflects the invoice amount still outstanding.
This field displays the original discount offered to the project for the invoice shown.
This field displays the amount of cash received for this invoice.
This field displays the discount taken by the project for this invoice.
This field displays the adjustment amount to be written off. The adjustment amount cannot be greater than the Balance Due amount.
The system calculates this field by subtracting the sum of the Amount Received plus the Discount Taken from the Invoice Amount.
This field displays the finance charge that was computed for this invoice.
This field displays the finance charge that was received for this invoice.
This field displays the net amount due. The system calculates this value by adding the invoice Balance Due to the Finance Charge Computed and subtracting the Finance Charge Received.
This field displays the last date a cash receipt was recorded for this invoice. It is updated when posting cash receipts.
This field is used by all types of invoices and is updated during the posting process. If the invoice is a standard bill, project product bill, or manual bill, this field will contain an S. If the invoice is a progress payment bill, the invoice type will be P. If the invoice is a delivery bill, the invoice type will be D. You must initialize projects using progress payment bills with the correct invoice types. The calculation process for both progress payment bills and delivery invoices relies on these values. (For more information on progress payment bills, please see Billing Special Topic BL-7, Progress Payment Bills.)
This field is used by delivery invoices for projects that bill using progress payments. It is updated when you post delivery invoices from the Edit Project Product Bills screen in Costpoint Billing or post DD250 invoices from Costpoint Sales Order Entry. This field contains the full amount of the shipped finished good.
This field is used by delivery invoices for projects that bill using progress payments. It is updated when Delivery invoices are posted through the Edit Project Product Bills screen in Costpoint Billing or by DD250 invoice postings 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.
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.
This field is used by delivery invoices for projects that bill using progress payments. It is updated when Delivery invoices are posted through the Edit Project Product Bills screen or by DD250 invoice postings from Costpoint Sales Order Entry. This field displays the account that was used to record the liquidation.
Progress payment invoices use this field. It is updated when progress payment bills are posted. This field displays the account that was used to record the unliquidated amount.
If the balance due is greater than zero, the value in this column is calculated by subtracting the Due Date from the current (today's) date. If the Balance Due field is less than or equal to zero, the Days Outstanding field is set to zero. Please note that only invoices that have a Balance Due field not equal to zero are shown on this screen.
This field displays the total amount of the receivable expressed in terms of your company's functional currency. The Func Balance Due column reflects the functional invoice amount still outstanding.
This field displays, in your company's functional currency, the original discount offered to the project for the invoice shown.
This field displays the amount of cash received for this invoice expressed in terms of your company's functional currency.
This field displays, in your company's functional currency, the discount taken by the customer for this invoice.
This field displays, in your company's functional currency, the adjustment amount to be written off. The adjustment amount cannot be greater than the Func Balance Due amount.
This column is calculated by subtracting the sum of the Func Amount Received plus the Func Discount Taken from the Func Invoice Amount.
This field displays, in your company's functional currency, the finance charge that was calculated for this invoice.
This field displays, in your company's functional currency, the finance charge that was received for this invoice.
Select this check box to maintain current exchange rate information (today's exchange rate between the billing and the functional currencies). If you do not select this check box, the system will maintain historical exchange rate information (the rate between the billing and functional currencies that existed at the time the bill was created).
Selecting and then clearing this check box will maintain both current exchange rate information and historical exchange rate information.
This non-editable field displays the total of the Invoice Amount column in terms of your company's functional currency.
This non-editable field displays the total of the Discount Taken column in terms of your company's functional currency.
This non-editable field displays the total of the Amount Received column in terms of your company's functional currency.
This non-editable field displays the total of the Adjustment Amount column expressed in terms of your company's functional currency.
This non-editable field displays the total of the Balance Due column in terms of your company's functional currency.
Click this button to open the Customer Notes subtask and enter notes about the customer who is invoiced.
Click this button to open the Contacts subtask and maintain contacts by invoice for the customer being invoiced.
Click this button to open the Invoice Detail subtask, which displays the detail of the invoice in relationship to the posting of the bills and the cash receipts.
Click this button to open the Invoice Notes subtask and enter notes about a specific invoice.
Click this button to open the Sales Tax subtask, which displays detailed sales tax information for the invoice highlighted on the main screen.