Skip to main content
Solved

AP Aging does not show paid vendors

  • January 5, 2026
  • 6 replies
  • 62 views

If I print AP Aging MC (summary or detail) as of December 31st, it does not show vendors paid on January 2nd. They are included in the final total but are somehow hidden(?) from showing up on aging. Our Implementation consultant (thru Support team) had said this was fixed with 25R1 but I still see this issue happening.

Has anyone else come across this for Canadian localization? Have not tested this with AR aging but I will once I enter January cash receipts. 

Both reports must show documents OPEN on the “as at date” so I am not sure why they are hidden. It is very important for the auditors.

Thank you!

Best answer by meganfriesen37

There is not a period sensitive multi-currency report that comes stock.  There is an idea here to vote for it, but it looks like there isn’t much demand as it’s been sitting here for a while.  

 

6 replies

meganfriesen37
Captain II
Forum|alt.badge.img+13

Hi - Please use the Period Sensitive versions (AP630500) of the reports if you need to track items that have subsequently been paid.

The other AP Aging reports show the current balance and the aging columns are based on the “as at date” but only include items that are still open as of today.


  • Author
  • Freshman II
  • January 6, 2026

Hi Megan,

 

Thank you for the response and suggesting another report. Just looked at this report and the problem with this one is that it does not have multi-currency option. This prints only in the functional currency. We need multi-currency option as well.

Thank you.

 

 


meganfriesen37
Captain II
Forum|alt.badge.img+13
  • Captain II
  • Answer
  • January 6, 2026

There is not a period sensitive multi-currency report that comes stock.  There is an idea here to vote for it, but it looks like there isn’t much demand as it’s been sitting here for a while.  

 


  • Author
  • Freshman II
  • January 6, 2026

That is why it would be best and will help everyone if Acumatica fixes the MC aging with an option/checkmark to show or hide items paid after the as at date. They will always be included in the as at aging total, but the user has an option to show or hide items paid subsequently.

I will add the same note on that idea. Thank you, Megan.


  • Author
  • Freshman II
  • January 19, 2026

That is why it would be best and will help everyone if Acumatica fixes the MC aging with an option/checkmark to show or hide items paid after the as at date. They will always be included in the as at aging total, but the user has an option to show or hide items paid subsequently.

I will add the same note on that idea. Thank you, Megan.

 

Again, it would be best if AP/AR multi currency aging have an option/checkmark to include or exclude items paid after the as at date. 

The period sensitive report is in functional currency. foreign currency invoices maybe from different months and exchange rates. Converting each to proper foreign amount could nightmare and extremely inefficient. This is why my suggestion above maybe the best.


  • Author
  • Freshman II
  • January 19, 2026

Further to above, the AP/AR period sensitive reports do not even show vendor currency so that means someone has to verify vendor currencies for vendors/customers. I hope Acumatica realizes this is the problem.