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
Clay Roper
03/12/2022, 1:30 AM
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
Anna
03/14/2022, 9:47 AM
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..