Contents of the Manage Accounts Receivable History Screen
Use the fields and options to configure the Manage Accounts Receivable History screen.
View Receivables and Collections
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. |
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
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:
|
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. |