Skip to main content
Solved

AR Aged Period Sensitive by Date

  • July 24, 2025
  • 4 replies
  • 86 views
S
Varsity I
Forum|alt.badge.img

Can you help me? The closed invoices should no longer appear in the template, as the payments have already been applied. Also, the aging report appears to be incorrect — all entries are showing under 'Current,' which shouldn’t be the case. I’ve already set the 'Period From' and 'To' in the template,

Best answer by saintsin

Fixed
change $Docbal to 
= IIF(
    [ARRegister.DocType] = 'PMT'
 OR [ARRegister.DocType] = 'CRM',
    -1 * [ARRegister.CuryDocUnpaidBal],
    [ARRegister.CuryDocUnpaidBal]
  )

4 replies

S
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • July 24, 2025

i already fix the Closed Status i just need to fix the aging report 

S
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • July 24, 2025

Fixed
- I change the $AgeDate to Today() 

S
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • July 24, 2025

now my additional problem is the amount its not equal to the invoice

 

S
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • Answer
  • July 24, 2025

Fixed
change $Docbal to 
= IIF(
    [ARRegister.DocType] = 'PMT'
 OR [ARRegister.DocType] = 'CRM',
    -1 * [ARRegister.CuryDocUnpaidBal],
    [ARRegister.CuryDocUnpaidBal]
  )

Terms & ConditionsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved