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.
- The cost is automatically assigned at the time of purchase.
- 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
- Solution ID
- 222924650021894
- Last Modified Date
- Thu Sep 26 18:49:48 UTC 2024
- Views
- 0