Subtotal cannot be displayed in the saved search when condition Mainline=true is given in the NetSuite. It is currently an enhancement.
Author: Sandhra Simon
Optimization of Workflows
Recommendations for Optimization of Workflows Combine multiple workflows that have the same logic and functions into a single workflow. Filter workflow execution by execution context and event type. Convert scheduled workflows that operate on records with static data or data that doesn’t change often to event-based workflows instead. This way, the workflows don’t run on… Continue reading Optimization of Workflows
Shipping Method is still Required when Non-Inventory Item is Added
User is prompted to select a shipping method for non-inventory items, as well as for items that have a default shipping method. Currently, when a shopper adds a non-inventory item to the cart, a shipping method is still required and calculated before checkout. This also applies when the cart contains both non-inventory and inventory items—shipping… Continue reading Shipping Method is still Required when Non-Inventory Item is Added
How To Install and Configure the NetSuite File Drag and Drop Bundle
Are you tired of the tedious process of clicking through multiple buttons to upload a file into the correct folder in NetSuite’s File Cabinet? Say goodbye to the hassle with the NetSuite File Drag and Drop feature – a convenient and cost-free bundle that enables users to effortlessly drag and drop attachments into their designated… Continue reading How To Install and Configure the NetSuite File Drag and Drop Bundle
Update External ID of the transaction/masters
The External ID of an item record is a standard field that cannot be modified through User Interface. Modification can only be accomplished through CSV Import. Solution 1. Create a CSV file, basic example is to add 2 columns: a. Internal ID – internal ID of the item record to be updated. This can be… Continue reading Update External ID of the transaction/masters
Exporting the Files from File Cabinet: Important Tips
Workaround for Bulk Download: 1. Copy Files to a Single Folder: To access the File Cabinet, go to Documents > Files > File Cabinet. Go to the folder that contains the files you want to copy. Click Copy Files. Check the box next to each file you want to copy. Under the Filters subtab, select… Continue reading Exporting the Files from File Cabinet: Important Tips
Set Item Price Level to Zero Through Updating Price Level Record
Navigate to Setup > Accounting > Accounting Lists (Administrator) Filters: Set to Price Level Click the price level you want to edit. Click Edit. In the Price Level field, you can change the name of this price level. In the Markup/Discount % field, enter: -100.0% Check the Update Existing Prices field. Click Save. After you click Save, all Item prices for that specific… Continue reading Set Item Price Level to Zero Through Updating Price Level Record
Alert “Total should not be negative” in Vendor bill
While creating vendor bill, we will be getting the alert “The total should not be Negative”. This is because the value in the amount field of vendor bill is in negative. The amount in the item lines can be negative. The total amount of the vendor bill should be always postive. This error will thrown… Continue reading Alert “Total should not be negative” in Vendor bill
Standard Legacy Tax behaviour
The first priority is from the tax item in the item record
Proposal for Automated Discount Application in Transactions
Proposal Summary This proposal outlines a custom script-based solution to automate the application of both flat-rate and percentage-based manual discounts at the item line level within NetSuite. The solution introduces a custom column field to capture discount amounts, and systematically generates corresponding discount lines to maintain transparency and traceability. The estimated time for completion… Continue reading Proposal for Automated Discount Application in Transactions