Average Costs

Average Costs

1. What is average costs?
  1. This is the average cost the quantity of the item currently in inventory. This is used in the calculations for the Inventory Valuation Report.
2. With weighted average costing, what document is used to calculate the cogs?
  1. Weighted average cost of an item can be found by navigating to Inventory → Items → "Double click the item" → Current unit cost. Current unit cost is weighted average of an item, and it is calculated from Item receipt documents if Item receipts have been used.
3. If the answer to the above is item receipt, what is used when that document is not available for the calculation?
  1. If item receipt hasn't been created for this transaction, the costs will be calculated from the Bill.

4. If a date gets changed on the document that was used in the costing calculation, does recalculation automatically happen?

  1. No, it doesn't happen automatically. For weighted average costing on an item, any change in a document has to be modified manually on the related documents. Currently, best way track an item's cost is via Report → Inventory Valuation Summary → Run Report. After a change has been made, reposting the transaction will cause a recalculation.
5. What happens if the Item Receipt or the Bill document gets deleted?
  1. Document deletion will fail if there are related item cost and bill documentation to a purchase order. If the document used for calculation is deleted, the transaction will not be included in the cost calculation.

    • Related Articles

    • About Costs

      Costs AccountingSuite uses the following terms when reporting costs for an item: Standard (or expected) cost - this is in the expected cost field on the item card. It is entered manually and is stored as entered. This number is not used in any ...

    • Landed Costs

      Overview The Landed Cost feature allow for the allocation of costs associated with getting products from the vendor to your warehouse to be automatically or manually to costs of goods sold amongst the products on a PO/Item Receipt. Examples of these ...

    • Item Last Costs

      Item Last Costs The item last cost is the most recent cost for that item. It is derived from the cost on the bill received for a purchase order. Inventory adjustments, item receipts and assembly builds also update item last costs. For more ...

    • Item Last Costs

      Item Last Costs The item last costs page lists all inventory items with the last price you paid for them. Clicking on the line will navigate to the Purchase Order where this last purchase was made. Navigate to Inventory → Item Last Costs.

    • Choose Item Purchase Cost (extension)

      Introduction This extension allows users to choose between item expected cost (from the Item Detail Card) and item last cost 9cost the last time the item was purchased) when creating purchase orders. The Purchase Order draft is automatically updated ...