Skip to main content
Solved

AR Aged Period Sensitive by Date

  • July 24, 2025
  • 4 replies
  • 53 views

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

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 24, 2025

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 24, 2025

Fixed
- I change the $AgeDate to Today() 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 24, 2025

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

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • July 24, 2025

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