Is there a way to add bins to the stock valuation report. I need to know the value by bins. Thanks!
You could get close by building your own report:
Something like:
SELECT b.ItemID, d.ShortDesc, c.WhseBinID, a.QtyOnHand, e.AvgUnitCost, a.QtyOnHand * e.AvgUnitCost 'Value'
FROM timWhseBInINvt…
You’ll need to modify the work table it runs on and add the fields. Then modify the stored procedure the report runs on to pull those values. Make sure to back up the original sp. You’re going to need…
Probably, but would likely need a customization to the report program. Since you can get a value by warehouse, I would think that with some work it could be subtotaled by bin. The first task would be to…
You could get close by building your own report:
Something like:
SELECT b.ItemID, d.ShortDesc, c.WhseBinID, a.QtyOnHand, e.AvgUnitCost, a.QtyOnHand * e.AvgUnitCost 'Value'
FROM timWhseBInINvt a
INNER JOIN timItem b
ON a.ItemKey = b.ItemKey
INNER JOIN timWhseBin c
ON a.WhseBinKey = c.WhseBinKey
INNER JOIN timItemDescription d
ON b.ItemKey = d.ItemKey
INNER JOIN timInventory e
ON a.ItemKey = e.ItemKey AND c.WhseKey = e.WhseKey
This would be a point in time report only (meaning it's only good for that exact moment). And it assumes you use average cost. I'm not sure if you would need cost tiers but that would add complexity. AND THIS WOULD ONLY BE CLOSE.
You could get close by building your own report:
Something like:
SELECT b.ItemID, d.ShortDesc, c.WhseBinID, a.QtyOnHand, e.AvgUnitCost, a.QtyOnHand * e.AvgUnitCost 'Value'
FROM timWhseBInINvt a
INNER JOIN timItem b
ON a.ItemKey = b.ItemKey
INNER JOIN timWhseBin c
ON a.WhseBinKey = c.WhseBinKey
INNER JOIN timItemDescription d
ON b.ItemKey = d.ItemKey
INNER JOIN timInventory e
ON a.ItemKey = e.ItemKey AND c.WhseKey = e.WhseKey
This would be a point in time report only (meaning it's only good for that exact moment). And it assumes you use average cost. I'm not sure if you would need cost tiers but that would add complexity. AND THIS WOULD ONLY BE CLOSE.
Thank you very much! This work
*Community Hub is the new name for Sage City