Hello, does anyone knows how I can get invoice Internal IDs on an AR Report? Can't find anything that works in the field list and also the "show Internal ID" doesn't work.
k
KevinJ of Kansas
11/16/2020, 8:02 PM
are you on the A/R Aging report or the A/R Aging detail?
t
tdietrich
11/16/2020, 8:18 PM
@Lucio Nissi I recently blogged about how you can use SuiteQL to get A/R Aging - both in a detailed and summarized format - using SuiteQL. The post is here: https://timdietrich.me/blog/netsuite-suiteql-accounts-receivable-aging/
You could easily add the internal invoice ID to the query for the detailed version. You'd add "Transaction.ID" to the list of columns.
I hope that helps.
l
Lucio Nissi
11/16/2020, 9:09 PM
@KevinJ of Kansas I'm in the Aging detail
@tdietrich thanks I'll have a look!
k
KevinJ of Kansas
11/16/2020, 9:22 PM
Is there some reason transaction number/document number is insufficient?
KevinJ of Kansas
11/16/2020, 9:22 PM
I don't see a way to add internal ID.
KevinJ of Kansas
11/16/2020, 9:22 PM
Probalbly have to have a custom column and have it get updated via script/workflow