MAINTAIN A/R HISTORY

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.

Org security can be applied to this function. This optional feature allows you to grant or remove rights to view and/or update specific organizations to users. In order to do so, you must first set up the necessary org security screens in Costpoint System Administration. You can then activate org security through the use of the Maintain Users and System Settings screens in that module. For more information about org security and how to apply it, see System Administration Special Topic SA-5, Organizational Security, and the function documentation for org security in the System Administration documentation.

Include Finance Charge Info

Select this check box to include finance charges on your outstanding invoices. This box is selected by default.

All

Select the All radio button to display all outstanding invoices.

At Least      Days Outstanding

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.

Average Days Over

This non-editable field displays the average number of days the selected customer invoices are overdue.

Table Window

Before you can add a new line to the table, you must have already added invoice detail for the previous line using the Invoice Detail subtask, which is opened by clicking the Invoice Detail button.

Invoice Number

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.

The INT function is not available at this time.

Trans Curr

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

Invoice Amount

Enter the total amount of the receivable.

Amount Received

Enter the amount of cash received for this invoice.

Balance Due

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.

Finance Charge Computed

This field displays the finance charge that was calculated for this invoice.

Finance Charge Received

This field displays the finance charge that was received for this invoice.

Net Amount Due

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.

Project

Enter, or use to select, the project number to which this invoice was posted, if applicable.

Receivable Account

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.

Organization

Enter, or use to select, the organization for this invoice.

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 the Invoice Date, when calculating days outstanding. For initialized records, enter the date the invoice was prepared.

Due Date

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.

Customer PO Number

Enter the customer PO number, if applicable.

Discount Amount

Enter the original discount offered to the project for the invoice shown.

Bill Number

Enter the project bill number of the invoice, if applicable.

Customer Account

Enter, or use to select, the customer account to which this invoice was posted, if applicable.

Address Code

Enter the address code that was used for this invoice.

Ref 1

Enter, or use to select, the reference number 1 to which this invoice was posted, if applicable.

Sales Order Number

Enter the applicable sales order, if an invoice is generated from a sales order.

Ref 2

Enter, or use to select, the reference number 2 to which this invoice was posted, if applicable.

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.

Customer Name

This field displays the customer name.

Discount Taken

Enter the discount taken by the client in payment of this invoice.

Adjustment Amount

This field displays the adjustment amount to be written off. The adjustment amount cannot be greater than the Balance Due amount.

Last Receipt Date

This field displays the last date a cash receipt was recorded for this invoice. It is updated when cash receipts are posted.

Invoice Type

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

Delivery Amount

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.

Liquidation Amount

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.

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

Liquidation Account

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.

Unliquidated Account

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.

Days Over

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.

Func Invoice Amount

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

Func Discount Amount

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

Func Amount Received

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

Func Finance Chg Comp

This field displays, in your company's functional currency, the finance charge that was calculated for this invoice.

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

Func Balance Due

The system calculates this column by subtracting the sum of the Func Amt Rcvd plus the Func Disc Taken from the Func Invc Amt.

Func Finance Chg Rcvd

This field displays, in your company's functional currency, the finance charge received for this transaction.

Curr Exch Rt

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.

Functional Currency Totals

Invoice Amount

This field displays the total for all invoice amounts shown.

Discount Taken

This field displays the total for all discount taken amounts shown.

Amount Received

This field displays the total for all amounts received shown.

Adjustment

This field displays the adjustment amount to be written off. The adjustment amount cannot be greater than the Balance Due amount.

Balance Due

This field displays the total for all balance due amounts shown.

Customer Notes

Click this button to open the Customer Notes subtask and enter notes about the customer being invoiced.

Contacts

Click this button to open the Contacts subtask and maintain contacts by invoice for the customer being invoiced.

Exchange Rate

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.

Invoice Detail

Click this button to open the Invoice Detail subtask, which is used to initialize additional project A/R detail.

Invoice Notes

Click this button to open the Invoice Notes subtask and enter notes about a specific invoice.

Sales Tax

Click this button to open the Sales Tax subtask, which displays the detailed sales tax information for the invoice highlighted on the main screen.