PROPOSAL SUMMARY
This Proposal is to show the availability of items on a sales order in the item Sublist. When an item is selected, the item count will be displayed based on the primary location opted initially. Here, we add an additional column that will display the availability for both the warehouses
REQUIREMENT
Would NetSuite be able to show us how many items we have in both warehouses at the same time when we type the SKU? So, when we are entering orders, the system automatically shows us how many items we have in either Miami or Dallas warehouse depending on the primary location or the warehouse that was preferred to the client, but it will be much easier when we enter an SKU, we can see the inventory on both warehouses and then we can pick which SKU is shipping from which warehouse
OUR SOLUTION
The requirement is achievable by deploying a client Script that will trigger the values based on the Item selected. The execution process will contain the following steps.
- On the item sublist, we’ll create two-column fields.
- The item sublist fields are named ‘AVAILABLE MIAMI’ and ‘AVAILABLE TEXAS.’
- When a user selects an item, the available Quantities for that item are displayed on each warehouse column field.
- This script is only performed when users are using the NetSuite UI to create sales orders.
ASSUMPTIONS
- For the purpose of displaying the quantity, we only consider Miami and Texas locations
ESTIMATED EFFORT
Total Estimated Hours: 8 hrs