Hey there,
Trying to implement native Acumatica WMS currently. One of the things I’m butting up against is being able to see what location has the oldest inventory. Meaning, the oldest date that the inventory was put in that location. I could have one stock item in 6 locations, but I want to know which one has been sitting there the longest.
Earlier, I was directed to IN408055 - Storage Details by Item Warehouse Location. But the flaw here is that if I don’t move all of the inventory from that location, it will change the date of the inventory in that location because activity occurred there.
Has anyone else worked on this type of issue before? How did you handle it?