Forum Discussion
A seemingly complex task...
Hey all, I've got what might be a fun one for all you experts. Here's what I'm trying to do: If any of you have a background in warehouse management, you might get this right off the bat. I'm...
So
If your orders were in a relationship to your inventory.
And you created a slicer for your orders.
When you selected an order in the slicer.
It would filter your inventory.
If you had your inventory table sorted by pallet id by Lot_no first, which is sequential, and then by FIFO_date, then you could create a "running total" for each product, and you would be able to see how many pallets you needed to pick to hit the number needed by the order.
Then the question is, how do you want to transmit/print the pick list to the warehouse ?
Yes, we also need to create a running total measure as well, so that we can compare to ordered quantity.
And yes, I have a relationship between orders and inventory via an item_no master table.