Contents of the Manage Accounts Receivable History Screen

Use the fields and options to configure the Manage Accounts Receivable History screen.

Note: Organizational 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 organizational security screens in Costpoint System Administration. You can then activate organizational security through the use of the Manage Users and Configure System Settings screens in that module. For more information about organizational security and how to apply it, see the documentation for organization security in Costpoint System Administration.

Contents

Field Description
Customer Account

Enter, or click to select, a customer account to view.

Customer Name

Enter, or click to select, a customer name to view.

Project

Enter, or click to select, a project to view.

Include Finance Charge Info

Select this check box to include finance charges on your outstanding invoices.

All

Select the All option to display all outstanding invoices.

At Least and 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 that you enter are displayed. The Days Outstanding field is calculated by subtracting the due date from the system date.

Average Days Over

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

Functional Currency Totals

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

Realized Gain/(Loss) This field displays the total amount of the Realized Gains column minus the total amount of the Realized Losses column.

Recalculation Method

Field Description
Rate Re-Calculate

If the rate information changes, use this button to recalculate the header and line amounts using the new rate information.

Update Totals

If the invoice information changes, use this button to update the header total amounts using the new invoice information.

Table Window

Note: You must add invoice detail on the Invoice Detail subtask screen (click the Invoice Detail link at the bottom of the Manage Accounts Receivable History screen) before you can add a new line to the table.
Field Description
Invoice Number

If you leave this field blank, the invoice number will be system-created.

The invoice number (up to 15 characters) is a unique number that is 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 uses 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 uses the UNK plus a unique number to create a UNK invoice. The UNK invoice represents cash received from a specific customer that has not been distributed to existing invoices.

Note: 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 on the Manage 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

If you are initializing, then enter, or click to select, the project number to which this invoice was posted.

Otherwise, the project displayed is the project to which the invoice was posted.

Receivable Account

Enter, or click 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 click to select, the organization for this invoice.

Invoice Date

For posted records, this field displays the original date for which the invoice was calculated. The system uses the Due Date rather than the Invoice Date to calculate days outstanding. For initialized records, enter, or click to select, the date that 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, or click to select, 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 click to select, the customer account to which this invoice was posted.

Address Code

Enter the address code that was used for this invoice.

Ref 1

Enter, or click to select, the reference number 1 to which this invoice was posted.

Note: The field Ref 1 may display a different label if it has been changed on the Configure General Ledger Settings screen. For example, the label may have been changed to AC 1.
Sales Order Number

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

Ref 2

Enter, or click to select, the reference number 2 to which this invoice was posted.

Note: The field Ref 2 may display a different label if it has been changed on the Configure General Ledger Settings screen. For example, the label may have been changed to AC 2.
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. The possible values are:

  • S: This value displays if the invoice is a Standard Bill, Project Product Bill, or Manual Bill.
  • P: This value displays if the invoice is a Progress Payment bill.
  • D: This value displays if the invoice is a Delivery bill.

    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 related topic in Billing, 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 Manage 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 Manage 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 Manage 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 the total amount of the receivable in your company's functional currency.

Func Discount Amount

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

Func Amount Received

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

Func Finance Chrg 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 FuncBalance 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 Chrg Rcvd

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

Realized Gain

This field displays the sum of any realized gains on currency exchange from the invoice detail. 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 the sum of any realized losses on currency exchange from the invoice detail. 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.
Func Net Amount Due

This field displays the net amount due in functional currency, including any posted realized gain/loss and any finance charges. This value is calculated by adding or subtracting any realized gain or loss (respectively), and by adding any finance charge to the Func Balance Due.

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

When you select and then clear this check box, both the current exchange rate information and historical exchange rate information are maintained.

Subtasks

Subtask Description
Contacts Click this link to open the Contacts subtask to maintain contacts (by invoice) for the customer being invoiced.
Exchange Rates Click this link to open the Exchange Rates subtask. Use this subtask to enter the type of currency that you 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 Apply button in the Exchange Rates subtask when you change currency.
Invoice Detail Click this link to open the Invoice Detail subtask to initialize additional project A/R detail.
Invoice Notes Click this link to open the Invoice Notes subtask to enter notes about a specific invoice.
Sales Tax Click this link to open the Sales Tax subtask. It displays the detailed sales tax information for the invoice highlighted on the Manage Accounts Receivable History screen.
Finance Charges Computed Click this link to open the Finance Charges Computed subtask. Use this to view the details of the calculated finance charges for the invoice that you select on table window.
Finance Charges Received Click this link to open the Finance Charges Received subtask. Use this subtask to view the details of the finance charges received for the invoice that you select on the main screen.