Use this subtask to initialize additional project A/R detail. Use this subtask extensively during system initialization, and to make corrections to project billing, cash receipt, and sales order history. This file stores additional detail for every transaction posted by the billing and cash receipt journal and is updated by the posting of these journals.
The programs used to calculate and age outstanding accounts receivable reference the Invoice Detail subtask for the transaction date, fiscal year, and period. Therefore, you should initialize invoice detail for receivables that were outstanding prior to your system conversion.
The lines in this subtask must sum to the invoice header records or you will be unable to save the record. |
Use this screen extensively during initialization, and to correct project billing, cash receipt, and sales order history.
Invoice Number, Customer Account, Customer Name
These non-editable fields display the invoice number, customer account, and customer name from the main screen.
This field stores the date on which you posted the invoice to the ledger. Initialization is optional.
The abbreviation of the transaction currency will display in this column. The formal currency names are maintained in the Currencies screen (Administration\Maintain\Multicurrency).
Enter the fiscal year in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.
Period *
Enter the period in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.
Enter the subperiod in which you posted the invoice. This field is used by the system in the calculation and aging of receivables.
This field stores the ID of the journal from which this record was posted. It is updated by the system when you post billings, sales order entry invoices, and cash receipts. It should not be initialized as part of the A/R History initialization.
This field stores the posting sequence of the journal from which this record was posted. It is updated by the system when billings, sales order entry invoices, and cash receipts are posted. It should not be initialized as part of the A/R History initialization.
For posted records, this field shows the original date for which the invoice was calculated. Note that the due date, not the invoice date, is used when calculating days outstanding. This date should match the date entered into the Initialize A/R History screen. If you enter an invoice amount, this field is required.
Enter the total amount of the receivable. This column's total amount must match the amount entered into the Initialize A/R History screen for this transaction.
If you enter an invoice amount, you will not be able to enter the amount received or receipt date on the same line. You must enter Invoice information and receipt information on separate lines.
Enter the original discount offered to the project for the invoice shown. This column's total amount must match the amount you entered into the Initialize A/R History screen for this transaction.
Enter the date you received payment for this invoice. If you enter an amount received, this field is required. If you have already entered an invoice amount on this line, you will need to add a new line for receipt information.
Enter the amount of the payment received for this invoice. This column's total amount must match the amount entered into the Initialize A/R History screen for this transaction. If you have already entered an invoice amount on this line, you will need to add a new line for receipt information.
Enter the discount taken by the client in payment of this invoice. This column's total amount must match the amount you entered into the Initialize A/R History screen for this transaction.
Enter check number of the cash receipt.
This non-editable column displays the adjustment amount to be written off. The adjustment amount cannot be greater than the balance due amount.
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 is used by Delivery invoices of projects that bill using Progress Payments. It is updated when you post Delivery invoices through the Edit Project Product Bills screen (Projects\Transactions\Billing\Enter Project Product Bills) or by DD250 invoice postings.
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 of 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 only differ from the liquidation amount when the payment of an invoice has been adjusted to reflect a different liquidation amount than invoiced.
This field is calculated when the billing is posted, based on the terms of the project. For records initialized, enter the anticipated due date. This date is used to age receivables.
This field stores the transaction description from the billing or cash receipts journal. It can be optionally initialized with the system.
This field displays the receipt number for the monies received.
This non-editable field displays the invoice amount expressed in terms of your company's functional currency.
This non-editable field displays the discount amount expressed in terms of your company's functional currency.
This non-editable field displays the amount received expressed in terms of your company's functional currency.
This non-editable field displays the discount taken expressed in terms of your company's functional currency.
This non-editable field displays the adjustment amount expressed in terms of your company's functional currency.
Changes in this screen update the AR_DETL_HS (AR Detail History) tables.