This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Why would there be no `balance` column in `account` table? Apparently, it was removed. What are other way to pull balance in an account? TIA

Screenshot 2024-07-11 at 5.24.01 PM.png

This is what I get when running a query in Query Tool by <@U856E2SEA>

<https://archive.netsuiteprofessionals.com/t/374487/can-we-fetch-account-and-account-balance-data-from-netsuite-#a20f8e06-e990-43e1-8f52-ccb764857dce>

If I remember correctly, the balance column is disabled if you have multicurrency enabled.

you would still want balance if you enable multi currency :facepalm:

<@U29QCJQF3> I will try joining the account line record, thanks