Manufacturing, Distribution, and Internet Applications

[Ralph]

v7.30.2

The Inventory History BIA is a useful report that shows quantity on hand at month-end for every month in which a transaction occured for any given item/whse combination.   However, it seems to be considering a cost tier adjustment as a transaction, even though it doesn't change QOH.   We would prefer that this report simply ignored cost tier adjustments, and only showed us records for months in which a transaction was made that changed an item's QOH.  If it's possible to exclude cost tier adjustments from this report, I would guess it would be done by making a minor change to the WHERE clause in vdvInventoryHist.  Anyone?

[tbrasel]

I wish it was that easy.  vdvInventoryHist  uses the timInvtFiscPerHist table which captures the qty on hand for each fisc period.  It doesn't include any transactional information, so you can't filter or exclude certain types.

You might be able to build something around the transaction or transaction history views, but it may take a little work.

Good Luck!

[John_Mitchell]

Hey guys-

You ever notice on the pivot table for BIA inventory history that if the qty on hand doesn't change the next period show a blank? Maybe its just me?