Help, I have several items which have committed inventory greater than 0, but I don't have any open work orders, layaways, back orders Purchase orders, or transfers (in/out). How do I find out which transaction created the committed inventory? How do I adjust the committed inventory?
Thanks in advance for your help
Jay
Jay -
What version are you running? We are on 1.3.0203 (*gasp*) and I know that when a work order, back order, or layaway are deleted (i.e. delete all line items from it, save changes) the inventory does not really reset itself to what it should be.
You can quickly set all inventory committed = 0, but that would really not be a good idea if you have open work ord, back ord, layaway, xfers etc. But because you said you do not have any of these, you would for SO or HQ:
How do I set all inventory committed to 0 ?
jocelynp wrote:
By using the query below in Admin.
Start> All Prgms> MS Retail Mgmt> SO Admin or HQ (not sure of your environment you are writing in about)
File> Connect> Enter SQL Srv password> OK
Database> Backup
Query> New> copy and paste: Update Item SET QuantityCommitted = 0> F5 to run
Have something to add? Share your thoughts — no account required.
Ask the community — no account required