How to clear open amounts from the AR Aging

Created by Crystal Ann Harvey, Modified on Tue, 15 Jul at 8:27 AM by Crystal Ann Harvey

  • If you have an open amount on the AR Aging report that you will not be receiving payment for and just want to clear it off the report, you can do an AR Invoice Entry 'Type: Adjustment', following the Steps below (or a write off can be done).
  • If amounts are in the Retainage column, see related articles below for steps on how to clear those types of amounts.
Steps

To clear an Open amount from the AR Aging, do an AR invoice adjustment. If you need to clear more than one invoice amount, you can start new sequences in the AR Invoice Header and repeat the below steps 1-11:

Go to AR > Programs > AR Invoice Entry and start a new AR Invoice Entry batch to clear the positive Open amount (e.g. .02) or negative Open amount (e.g. -.02)

  1. Tab off SEQ
  2. Enter the Customer number
  3. Change the Trans Type from 'Invoice' to 'Adjustment' and TAB off or click the Chevron >>
  4. This will open a little invoice window
  5. Select the Invoice number to adjust (invoice/description as they appear on the Aging report).
  6. Finish changing any info. in the Header area and click the Chevron >> again
  7. In the AR Line area below, type N or + to start a new line
  8. If the Retg % field has a value in there, e.g. 10%, zero that out and any Tax.
  9. In the Amount field, enter opposite the amount that shows on the aging, e.g. if .02 shows on the Aging, then enter -.02 here (if -.02 shows on the Aging, enter .02 here).
  10. Save
  11. File > Process Batch, Validate, and Post
  12. When refreshing the AR Aging report this amount should be gone.
Note: If the amount shows in the 'Retainage' column on the Aging, follow the steps above, but instead of the 'Amount' field, use the 'Retainage' field and Post.
That will then move that amount, e.g. .02, to an Open column (Current, Over 90, etc.). Do the above steps a second time for the 'Amount' field to clear the amount from the open column and Post.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article