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
-
No I'm not. I configured the ODBC connection on the window machine and basically am using a powershell script to do the query. ... Which gives me a clear pointer on where to look next for extending the Timeout Value. NB. in the mean time I solved this by loading chunks of the table, which I upsert into a datastore.
-
I think I saw that the first time, below the post of Apr 15, 2008 9:03PM. I clicked No there. It would be great I I could Click Yes on one of your later posts. Like the post I screenshotted below Here's the screenshot:
-
This was the answer I was looking for. The forums asks me to click a button, however there is no button visible: If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar…
-
Hi, @Nicole Mendoza-Oracle :, it can be an ODBC or JDBC query on any table, e.g. SELECT * FROM salesInvoiced; In the mean time I found out that I can that I can select the first 10 rows by using SELECT TOP 10 * FROM salesInvoiced; But how to I specify a limit with offset, to get the next 10 rows?
-
Hi @Micah Timbol-Oracle, Here's an answer to your questions. What steps did you undertake to get into this error? I already have an Suiteanalytics ODBC Connection, ODBC drivers installed on windows. I then execute this query: """ SELECT Subsidiary.name AS subsidiary_name, BUILTIN.DF (Customer_SUB.representingsubsidiary_0)…
-
@user10648298 This answer isn't helpful, the link does not work. I have the same issue and want to know the solution
-
ps. I ended up joining with consolidatedExchangeRate, and multiplying by er.currentrate left join consolidatedExchangeRate er on er.postingperiod = transaction.postingperiod and er.fromsubsidiary = transactionLine.subsidiary and er.tosubsidiary = 1 That kind of solved the issue
-
Hello @Nicole Mendoza-Oracle , I guess that is the core of the problem. Why can I do : sum(transactionLine.foreignamount), and why is sum(TO_NUMBER(BUILTIN.CURRENCY_CONVERT(transactionLine.foreignamount))), Not allowed? Summing the transactionLine.foreignamount is useless, since it adds EUR to ZAR....
-
Hi Steve, That did the trick! Thanks a lot! Cheers, Bart