Summary
This article explains two methods for entering the cost of goods sold in an inventory record: using a Purchase Invoice through sales orders or adjusting inventory costs directly using the Adjust Inventory feature, particularly when dealing with inventory that goes below zero and cost adjustments are needed.
Description
Cause
- The cost is automatically assigned at the time of purchase.
Resolution
- There is no other way to enter the cost of a good sold in an inventory record.
- The cost of a good would be tracked through the Purchase Invoice.
Option 1:
- Create a sales order to provide to the customer
- Purchase the inventory
- once inventory is received convert the original sales order to an invoice.
Option 2:
- The Adjust Inventory option could be used to change the Cost
- Using the default costing method of Average Cost, Cost is a simple calculation: Value divided by quantity
- example:
- 20 books of a total value of $1000 would mean that each book has a cost of $50
- To change the cost from $50 to $40 (for any future transaction)...
- use the Adjust Inventory feature to decrease the value of the inventory by $200
- This would change the total value from $1000 to $800. $800 / 20 equals $40
Scenario A:
- No purchase invoice was entered before sale to bring inventory in
- Sales invoice is entered while inventory goes below zero.
- Cost of Good Sold account is not affected
- Enter Purchase invoice when available
- Adjust COGS (cost) by following Option II above in this KB
DocLink: How to sell inventory below zero