Just to clarify, I loaded a budget into NetSuite for 2022. All i want to do is query the budget data that I loaded through excel ODBC using NetSuite2.com as my datasource. The budget was loaded by location, by account, by month. In order for me to pull this data, i need to "have installed the Expense Commitments and Budget…

thanks , i will take a look

also, the way the query is written in the article you referenced only gives you the activity, not balances, for balance sheet accounts.

what is the equivalent of this table/field in NetSuite2 data source? 'posting_account_activity post'

grouping is not the issue. What is happening is: for each account, the balance total = current balance * # of individual transactions for that account; so if Account # AAAAA has a current balance of 20 and there are 10 transactions in May, it is calculating the balance as 200...if there are 5 transactions in June, balance…

SELECT transaction_0.postingperiod, Account_0.acctnumber, Account_0.fullname, Account_0.balance FROM Account Account_0, transaction transaction_0, TransactionAccountingLine TransactionAccountingLine_0, transactionLine transactionLine_0 WHERE TransactionAccountingLine_0.transaction = transactionLine_0.transaction AND…

fyi,...i am using the NetSuite2.com data source

so my joins between transactionline and TransactionAccountingLines should be transactionline.transaction = TransactionAccountingLine.transaction and transactionline.id = TransactionAccountingLines.transactionline , correct?

If a transaction has multiple lines with different accounting for each line (ie. supplies + shipping expense), wouldn't transactionline.id need to be joined with TransactionAccountingLine.transaction to pull respective totals for each GL account?

pardon my ignorance, what exactly are solution providers and how can I reach out? I am very new to NetSuite. I've only worked with BPC and Hyperion Essbase in my previous roles.

If I wanted to pull in the following data directly into excel via SuiteAnalytics Connect... This is a variation of the Transaction Detail report under Reports->Financial->Transaction Detail