Use this screen to maintain the invoice, receipt, and sales order history for a specific project or customer. You will use this screen extensively during initialization and to make corrections to project billing, customer billing, cash receipt, and sales order history. This file stores every transaction posted by the billing and cash receipts journals and is updated whenever these journals are posted.
Invoice detail stored in this table is used in the calculation and aging of project and customer accounts receivable. Please note that any changes made directly to the Maintain A/R History screen do not update the General Ledger or Project Ledger balances. This screen does not reflect unposted billings or cash receipts.
Use this screen extensively during initialization and to correct project billing, cash receipt, and sales order history. Changes made on this screen must also be made in the Invoice Detail subtask before you save.
Select this check box to include finance charges on your outstanding invoices. This box is selected by default.
Select the All radio button 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 Days Outstanding field is calculated 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 non-editable field displays the average number of days the selected customer invoices are overdue.
If this field is left blank, the invoice number will be system-created. The invoice number is a unique number used to identify individual billings. If you plan to initialize invoice detail, then you must initialize this field as part of the project accounts receivable history initialization. For records posted by the system, this field is used to identify the receivable amounts for projects.
There are two special invoice numbers created by the cash receipts program. These are the INT and UNK invoice numbers. The system will use the customer's account number for the first part of the invoice number and end it with INT. The INT invoice represents the amount of finance charges accrued and paid by the customer. The system will use the UNK plus a unique number to create an UNK invoice. The UNK invoice represents cash received from a specific customer that has not been distributed to existing invoices.
This field displays the abbreviation of the transaction currency. The currency names are maintained in the Maintain Currencies screen in Costpoint Multicurrency.
Enter the total amount of the receivable.
Enter the amount of cash received for this invoice.
The system calculates the balance due by adding the Amount Received and the Discount Taken fields and subtracting the sum from the Invoice Amount field.
This field displays the finance charge that was calculated 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 Charges Computed and subtracting any Charges Received.
Enter, or use to select, the project number to which this invoice was posted, if applicable.
Enter, or use to select, the account to which this invoice was posted. The system validates that this is an account reserved for billed accounts receivable.
Enter, or use to select, the organization for this invoice.
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 the Invoice Date, when calculating days outstanding. For initialized records, enter the date the invoice was prepared.
For line items that are invoices, the system calculates this field when you post the billing, based on the terms of the project. For records being initialized, enter the anticipated due date. This field is used to age accounts receivable. For line items that are cash receipts, there is no due date requirement.
Enter the customer PO number, if applicable.
Enter the original discount offered to the project for the invoice shown.
Enter the project bill number of the invoice, if applicable.
Enter, or use to select, the customer account to which this invoice was posted, if applicable.
Enter the address code that was used for this invoice.
Enter, or use to select, the reference number 1 to which this invoice was posted, if applicable.
Enter the applicable sales order, if an invoice is generated from a sales order.
Enter, or use to select, the reference number 2 to which this invoice was posted, if applicable.
This field displays the rate group code that is used for this customer's transactions. Rate groups identify the source of exchange rate data.
This field displays the customer name.
Enter the discount taken by the client in payment of this invoice.
This field displays the adjustment amount to be written off. The adjustment amount cannot be greater than the Balance Due amount.
This field displays the last date a cash receipt was recorded for this invoice. It is updated when cash receipts are posted.
This field is used by all types of invoices and is updated when you post. 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. It is imperative that projects using Progress Payment bills be initialized with the correct invoice types. The calculation process for both Progress Payment bills and Delivery invoices rely 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 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 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. If the invoice is not blank or S (Standard), this amount can be changed as long as the amount is also changed in the Invoice Detail subtask.
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. If the invoice is not blank or S (Standard), you can change this amount as long as you also change the amount in the Invoice Detail subtask.
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 displays the account that was used to record the liquidation.
This field is used by progress payment invoices. 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 system calculates the value in this column by subtracting the Due Date field 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, in your company's functional currency, the total amount of the receivable.
This field displays, in your company's functional currency, the original discount offered to the project/customer for the invoice shown.
This field displays, in your company's functional currency, the amount of cash received for this invoice.
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 discount taken by the client in payment of 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.
The system calculates this column by subtracting the sum of the Func Amt Rcvd plus the Func Disc Taken from the Func Invc Amt.
This field displays, in your company's functional currency, the finance charge received for this transaction.
Select this check box to maintain current exchange rate information (today's exchange rate between the billing and the functional currencies). If this check box is unchecked, 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 field displays the total for all invoice amounts shown.
This field displays the total for all discount taken amounts shown.
This field displays the total for all amounts received shown.
This field displays the adjustment amount to be written off. The adjustment amount cannot be greater than the Balance Due amount.
This field displays the total for all balance due amounts shown.
Click this button to open the Customer Notes subtask and enter notes about the customer being 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 Exchange Rates subtask. Use this subtask to enter the type of currency received in payment for the selected invoice. You can use this subtask to override the currency type in the Currency field. Remember to use the Change Rates function in the Exchange Rates subtask when changing currency.
Click this button to open the Invoice Detail subtask, which is used to initialize additional project A/R detail.
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 the detailed sales tax information for the invoice highlighted on the main screen.