My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comments
-
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