Manufacturing, Distribution, and Internet Applications

[JDavis]

We have found several items that are showing pending quantity as an increase.  Upon researching we have found quantities are matching old purchase order receipts.  The problem is it is showing up as on hand inventory.  How do we get these to zero out?

[marklinder]

You can zero the amount in the timWhseBinInvt table.  There are fields in there for the pending increase and pending decrease.  We have issues like that pop up from time to time.

[JDavis]

Does anyone know why this happens?  Just trying to understand what we need to do to keep this from happening.

[marklinder]

I've seen several postings here and on the old SageTalk regarding this issue.  There are a few theories, but no one has been able to track down the source of the problem. 

[Swoboda]

I wouldn't recommend clearing them out via your own sql update.  MAS 500 does contain a SQL Qty On Recalc job that should recalculate the incorrect pending quantities.  If the job is already running and not correcting the data (which was happening frequently on versions prior to 7.3), then you can contact customer support for a revised script that will force the job to run and include all items, or any items you specify. 

In 7.30 we did improve the Qty On Recalc job and also added a Recalculate Inventory Quantities task to recalculate pending quantities, qty on so, qty on po, etc when the numbers become incorrect.  We also added a pending inventory transaction BIE view to help identify pending transactions that you may not be aware of.  When the number in the pend qty increase bucket for replenishment position does not sum to the pending quantities increase transactions, then you have a problem that requires a recalc. 

If you are not on 7.3,  the following thread has more information and a couple of queries to help identify pending transactions as well.   

http://community.sagemas.com/sagemas/board/message?board.id=VERTICAL&thread.id=159&view=by_date_asce... 

Thanks!