My Stuff
Hello Community! Josh Maxwell, a User Experience Researcher for NetSuite Foundation has fun a question for you. Imagine for a moment that NetSuite had an assistant like Alexa or Siri. What would you ask of your NetSuite assistant? Use this survey link to share your top questions to the assistant.
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
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