Receiving quantities different from order quantities

Forgive me if this is a cryptic question but what is the best way to order box quantities yet receive them as individual units.  Example: My PO says I want to purchase 1 box of 50 count #10-32 screws but I need to receive them in as 50 individual screws.

  • Hi Dennis,

    Since it looks like you are using Sage 50 US, I am going to move your post to that Support Group so that other users of this software will see it and can offer you their thoughts and insight.

    Thanks,
    Derek

  • After you set up the stocking unit of measure and the Item Multi pack when you purchase a quantity of 10 & receive them the quantity on hand is 500.

  • in reply to KimClement

    Thank you Kim.

  • in reply to Dennis Herdegen

    Dennis,

    Your welcome. Inside of Sage is a Help Menu that does explain this further, but I believe pictures are so much easier to follow.

  • in reply to KimClement

    If you don't mind, maybe you can help me with this question.  Then I will leave you alone.

    We would like to have a BOM with fixed item numbers.  Lets say we name one of these BOM items "Face Plate".  "Face Plate" is an off the shelf item readily available at Lowes & Home Depot.  However, when we go to purchase "Face Plate", we have to order Item "Square Plate" from Lowes and item "Metal Plate" from Home Depot.  Is there a way to set up Sage 50 where we can have both "Square Plate" and "Metal Plate" be assigned to our "Face Plate" item when either shipment is received?

    Hope I made this clear.

  • in reply to Dennis Herdegen

    I'll take a stab at it.

    If you have to purchase a Metal Plate and a Square plate separately, regardless of who you purchase from, then both of those parts are identified as "Stock" in Sage 50.

    When you purchase Metal Plates from Lowes, then receive them into your inventory, they are going to a stock item called Metal Plates. The exact same thing happens when you purchase Square Plates from HD. So now you have received both of these items and you are ready to build the Face Plate.

    Since both of those items are part of a Face Plate, then you set up Face Plate as an "Assembly" item and under the bill of materials tab for Face Plate you add (1) for the quantity of Metal Plate and (1) Square Plate.

    Then you  build the assembly for Face Plate which takes the quantities you entered on the bill of materials for the 2 stock items (1 each) out of the stock items and adds the quantity you built (1) to Face Plate.

    Now you can sell a Face Plate.

    If on the other hand you can purchase a "Face Plate" that includes both the Metal and Square Plate you will need to set up another Item ID for Face Plate as a stock item.

    For example, the Assembly Item ID-Face Plate-ass

    Stock would just be Face Plate

    Best regards,