Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Which value is the correct customer-level A/R balance in NetSuite?
In NetSuite, which value represents the correct customer-level accounts receivable (A/R) balance?
On the customer record, there is a field called “consolbalance”, which displays the real-time consolidated A/R balance.
In addition, you can also check the customer-level A/R balance using financial reports, such as the General Ledger report.
However, sometimes these values do not match.
For example, the consolbalance field on the customer record shows $4,440, but the General Ledger report shows $6,000 for the same customer.
We are using Multi-Currency.
Which of these values is the accurate and reliable customer A/R balance?
And where can we find the correct real-time A/R balance as of a specific date?
0