In order to show up the items on the order item page we need to set the re-order point and stock levels in the item record. Order Items Page, The Order Items form provides a list of items that need to be ordered from vendors. NetSuite suggests the quantity to order based on your preferred… Continue reading How to make Items Available In the Order Items Page
Tag: Order items page
Use Reorder Multiple on Purchase Order and Sales Order
Scenario Currently, the Reorder Multiple feature only works on the Order Items page. Solution Should the user wish to enforce order multiples in the Purchase Order and Sales Order, you may perform the following alternate solutions: A. For Purchase Order, assume the following: Inventory Item = Item A Desired Order Multiple = 5 The user may create an Item Group with… Continue reading Use Reorder Multiple on Purchase Order and Sales Order
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
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