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.

  • 0

    You cannot track this because there is no way to know which lots will be distributed to which sales order when shipped.  There is an option in Sales Order that allows you to distribute Lots or Serial Numbers during Sales Order Entry so the order pickers would know which lot goes where. 

  • 0
    SUGGESTED

    I'd query the raw tier distribution data entry tables.

    If you don't find  anything, run rebuild sort files for IM.

  • 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

    OnSO / OnBO certainly reduces what is Available... but cost tier quantities are not Committed unless assigned to transactions.

  • 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.

  • 0 in reply to Eric M.

    Be sure you are not confusing the different "Committed" values.

    Inventory quantities marked as "Committed" on tab 1 Main are not (necessarily) locked, and this is an automatic calculation.

    Inventory quantities marked as "Committed" on the Cost Detail tab (for Lot/Serial items) are locked, and that is not done automatically.

  • 0 in reply to Kevin M

    Ok, our situation is the latter, although that helps us more with understanding some things. If quantities are being committed on the cost detail tab and it is isn't occurring automatically, is that being done manually during the sales order/shipping data entry process? I feel like we should know where these orders are and how the inventory is being committed. 

  • 0 in reply to Eric M.

    You are making a fundamental mistake.  Just because you have a sales order for 5,000 bottles nothing prevents you from shipping the 1,000 bottles to someone else.  Say you don't have to ship the 5,000 for a month and you know you can get more in 2 weeks and this week you have an order for 1,000 so you ship the 1,000 bottles more, order 5,000 to cover the other order and things are fine.

  • 0 in reply to BigLouie

    Well the problem that is happening is that, somehow, items are getting committed to orders and then made unavailable for future orders, even though we have plenty on the shelf or 'on hand'. I'm trying to figure out where that mistake is occurring and how to track it, i guess. 

  • 0 in reply to Kevin M

    Sorry for my lack of knowledge but where can i find these tables. I am actually familiar with the rebuild sort files, i can do that.