Use this screen to select AR invoices with a balance due that are eligible to be written off. You can enter the adjustment amount, then automatically create and post the journal entry to a pre-selected account/org combination. The adjustments should only be amounts that your company considers uncollectible. This process will update the A/R balances in the A/R history tables and not affect the billing or revenue amounts. The A/R balance will also be updated in the General Ledger A/R account(s). Due to the nature of this process, we suggest using Costpoint's screen security to restrict user access to this screen.
In order to keep accurate accounting records, you should clear off those A/R amounts that you have no reasonable hope of collecting. Companies generally set a fixed period, starting from the date of the invoice, in which they expect to collect the outstanding invoices (e.g., 120 days). Once this time period has passed and collection efforts have failed, use this screen to charge the outstanding A/R amount to a write-off or bad debt account.
You can clear outstanding, uncollectible amounts from the A/R Aging Report by performing these steps:
Enter the Customer Account.
Select the invoice you want to write off.
Enter the amount to be written off in the Adjustment column.
Preview the write-off, then click the Print/Post A/R Adjustment button on the toolbar.
Once the posting process is complete, the Adjust A/R Underpayment Amounts report will print. This report will contain the accounts that were debited and credited in addition to the subperiod in which they were posted.
Use this screen after reviewing your company's A/R Aging Report. After determining which invoice amounts are uncollectible and receiving proper authorization, use this screen to clear these amounts from your receivables. This function will NOT affect any billing or revenue amounts.
For proper functioning of this screen, you must first set up the account and organization that will receive these write-offs. This process will first look at the settings in the Default Accounts subtask of the Maintain Customer screen. The table in this subtask identifies the account and organization selected for this transaction type (Cash Receipts/AR Adjustments). If no account and organization have been selected here, you can add a Cash Receipts/AR Adjustments row to the subtask table. If no default account is found for Cash Receipts/AR Adjustments in the selected customer account, this process will then use the default account and organization selected in the A/R Settings screen for these write-offs.
Enter, or use to select, the customer account number in this field. The field to the right is automatically populated when you select a customer account.
Use this drop-down list to select the desired range of invoices to display in the table. Valid options are All, One, Range, From Beginning, and To End. The default for this field is All.
Enter a valid starting invoice number for the range specified in the Range Option field. If you select All or From Beginning as the Range Option, this field will be unavailable.
Enter a valid ending invoice number for the range specified in the Range Option field. If you select All, One, or To End as the Range Option, this field will be unavailable.
Enter the earliest date for the range of customer invoices you want to select. Invoices with the same or earlier dates will be retrieved when this optional field is used. For example, if you enter the first date of your company's fiscal period and click the Fill Table button, all invoices posted in this fiscal period will display in the table.
Select this check box to use the same proj/org combination that was used when the bill was initially posted. The system default is checked.
If you select this check box, invoices in the A/R history without a negative balance will be included in this table.
Select this check box if you need to make an adjustment or correction to a zero balance invoice. This feature can reverse an adjustment previously made using this screen. Do NOT use this feature for adjustments to billing or revenue.
Do not select this check box if adjustments are not necessary for zero balance invoices. The system default is unchecked.
Enter, or select from the drop-down list, the fiscal year for posting the accounts receivable adjustments. Only open fiscal years will be available for selection.
Enter, or select from the drop-down list, the period for posting the accounts receivable adjustments. Only open periods will be available for selection.
Enter, or select from the drop-down list, the subperiod for posting the accounts receivable adjustments. Only open subperiod will be available for selection.
This non-editable field displays the subperiod ending date.
Click this button to populate the table based on the selected customer and invoice range.
This non-editable field displays the status of the Cash Receipts Journal.
If you did not select Include Zero Balance Due check box, this table displays all outstanding invoices with a positive balance for the selected customer.
Use the Fill Table button to populate this table for the selected customer and subperiod.
This non-editable column displays the invoice number.
This non-editable column displays the original date for which the invoice was calculated.
This non-editable column displays the total amount of the invoice.
This non-editable column displays the balance due from the A/R history table.
Enter the adjustment amount to be written off. The Adjustment amount cannot be greater than the Balance Due amount.
You can use a negative number to reinstate any amounts that have been previously removed using this screen.
Enter up to 60 alphanumeric characters to describe this adjustment. These notes will not be posted if the Adjustment column is empty or is equal to 0.00.
This non-editable column displays the transaction currency of the outstanding invoice.
This non-editable column displays the project number.
This non-editable column displays the bill number. The bill number is a second invoice identifier, separate from the system invoice number; it is usually used to track project-specific billing numbers required by a particular job.
This non-editable column displays the invoice type.
This non-editable column displays the amount of cash received for this invoice.
This non-editable column displays the discount taken by the project for this invoice.
This non-editable column displays the liquidation taken on this invoice.
This non-editable column displays prior adjustments, if any. If a prior adjustment amount is greater than zero, the balance due will reflect the net total of: amount invoiced less discounts taken, less amount received, less prior adjustments (Inv. Amt. - Discounts Taken - Amt. Recd. - Prior Adjustments).
Click this button on the toolbar to post the accounts receivable adjustments. A list of accounts receivable adjustments will be printed after posting. Unless you have used or , you cannot review or edit the adjustments before posting.
Click this button on the toolbar to print, then immediately post, the accounts receivable adjustments. A list of accounts receivable adjustments will be printed after posting. Unless you have used or , you cannot review or edit the adjustments before posting.
Changes to this screen update the following tables:
AR_DETL_HS
AR_HDR_HS
POSTING
SEQ_GENERATOR
Z_ARPPADJ_GL_DETL