Hi All,
We have orders table storing order data and locations table storing onhand, item and bin data.
I have to fill nearest empty bins with items on basis of their quantity daily ordered and in case nearest bin has less quantity I have to move that to other far bin as other fast moving item has much more on hand should go in nearest bin.
Step 1: I am able to find fast moving items along with their quantity in the existing bins they are stored from order and on hand tables.
Step 2: I am able to find bins as per ranking with quantity.
Kindly advise me logic how to build a logic for this requirement.