Forum Discussion
A seemingly complex task...
What you are describing is quite doable...but you are right, its complex. Would you like to do a video session and look over the steps you need to take ? It would be much easier that going back and forth in email.
Email me [email protected] with a good time to talk and I'll send you a Zoom invitation.
Power BI is easy to learn, but it has hard parts.
|
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.
