Skip to main content
B
b3bt459
April 3, 2019
Solved

COGS/reordering bulk purchase, individual sale

  • April 3, 2019
  • 1 reply
  • 0 views

My supplier sells in bulk.   5 widgets in a bag.   I sell them individually.  We I receive the item  I can set the qty to 5 & divide the cost to get an appropriate COGS.  However, when I attempt to reorder, the purchase price is incorrect & I end up having to modify the PO price.

Best answer by

Looks like your on Desktop - you should switch on the system option for Inventory  'units of measure'.

Then define a Bag5 unit for that item which contains 5 pieces.

Now you can buy and sell in single units or Bag5 units and the costing will be correct. 

1 reply

A
Anonymous
Answer
April 3, 2019

Looks like your on Desktop - you should switch on the system option for Inventory  'units of measure'.

Then define a Bag5 unit for that item which contains 5 pieces.

Now you can buy and sell in single units or Bag5 units and the costing will be correct. 

    A
    aboard2123
    April 26, 2019

    Then do you have to adjust the inventory manually?

    RenjolynC
    RenjolynC
    April 26, 2019

    Hi aboard2123,

     

    In addition to MikeinBC's answer, you'll have to switch the unit of measure option in the inventory item.

     

    Here are the steps:

    1. Click Lists located at the top.
    2. Choose Item List, and find the item.
    3. Double-click the item to open.
    4. Under Unit of Measure, select the U/M Set from the drop-down list.
    5. Click OK.

    Then, manually adjust the inventory by following the steps:

    1. On the Item List page, right-click on the item.
    2. Choose Adjust Quantity/Value On Hand.
    3. Select the Adjustment Type, Adjustment Date and Adjustment Account.
    4. Click the Find & Select Items button.
    5. Click Save and Close.

    You can also check this article for more details: Adjust inventory quantity or value.

     

    If there's anything else you need, feel free to leave a comment. Thanks.

    Terms & ConditionsAccessibility statement