ADJUST A/R UNDERPAYMENT AMOUNTS

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:

  1. Enter the Customer Account.

  2. Select the invoice you want to write off.

  3. Enter the amount to be written off in the Adjustment column.

  4. Preview the write-off, then click the Print/Post A/R Adjustment button on the toolbar.

Hint: You can also use this screen to reverse any posted adjustment that may need to be added back to the customer's account. Simply enter a negative adjustment amount for the invoice and run the posting process.

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.

Warning: Do not use this screen to void or adjust an invoice.

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.

Customer Account

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.

Invoice Number

Range Option

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.

From

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.

To

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.

As of Invoice Date

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.

Post Adjustment to Billed Project

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.

Include Zero Balance Due

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.

Period to Post

Fiscal Year

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.

Period

Enter, or select from the drop-down list, the period for posting the accounts receivable adjustments. Only open periods will be available for selection.

Subperiod

Enter, or select from the drop-down list, the subperiod for posting the accounts receivable adjustments. Only open subperiod will be available for selection.

End Date

This non-editable field displays the subperiod ending date.

Fill Table

Click this button to populate the table based on the selected customer and invoice range.

Journal Status

This non-editable field displays the status of the Cash Receipts Journal.

Table Window

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.

Invoice Number

This non-editable column displays the invoice number.

Invoice Date

This non-editable column displays the original date for which the invoice was calculated.

Invoice Amount

This non-editable column displays the total amount of the invoice.

Balance Due

This non-editable column displays the balance due from the A/R history table.

Adjustment

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.

Notes

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.

Trans Curr

This non-editable column displays the transaction currency of the outstanding invoice.

Project

This non-editable column displays the project number.

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

Invoice Type

This non-editable column displays the invoice type.

Amount Received

This non-editable column displays the amount of cash received for this invoice.

Discount Taken

This non-editable column displays the discount taken by the project for this invoice.

Liquidation Taken

This non-editable column displays the liquidation taken on this invoice.

Prior Adjustments

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

Post A/R Adjustment

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.

Print/Post A/R Adjustment

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.

Table Information

Changes to this screen update the following tables:

AR_DETL_HS

AR_HDR_HS

POSTING

SEQ_GENERATOR

Z_ARPPADJ_GL_DETL