Hello, does anyone knows how I can get invoice Int...
# suiteanalytics
l
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
are you on the A/R Aging report or the A/R Aging detail?
t
@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
@KevinJ of Kansas I'm in the Aging detail @tdietrich thanks I'll have a look!
k
Is there some reason transaction number/document number is insufficient?
I don't see a way to add internal ID.
Probalbly have to have a custom column and have it get updated via script/workflow