Forum Discussion
A seemingly complex task...
After thinking about this for while, it seems like a problem that should be solved in part in the transaction system, rather than in power bi. I've built picklist systems, when the order systems needs to generate a picklist there should be a set of records that attach to the order that list the pallets that were "picked"
After the pick it sounds like the number of items on some pallets will need to be adjusted and that probably should be done in the transactional database as well. Because the next order for the same item will need to know that the previously picked pallets are no longer available.
I realize you might not have that kind of choices about which systems does which actions... but it's an interesting question to think about,
We're running a pretty advanced WMS with a lot of a features.
What this report will be used for is to generate a list of product for a planned inventory move from overstock locations to foward pick locations. Essentially, they want to move enough product from overstock locations to floor locations, the night before they start picking the orders, so that the pickers aren't held up by replenishments and don't have to pick from overstock.
