Scenario
A user needed to identify the correct customer level Accounts Receivable balance in NetSuite while working in a Multi Currency environment.
The user noticed that the consolbalance field on the Customer record displayed a real time consolidated balance, while financial reports such as the General Ledger report showed a different Accounts Receivable amount for the same customer.
For example, the Customer record displayed a consolidated balance of $4,440, while the General Ledger report showed $6,000. Because the values did not match, the user wanted to determine which value represented the accurate and reliable customer Accounts Receivable balance and where to find the correct real time balance as of a specific date.
Solution
The recommended way to verify the correct customer Accounts Receivable balance is by using the Accounts Receivable Aging Summary or Accounts Receivable Aging Detail report.
These reports provide the customer balance based on the selected As Of Date filter, making them the most reliable source for determining the customer Accounts Receivable balance for a specific point in time.
The Consolidated Balance field on the Customer record behaves differently because it includes all balances, including transactions dated in the future. As a result, the balance displayed may not always match date based financial reports.
Additionally, the General Ledger report displays balances by accounting period, which can also lead to differences when compared to real time customer balances.
For accurate customer level Accounts Receivable reporting as of a specific date, use the Accounts Receivable Aging reports with the appropriate As Of Date filter applied.
-----
If you find this information useful, let us know by reacting or commenting on this post!