How to report on Inventory by Location, lot, and bin at a time in the past. (Prior Month, Year ect.)
We are a heavily based agricultural Inventory/manufacturing company. Most of our raw goods are lot tracked.
We have a need to be able to produce some a report to show inventory levels at a specific point in the past, by location, Item, Lot number, and if possible bin location. With quantity and value by lot. It would be similar to a inventory and Bin Numbers saved search, but with the transaction date as a filter.
The stock status report doesn’t return lot level information.
Does anyone have a suggestion