Stock Valuation Report by Bins

Question

Is there a way to add bins to the stock valuation report. I need to know the value by bins. Thanks!

JohnHanrahan · Accepted Answer

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.

pmaldonato · Answer

You&rsquo;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&rsquo;re going to need a SQL resource. The schema is well documented in the Schema Browser. If you have an in-house SQL resource you can do it. If not you&rsquo;re going to need a partner.

Ramon M. · Answer

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 get bins added to the sort/selection grids. After that you would probably need to set up some processing assumptions for bin status, pending quantities, etc. Probably not a small customization, but likely not big either. Contact your Sage partner for an idea of what it would take.I can't think of any simple ideas of the top-of-mt\y-head.

Sage 500

Stock Valuation Report by Bins

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING