-
Transaction Saved Search to link Item Fulfillment lines to Sales Order lines
There is a Suite Answers article about this: 33986 I've been researching this for days trying to figure out the best way without having to write a script. Solution Navigate to Reports > Saved Searches > All Saved Searches > New Select Transaction link Set the following Filters under Criteria Tab > Standard Subtab: Type =…
-
Use Go To Record to open current transaction in Edit mode
Hello, Maybe I am going about this the wrong way, but I have a sales order approval flow and when the approver hits the reject button, I want to open the sales order record and make a reason field required. I thought I could do a go to record and just open in edit on the same record, but I can't seem to get it to work. It…
-
Shipment does not meet CA VAT de minimis threshold
We're using 2026.1 Wholesale Distribution NS & Avalara. Users are reporting that when they're SAVE-ing an international sales order, they're suddenly encountering the following alert, which seems to be a new thing. "Shipment does not meet CA VAT de minimis threshold((((((ShipFromcountry NOT IN ORHasMuItipIeShipFromForCA)…
-
Matrix style Customer sales order report by period
I'm looking to create a sales order summary report by period where the rows are customers and columns are fiscal periods (months). Each row is a single customer and the totals are summed up per period in columns. I've tried customizing a sales order report, I've tried saved searches, and tried workbook analytics, but I…
-
"Approve Sales Orders" bulk process skipping workflows?
We have a very simple approval workflow for sales orders on certain terms. The workflow itself works as expected when manually approving the sales order. But when we use the bulk process Sales Orders to Approve ("Approve Sales Orders"), the sales order gets approved and is set into Pending Fulfillment status, however, the…
-
Mapping Cross Subsidiary Fulfilment in Netsuite Connector
Hi, I'm having trouble mapping orders from Shopify to Netsuite using Netsuite Connector when they require Cross Subsidiary Fulfilment. The Sales Order Header needs to be for Subsidiary 1 but the line level item location per item is for a location under Subsidiary 2. Does anything have any experience doing this? Is it even…
-
Add variable to Sales Order / Invoice memo field
Is it possible to add a variable field to the Sales Order / Invoice Memo field? We create Sales Orders that cover monthly billing for an annual support contract. Each month, when we create the Next Bill, we have to update the Memo field to reflect the current month. Is there a way to add a variable for the ${month} ${year}?
-
Error after changing the quantity on a drop-ship Purchase Order: Please enter a value for amount.
We have a Sales Order with some of its lines in a Purchase Order that was created by clicking the Drop Ship link on that Sales Order line. On some of these, where the Sales Order line has Price Level set to Custom and the Rate is blank (but the Amount is not), then the Purchase order fails to save if we change the quantity…
-
Create workflow to add an item when a specific sales order form is used
Hi I am currently a NetSuite Employee and am helping out a customer. They need a specific item to be added when a specific sales order form is selected. When they enter a Sales Order, they have 2 forms that can be used. When form 2 is used they want it to automatically add an item. How can I build out this workflow? Does…
-
How to calculate Time in between last two Sales Orders?
There's probably an easy formula for this, but I can't find it.. I am trying to build a saved search and in it I need a column that shows the time between the last 2 Sales Orders. Like to find a re-order point. How do I do this?