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?"
Loading
Comments
-
Hello User_MTM71 we use an ODBC driver to connect Excel and a SQL database to connect to NetSuite. There is a lot of information in SuiteAnswers re: connecting depending on your scenario General info OAuth 2.0 for Connect SuiteAnswer 106877 Authentication for SuiteAnalytics Connect SuiteAnswer 106876 More specific steps we…
-
Yes Thank you, I understand the difference between the prior periods cumulative Net Income/Retained Earnings and the Clarisa De Torres-Oracle I was having difficulty getting my Custom Trial Balance (view = Total for now) to match the delivered Trial Balance re: the Retained Earnings section. My end goal is the Trial…
-
Hello Clarisa De Torres-Oracle I am reconciling my Custom Trial Balance to the delivered Trial Balance with a "Total" View and the same As Of Dec 2024 Inc. Global (Consolidated), for now. Each account on my CAD Balance Sheet used in TB by Subsidiary Rpt ("Custom Report") matches the delivered Trial Balance except Retained…
-
Yes, thank you Clarisa De Torres-Oracle I started there but I didn't see how to "move" my existing rows in between the Header and the Summary… Now I see how easy that is, by just selecting "Child Of" for each… Yes, seems a better choice… Heading that direction and will update when complete. Thanks so much.
-
Yes, Thank you Clarisa De Torres-Oracle I am working through that… I was hoping for a simple Sum all rows above… As you can imagine, when building a Trail Balance by Subsidiary, using the above process (so far it is working) is time consuming enough to list each account separately…. but now to have to do the same thing to…
-
Thank you for the details, Camille Cagalingan-Oracle Now that I have followed the steps above, How do I Sum the report to validate the results? Thanks.
-
All, As you vote for any SuiteIdea…. Please add a comment that details your business case. It is important information as NetSuite considers acting on each SuiteIdea. SuiteIdea 174031
-
I see the Balance Sheet & Income Statement now have a footer filter for "Column" that includes a selection for Subsidiary. This is great for these reports but is also necessary for the Trial Balance. If anyone else would find this useful on a Trial balance please vote for SuiteIdea 174031 and add a comment that details…
-
I see now the Balance Sheet & Income Statement now have a footer filter for "Column" that includes a selection for Subsidiary. This is great for these reports but is also necessary for the Trial Balance. If anyone else would find this useful on a Trial balance please vote for SuiteIdea 174031 and add a comment that details…
-
User_ZWIS9 OPTION 2: Another thing I do to send data to and from JIRA is leverage Celigo . We have the CRM module, here. When a new entry to our custom record occurs, I created a workflow that uses information on the custom record to create a NetSuite issue. I use Celigo to pick up the NetSuite Issue information, send it…
-
Hello User_ZWIS9 Not knowing which NS edition or modules you have… Take a look at the Compliance 360 SuiteApp Compliance 360 Activity Log Compliance 360 Dashboard Audits in Compliance 360 There are other links at the bottom of each of these SuiteAnswer links that may interest you. If you don't already have it, ask your…
-
C
-
User_4RAZZ I hate suggesting this… Can you hard code the sequence to 24001 and update the 24 each year? At this point, I would create a NetSuite Support ticket. If the YY: field is a standard field, this could be a NetSuite defect. I don't know if you have NetSuite Support but if you can demonstrate that a behavior could…
-
User_4RAZZ I'm not sure. I would try testing this SuiteAnswer #34303 with one sequence, then see if your next transaction/lot respects the leading zeros.
-
User_4RAZZ So hope you are all set.
-
I logged a case with NetSuite and their development team worked on it & confirmed there is no native way to use the ODBC to retrieve a comparison between the Invoice Download Items and the files attached to the items so that I can compare the Customer entitlement to what is in the Customer Download Center. They did not…
-
Jervin Nicholas Teopengco-Oracle Just letting you know I have not forgotten your suggestion. Thank you.
-
Richard James Uri-Oracle Yes, we store the files that are attached to the items in the NetSuite File Cabinet. When we query the File Table we get results. The difficulty is retrieving the specific files attached to the item sold and tying those to the Customer Download Center. We are trying to validate that when we invoice…
-
Thank you, Richard James Uri-Oracle I can get the query to run and logically it makes sense, but we get no results returned. In Symmetry's Item table, none of our items have a value stored in the "storedisplaythumbnail" column. We don't use the web store so we don't store thumbnails. I see this field (or storedisplayimage)…
-
User_4RAZZ Does your Sequence # need to be 00001 instead of the leading 1?
-
NE_JohnC ooops, I just noticed you originated that thread… sorry. Also found this Saved search with Columns by Class you might take a look at.
-
Hello NE_JohnC Take a look at I am looking to create a saved search for Inventory on hand with a separate column for each locatio and adjust it for your fields. you will need a formula to accomplish this as well as grouping. in the results tab you will want a formula Numeric - Summary Type Sum or you can use Max your…
-
Hello Jervin Nicholas Teopengco-Oracle Yes, thank you. I saw your response and shared it with my Data Warehouse team. I will update when I get their response. Thanks so much for the follow up.
-
JimmyC_SR None for me… I found this (NetSuite WSDL version 2016.2 deprecation) on Celigo's site which relates to an earlier version but still applies I did get this information from NetSuite Support Upon further investigation, we have identified that one or more of your integration records in your account is utilizing an…
-
JimmyC_SR See if this thread helps What is WSDL and how do I upgrade the version?
-
JimmyC_SR We use Celigo to integrate some of our systems and this is where I updated mine. Hope it helps
-
Thanks. Richard James Uri-Oracle Support's answer doesn't solve my issue. Thanks
-
Thanks Richard James Uri-Oracle The following is my exchange with Support. Me: Thank you, Joseph for the script. The shipMethod field is not available to access through the Connect ODBC because the Multiple Shipping Routes feature is not enabled in our implementation. We are a Software company that delivers our product…
-
All and Richard James Uri-Oracle I also logged a case with NetSuite Support and this is their response: Sounds great, we were able to locate the shipmethod field, kindly follow these steps in retrieving the said field: Under the Records catalog, under the Records tab, search for Transaction. Present on the overview tab of…
-
Thank you Richard James Uri-Oracle We don't need and are not "using" the feature but we do see and use the "field" . We sell software licenses and subscriptions and don't actually "ship" anything. The Licenses are "downloaded" so we use a shipping method of download. I can report on the field in a Saved Search using a…