hi, is it possible to expose Customer's External ID in AR Aging Report?
n
Netsuite Tragic
03/16/2021, 9:43 PM
As it's not there as an available native field, create a custom field. Populate the custom field as a copy of the external IDs.
k
KnotKnick
03/17/2021, 2:09 PM
Hi @Netsuite Tragic thanks for the suggestion. I tried using a formula to copy external id to a custom field and made the field to Not store value. On doing so, the custom field was not available on the report.
I ended up re-creating a saved search for AR Aging Report.
l
Luis
03/18/2021, 3:31 AM
@KnotKnick have you successfully recreated the AR aging report? I've been told that it's almost impossible to do so. Thanks!
k
KnotKnick
03/18/2021, 1:02 PM
hi @Luis I replicated an AR saved search using this suite answer: 85341
l
Luis
03/19/2021, 8:48 AM
@KnotKnick thank you! It shows the current AR not the historical AR, right? Meaning, if I filter it, say 02/28/2021, it will not show the open AR as of that date but the open AR as of today but including only the transactions until 02/28/2021.