NSC | Determining the Correct Customer Level Accounts Receivable Balance in NetSuite

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.