How can I verify where items are committed? Sales Orders/Backorders/Etc.

SUGGESTED

My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly what Sage says we have on hand. HOWEVER, all 515 of those items are 'committed' to existing Sales Orders or Backorders and I cannot find out how to track where (or how, even) exactly this inventory is committed. We cannot distribute product and assign lot #s to items in sales orders until the point of shipment/invoicing.

For transparency, we recently suffered a signficant employee turnover even that has left us with very limited Sage knowledge in our Sales/Fulfillment department.

This is driving our team crazy. Can someone please help us. I am very familar with the Bill of Materials and Inventory Management modules but unfortunatley I have very little experience in Sales Orders/shipping Entry/Invoicing, etc.

Parents
  • 0

    Let just add that inventory is "committed" in the system when it is on a sales order. If you have 515 pieces left and there are 515 on sales order then all are "committed" in the sense that you have no more to sell and that you need to order more. However the system cannot tell you which lot goes with which sales order as that is not known at this point unless you have activated the option to distribute Lots during sales order entry. 

  • 0 in reply to BigLouie

    Ok, so this has been a question I had been trying to solve for a little while now, Sage online chat couldn't help me.

    So when you create a sales order (or backorder), even though no lot # are assigned/distributed at that point, inventory is 'committed' at that point? How does the system assign that?

    Also, what's the best way to circumvent the situation where you have, say, 1000 bottles on hand, but you get an order for 5,000 bottles. You put the 5,000 bottles into the system but now the 1,000 bottles are no longer available for use even though you could use those to fill a bunch of smaller orders.

Reply
  • 0 in reply to BigLouie

    Ok, so this has been a question I had been trying to solve for a little while now, Sage online chat couldn't help me.

    So when you create a sales order (or backorder), even though no lot # are assigned/distributed at that point, inventory is 'committed' at that point? How does the system assign that?

    Also, what's the best way to circumvent the situation where you have, say, 1000 bottles on hand, but you get an order for 5,000 bottles. You put the 5,000 bottles into the system but now the 1,000 bottles are no longer available for use even though you could use those to fill a bunch of smaller orders.

Children