-
New to NetSuite | How to Use a Scheduled Script to Automate Nightly Data Cleanups
Overview Scheduled Scripts in NetSuite allow you to automate recurring tasks such as cleanup, reporting, and record updates. For beginners, this is one of the most powerful ways to reduce manual work. In this guide, we’ll create a simple Scheduled Script that runs nightly to clean up stale or unnecessary data (e.g.,…
-
change the display order of Customer Category Accounting Lists
Is it possible to change the display order of Customer Categories to the desired order? thanks
-
New to Netsuite | Workflow to Prevent Purchase Order from Being Edited When Status Is Fully Billed
Implementing a workflow to restrict edits on purchase orders once they reach the "Fully Billed" status addresses several critical concerns in procurement management. Firstly, it helps preserve data integrity by ensuring that once financial obligations are satisfied, records cannot be inadvertently or intentionally altered.…
-
NetSuite connector - promo code issue
NetSuite connector-we have an issue on order/cash sales relating to promo code mismatch. Identical promo codes are setup in Shopify and NS. Yet, we get error in farapp that there is no matching code. Is there any setting needed in Promo code setting in NS? read about specifying 'site' in one field. but there is no such…
-
How to add a script to Mark Orders Packed?
Hello everyone! Right now I'm creating a ClientScript - pageInit script for customizing a page, but I've encountered a problem. I'm not sure if I can add the script to the /app/accounting/transactions/itemshipmanager.nl?reminders=T&type=pack&whence= page I couldn't find anything similar in the script types. (Can't attach…
-
Quotes Converted to Orders
Hello, Im trying to create a search/report that returns a percentage of quotes that have been converted into sales orders. I came across the link below on SuiteAnswers. I built search just fine but when i run the search i get the following error. Also, here are my criteria and formula. My guess is im using the wrong field.…
-
How to create a Grid Matrix Template via a Workflow "Create Record" action
Trying to create a Grid Matrix Template via a Workflow "Create Record" action, but the two following fields are showing up as required, and despite trying multiple options, I cannot find the correct values to use. Column Item ID Row Items Does anyone have an example of a "Create Record" example for creating a Grid Matrix…
-
manage intercompany sales orders via script/workflow
Hi Gurus, Is there a way to automate the pairing process of manage intercompany sales orders page via script or workflow? Right now we need to click the PO from the page everyday. We do not need to review them as they are created by integrations. So ideally even this manual step could be automated. We operate in 4…
-
Show item sales price in PO advanced pdf
Hi Experts, Hope you can help me with below advanced pdf requirement. In the purchase order PDF we need to show the sales prices (base price) for our 4 currencies: AUD, NZD, CAD, and GBP. So there would be 4 columns in the advanced pdf to show each price per currency. Item Record It is easy to pull the information if the…
-
Bug? Approved Transfer Order but Specific Serial/Lot Number is still Available.
Greetings, I work for a company that builds and sells very specific items which we track via Serial Numbers. We encounter a problem where we are able to continually create orders for the same serial number even if it is committed on an approved transfer order. The status of the serial number stays Available until someone…