Anyone have any luck bringing in Payment Date and/or Payment method on an AR Aging Report? It seems like any of the "joins" won't populate that data. SuiteAnswers doesn't really say anything and leads me to think it is not possible. We are trying to look at the historical aging and see when those invoice were eventually paid.
c
C_Billings
02/07/2025, 5:08 PM
I would expect AR aging to only have open docs as of a given date / period. You need a different search to get your info
n
Noel B
02/07/2025, 5:11 PM
So we are looking at 2023 FY and it shows what was opened at that time and the transaction status (within the AR Agingin Report) is paid in full . Then when you click into one of those invoices you can see that it had been paid in 2024.
c
C_Billings
02/07/2025, 5:19 PM
Show a screen shot of what fields you are grabbing. In a search it would be the applied transaction
n
Noel B
02/07/2025, 5:22 PM
Yeah, I know about applied transactions link, but doesn't have it on the report.
r
Ricardo Contreras
02/10/2025, 10:32 PM
The AR Aging report doesn’t work in the way you want. It’s meant for unpaid transaction only and NetSuite also designed this to work as a historical report.
So for me trying to bring in Payments here is not aligned to this report. You would be better off using the AR Payments reports by payment or invoice.