This article complements the Purchased Item record training article. Click here to learn more about the Purchased Item record.


The Cost Update Method determines how the Inventory Cost of each item will be calculated in R365. This is selected on the 'Purchasing' tab of the Purchased Item record and lists the following options:


This article reviews Weighted Average and then each Cost Update Method.



Weighted Average Overview


The Weighted Average considers both the cost and the quantity of an item at the time the data is pulled. This will result in a per-unit weighted average to provide a more accurate Inventory Cost for the item. Click here to learn more about Weighted Average.



Weighted Average (Last Count)


The Weighted Average (Last Count) costing method pulls an item's cost from the last approved Inventory Count and all subsequent costing transactions to calculate its weighted average and, in return, its Inventory Cost. Costing Transactions used in this calculation include Inventory Counts, Invoices, Item Transfers (Receiving Location only), and Commissary Fulfillments (Receiving Location only). 


All item costs are pulled from transactions regardless of the detail Location's assignment and broken down into a per-unit cost divided by the total, which follows the Weighted Average algorithm. It is important to note that the following will be excluded from the Weighted Average (Last Count) calculation:

  • $0 entries on Inventory Counts
  • Negative quantity or amounts on Inventory Counts
  • Transactions that have all line item details applied to a different Location than the header Location


Back to Top


Weighted Average (Last 3)


The Weighted Average (Last 3) costing method pulls an item's cost from the last three days of approved costing transaction activity for each item to calculate its weighted average and, in return, its Inventory Cost. Costing Transactions used in this calculation include Invoices, Commissary Fulfilments (Receiving Locations only), and Item Transfers (Receiving Locations only).


All item costs are pulled from transactions regardless of the detail Location's assignment and broken down into a per-unit cost divided by the total, which follows the Weighted Average algorithm. It is important to note that the following will be excluded from the Weighted Average (Last 3) calculation:

  • $0 entries on Inventory Counts
  • Negative quantity or amounts on Inventory Counts
  • Transactions that have all line item details applied to a different Location than the header Location


Back to Top


Last Invoice


The Last Invoice costing method pulls the item's cost from the last approved invoice to determine its Inventory Cost. If there are more than one approved invoice on the 'last day', then the system will take the weighted average of the item's cost by breaking it down into a per-unit cost divided by the total.


It is important to note that the following will be excluded from the Last Invoice calculation:

  • Transaction activity with $0 contributions
  • Negative quantity or amounts on transactions


Back to Top


Manual


The Manual costing method is all custom-entered by your Organization. R365 will not use any calculations to update Inventory Cost but rather rely on your team to update Inventory Costs as needed. While this option is available, it is rarely used.


Back to Top