Managing Inventory for Different Order Types
Stored Procedure: Designating Two Primary Bins for One Item
The end result gives flexibility to designate a primary bin for sales orders, and a primary bin for Service/Production Orders. For any item allocated to a bin, which was not in the main zone, the stored procedure moves the allocation to the designated bin the Service/Production Zone. Allocations are left alone if there is no quantity available in the Service/Production Zone. This solution allowed all of this to happen in real time – as the pick ticket is generated.