Hi everyone, I am preparing the AR Report using <@...
# suiteql
a
Hi everyone, I am preparing the AR Report using @tdietrich query from https://timdietrich.me/blog/netsuite-suiteql-accounts-receivable-aging/. Hows possible that the total AR amount is smaller than the sum of the different balances? Did anyone had the same issue? Here's a sample of a customer: TIA
c
I've never used this query before, but by looking over it, I can't see any reason why the total would be less than the sum of its parts. Have you proofread the query to verify it's entered correctly?
a
HI @Clay Roper 🙂 thanks for your answer. Apparenyly, it's because in my company we are also using Journals in the AR reporting and by any reason, some of them are not linked to any entity..