Contents of the Edit/Manage A/R Underpayment Amounts Screen

Use the fields and options to configure the Edit/Manage A/R Underpayment Amounts screen.

Identification

Field Description
Customer Account

Enter or click to select the customer account number in this field. The unnamed field to the right displays the customer name.

Options

Field Description
As of Invoice Date

Enter the earliest date for the range of customer invoices that you want to select. Invoices with the same or earlier dates are retrieved when this optional field is used. For example, if you enter the first date of your company's fiscal period and click , all invoices posted in this fiscal period 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 are included in this table.

Select this check box if you want to make an adjustment or correction to a zero balance invoice. This feature can reverse an adjustment that was 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 check box is clear as system default.

Selection Ranges

Invoice Number

Field Description
Option

From the drop-down list, select the desired range of invoices to display in the table.

The options are:

  • All: Select this option to include all available invoices. The Start and End fields are disabled for this option.
  • One: Select this option to include only one invoice. You must enter that invoice number in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of invoices. You must enter the beginning invoice number for the range in the Start field and the ending invoice number of the range in the End field.
  • From Beginning: Select this option to include all the invoices from the beginning of the available invoice numbers to a specific invoice number in the range. You must enter the last invoice number for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the invoices from a beginning specific invoice number to the end of all the available invoice numbers. You must enter the invoice number from which the range should begin in the Start field. The End field is disabled for this option.
Start

If you selected One, Range, or To End in the Invoice Number Options field, enter a valid starting invoice number for the invoice number option. If you selected All or From Beginning in the Invoice Number Option field, the Start field is unavailable.

End

If you selected Range or From Beginning in the Invoice Number Options field, enter an ending invoice number for the invoice number option. If you select All, One, or To End range option, the End field is unavailable.

Period to Post

Field Description
Option

This field displays One to indicate that you can adjust A/R underpayment amounts for one fiscal year, period, and subperiod.

Fiscal Year

Enter or select from the drop-down list the fiscal year for posting the accounts receivable adjustments. Only open fiscal years are available for selection.

Period

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

Subpd

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

Ending Date

This non-editable field displays the subperiod ending date.

Table Window

If you did not select the Include Zero Balance Due check box, this table displays all outstanding invoices with a positive balance for the selected customer.

Use the button to populate this table for the selected customer and subperiod.

Field Description
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 are not 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 there are any. If a prior adjustment amount is greater than zero, the balance due reflects the net total of: Invoice Amount minus Discounts Taken minus Amount Received minus Prior Adjustments.