Skip to main content
Solved

AR Aged Period Sensitive by Date

  • Jul 24, 2025 12:59 AM UTC
  • 4 replies
  • 110 views
  • Translate All
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]
  )

View original

4 replies

Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • Jul 24, 2025 6:19 AM UTC

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

Translate
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • Jul 24, 2025 7:46 AM UTC

Fixed
- I change the $AgeDate to Today() 

Translate
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • Jul 24, 2025 8:04 AM UTC

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

 

Translate
Varsity I
Forum|alt.badge.img
  • saintsin
  • Author
  • Varsity I
  • Answer
  • Jul 24, 2025 9:25 AM UTC

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

Translate
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