Month: January 2022

Supply Allocation is Not Allocating

You might have enabled the Supply Allocation feature, created Allocation Strategies, setDemand Preferences for Supply Allocation, however, the Allocated Supply column inyour transaction (e.g. Sales Order) is still 0 even if there are quantities On Order.One possible reason why the Supply will not be allocated is failing to populate theLocation in your Purchase Order. When… Continue reading Supply Allocation is Not Allocating

Supply Allocation

Supply allocation is one of the important features of advanced inventory management. When we enable the supply allocation feature we can meet the demand requirement with the right product, amount, and location by the required time period. Supply Allocation matches inventory supply sources to demand sources. Inventory Supply Sources are Purchase Order, Transfer Orders, and… Continue reading Supply Allocation

ERR_CONNECTION_REFUSED – SCA Local setup issue

Reason In a NetSuite account, we can create multiple domains. But SSL certificate implementation can only be done for a single account. So, if we tried to set up our SCA website locally, it will show an error in the console as given below: Solution For this situation, we can use a secured domain (SSL… Continue reading ERR_CONNECTION_REFUSED – SCA Local setup issue

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

Create group that excludes Vendor or any such records

Senario There is need to create a group that includes all the recipients except from some of the records(vendors, customer etc) Solution Create a contact saved searches. Navigation List> search> Saved search> New (Contacts) Search Title: Enter Search Title Click Criteria Click Summary Summary Type: Select Group(Include the records that are needed) Click Add Click Save Then create a Dynamic contact group:… Continue reading Create group that excludes Vendor or any such records