Need a report that will show accurately the on hand inventory by selected inventory dimension on some date in the past. The inventory value report does not have level of precision needed to know where something was in a specific warehouse unless Location is being tracked financially in the Storage dimension group and it seldom is ever selected.

The Physical Inventory by Inventory dimension provides an allusion that it will provide a retrospective view into where inventory was at but this report does not.

Having a report like this is necessary to provide a complete audit traceability of where product was on a given day.