Sales orders that have disappeared/been deleted are still affecting inventory.

We have a sales order that disappeared somehow; it was inadvertently deleted or not saved after entering, it's not clear which. When I went to re-enter the sales order, I'm being told that one item has none in stock, although all that were on the original invoice should be available. When I checked the item in IM it says that we have so many on hand, but that twice that amount are committed on sales orders. I checked on the Orders tab, looked under Sales Order, and there was nothing there beyond the SO that I had just entered. What is the procedure for getting rid of "stuck" sales orders? We have at least one other item that has a similar issue. We have enough inventory problems of our own making without Sage adding new ones.

  • 0

    Your issue is that you are talking about BOTH Sales Orders and Invoices.  A Sales Order does not reserve inventory the way an Invoice does when you enter a Lot or Serial number. Well unless you are committing Lots and Serial Numbers during Sales Order entry. 

    The common way is to rebuild the sort files. First post all invoices, make sure the invoice data entry files are empty. Then rebuild the inventory and sales order sort files. When you do inventory it will ask you if you want to clear committed, answer yes. That should fix it.

  • 0 in reply to BigLouie

    It's telling me in IM that  the items are committed on sales orders. There's only one sales order with the item on it, and the quantity on that sales order is 3.5, but I'm being told that 7 are committed. I'm using Sage 2018 with data levels at 6.0, if that makes a difference.

    We have been entering everything into sales order, and converting them to invoices just before we update. We keep the invoice data entry files empty as much as possible for the sake of our employee who works remotely and is 6 hours ahead of the rest of us. I take it that we can rebuild files with sales and purchase orders entered without creating issues?

  • 0 in reply to melinda_b

    It is best to rebuild the files when there are no unposted invoices.  Rebuild the sorts for inventory and sales order and clear committed.

  • 0 in reply to BigLouie

    That won't affect open Sales Orders? We are unlikely to ever have all Sales Orders converted to invoices and posted.

  • 0 in reply to melinda_b

    Rebuild sort files on SO recalculates the "On SO" / "On BO" values for each warehouse, considering open orders.  Rebuild sort files on IM does a similar correction on cost tier data (lot / serial quantities).