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
Author: Sreelakshmi R
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
TLV Encoding
As per Zakat, Tax and Customs Authority (ZATCA) of Saudi Arabia, one of the main requirements is the implementation of QR codes on tax invoices in the e-invoicing project (Fatoora), which will be mandatory starting December 4, 2021 As per the ZATCA instructions(Page No. 23), the minimum requirements that must be shown after scanning a QR… Continue reading TLV Encoding
Restrict line-level field change based on Condition
Disable Line level fields based on condition
We have the user event script serverWidget method to disable the entire column specifically. But if we need to disable/change the visibility of a specific cell in a row and column of a line it is not possible to use the user event script. Proposed Solution: Using DOM element in Script to disable the particular… Continue reading Disable Line level fields based on condition
Override System preference of Tax Setup
Based on another Event Address “Trade Show Location” rather than the Address of the customer all tax rate calculations in the Cash sale record should take place.
Commerce Redirect Page
Requirement: Whenever changes happen to item record URL Component (under Webstore subtab) or URL fragment in Category or Subcategory record changes we have to create Redirects (Navigation – Commerce>Hosting>Redirects) Risk Redirects are not Scriptable. Alternative Solution We can potentially use the import option for Redirect creation/Updation (Navigation – Commerce>Hosting>Redirects>Import). We will create a custom record… Continue reading Commerce Redirect Page