Skip to main content
Answer

Credits showing as current in AR Aging

  • September 28, 2023
  • 3 replies
  • 163 views

Forum|alt.badge.img

Hi,

I have recently set a client’s AR Aging report to display by Document Date, as shown in the second image below. However, in the AR Aging report, they have noticed that credits are still showing in the current column when they should be showing in a different column.

 

For example, the image below shows how both the credit and invoice have the same document date. However, the credit is sitting in the current column and the invoice is in the last column.

 

 

Is there a reason why credits would be sitting in the Current column? I was thinking it could be because they were not yet applied to an invoice, but wasn’t sure if this was the case.

 

If these credits are in fact displaying in the wrong column, what would you recommend I change in the AR Aging report to amend this?

 

Kind regards,

Andrew

 

 

Best answer by Laura03

Hello, Check ON the option to Age Credits in AR Preferences screen.

Laura

3 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • September 28, 2023

Hello, Check ON the option to Age Credits in AR Preferences screen.

Laura


Forum|alt.badge.img
  • Author
  • Varsity I
  • September 28, 2023

Awesome, thanks so much Laura!

Kind regards,

Andrew


Forum|alt.badge.img+1
  • Acumatica Moderator
  • August 6, 2024

Here is the logic for the Age Credits setting:

If the Age Credits is not selected on the AR Preference, the Prepare Statements process calculates the amounts in the aging buckets using the following algorithm: it deducts balances of unapplied payments, prepayments, and credit memos from the balances of the overdue invoices starting from the rightmost aging bucket; if the open balance of credit documents is greater than the amount in the rightmost bucket, the remainder will be deducted from the previous column, etc. If the total balance of open credit documents exceeds the total balance of debit documents, the difference will be reflected in the Current bucket.