To set up your NetSuite account to print shipping labels in EPL or ZPL format: Set up your NetSuite account to print using either EPL or ZPL format. Printer types that can use this format include certain Zebra, Eltron, and Epson printers. ZPL format is available for FedEx, USPS, and UPS shipping accounts and offers… Continue reading Print Shipping Labels with Thermal Printer
Author: Sreelakshmi R
Interact with Backend Suitelet
In Netsuite Customization Client script executes in the logged-in user’s role. This can create errors while trying to access records for which the logged-in user doesn’t have the required permission. The solution is to call a backend suitelet from the client script. We suggest If you need to use that value in the client script for setting… Continue reading Interact with Backend Suitelet
Script Overriding Role Permissions
In the role setup, there will not be any permission to a record ie. create/view/edit/full access will not be provided. But we can essentially utilize the EXECUTE AS ADMIN in the server-side script deployment and set it to Administrator it runs the script with all privileges of Admin. For eg: If a particular role has… Continue reading Script Overriding Role Permissions
Updating Shipping Address Fields in Bulk
The phone number is not displayed in the SHIP TO address. But if we open the address sub-record it is there in the address fields. Unmark the Override Checkbox and hit save it sets the address phone number in the SHIP TO address. Instead of reselecting every address in each transaction, we are doing the… Continue reading Updating Shipping Address Fields in Bulk
Auto-Invoice
The script will create an invoice from the Item Fulfillemrnts for the same items & quantity shipped for a specific user and role. We are using the Sales Order transformation method for achieving this.
Reorder Point Search
Search Criteria: Type is Inventory Item Formula (Numeric) is greater than 0 case when NVL({locationreorderpoint},0)-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0) > 0 AND NVL({locationpreferredstocklevel},{locationreorderpoint})-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0)> 0 then ROUND(NVL({locationpreferredstocklevel},{locationreorderpoint})-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0)) else 0 end Inactive is false Location is all Inventory Location is 02 – Warehouse Preferred Vendor – Buyer (Custom) is all Results: FIELD SUMMARY TYPE FUNCTION… Continue reading Reorder Point Search
Order Items Page- Time Phased Search
Search Criteria: Item : Type is Inventory Item Item : Inactive is false Formula (Numeric) is 1 case when REGEXP_LIKE ({item.inventorylocation}, {location}) then 1 else 0 end Formula (Numeric) is not 1 case when {ordercreated} is null then 1 else 0 end Item : Replenishment Method is Time Phased Search Results: … Continue reading Order Items Page- Time Phased Search
Calculate Quantity per Item on the Order Items Page
The formula to calculate for the quantity of each item that shows on the Items to Order page if the Replenishment Method = Reorder Point: (Preferred stock level + quantity needed ) less (quantity available + quantity on order ) Where: A. Quantity Needed = The Quantity on Sales orders* and Transfer Orders. *Quantity on… Continue reading Calculate Quantity per Item on the Order Items Page
(USA) Lowes MC Label Button for Sales Order
Proposal summary OX Tools USA would like to include an option in Sales Order to print item labels related to it, In a Predefined Layout, for both USA and Canada. Requirement OX Tools USA would like to add the Lowes MC Label button to the sales order page in NetSuite for USA and Canada Subsidiaries.… Continue reading (USA) Lowes MC Label Button for Sales Order
Restrict Default Payment Option Populated in Sales Order
Restrict Default Payment Option Populated in Sales Order