This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi! I’m trying to build an AR Aging report in Netsuite. I now have my AR Aging report, and I wonder if it’s possible to add a “Transaction ID” column such that I can search each Transaction by ID?
Below is what I have, and seems like this is NOT the transaction ID I’m looking for… Any helps please?

<@U04JL5LBZ7X> i think you're looking for "Document Number"

Hey <@UHQ6BDUAX>, the “Document Number” can be null, while the transaction ID is not Nullable. Each transaction corresponds to a Transaction ID in Netsuite database. That’s what I’m looking for. But not sure where to add this column on this report… Still, thank you for your response!

Screen Shot 2023-07-07 at 4.45.24 PM.png

Hey Luis, there are some transaction numbers. But, I’m not sure if the transaction number column can be used as primary key for all transactions or not… Do you have any ideas?

Screen Shot 2023-07-07 at 4.52.32 PM.png

ok, just ran a simply query. It seems that the transaction number can’t be used as primary because its unique count is not equal to Transaction ID’s unique count.