Inventory Valuation by warehouse location /zone

(0) Share

Report

Posted on by Phil0867

162

Is there a way that you can get an inventory valuation for a specific warehouse location/zone? For a particular location/zone I can easily pick up the inventory that is in that location. I am struggling to find how to get a valuation against this. In the item ledger tables I can see the entries that give me the cost details, just by manually comparing quantities and lot numbers, but I do not know the relationship link between the inventory that exists in the warehouse entry table and the costs in the item ledger tables.

Can anyone help with how I can achieve this please?

Thanks

Phil

All responses (1)

Answers (0)

BCgs 468 on at

Like (0)

Report

RE: Inventory Valuation by warehouse location /zone

Hi Phil

There is this "items by location" table (you have to be under items to be able to search it) you can filter by location but this does not show and of the pricing details on just the inventory. I usually filter by warehouse > export to excel and then lookup the pricing. Possibly would need to get a developer to modify this table to extend the available data.

Would be interested to know if there was an easier way to do this as this is my current solution and a bit long winded