Dynamics Community Forum Thread Details

In Microsoft Dynamics 365 Finance and Operations, when using the Moving Average costing method, the system automatically posts cost adjustments under certain circumstances to ensure inventory costs are accurately reflected. This happens particularly when there are discrepancies between the receipt cost and invoice cost for items, such as in your scenario with the PO.

Explanation of Cost Adjustments in Moving Average Costing

With the Moving Average costing method, the system calculates the item's average cost based on purchase receipts and adjusts the inventory value when there’s a difference between the received cost (the initial price recorded at the time of receipt) and the invoiced cost (the final price confirmed on the invoice).

In your case, the Cost adjustment entry occurs because of a difference between the expected cost at the time of the receipt and the actual cost posted at the time of invoicing. Here’s how it generally works:

Receipt Posting:
- When you post a receipt (Product Receipt) for a PO, the system records the item at the received cost (based on the price in the PO at the time of receipt).
- With the Moving Average method, this receipt updates the moving average cost for the item.
Invoice Posting:
- When the invoice is posted, the system compares the received cost (recorded at the time of receipt) to the invoiced cost.
- If there’s a difference between the received cost and the invoiced cost (e.g., if the vendor charged a different price than initially expected), the system posts a Cost adjustment to account for this discrepancy and updates the inventory cost accordingly.
Conditions Triggering Cost Adjustment:
- Price Variance: If there’s a difference between the unit cost on the receipt and the unit cost on the invoice.
- New Item: In cases where the item doesn’t have prior transactions (like in your case), the initial receipt may set the cost, but a discrepancy on the invoice will cause an immediate adjustment because the Moving Average cost needs to be accurate from the start.
- Manual Cost Adjustments: If you manually adjust the cost of an item after receipt, this can also impact the Moving Average cost.
Resulting Negative Cost Adjustment:
- If the invoiced cost is lower than the received cost, the system posts a negative adjustment to reduce the inventory value and align it with the actual invoiced amount.
- Conversely, if the invoiced cost is higher than the received cost, the system posts a positive adjustment to increase the inventory value.

Why You See a Negative Cost Adjustment on the Invoice

Since your item had no previous transactions (no established cost), the receipt of the PO would set the initial cost. If the invoice price was lower than the received cost, the system would post a negative cost adjustment to bring the inventory value down to the actual invoiced amount. This negative adjustment aligns the inventory valuation with the actual price you paid, as per the invoice.

Example Scenario

Here’s an example scenario based on your description:

PO Created: You create a PO for an item with a unit price of $100.
Receipt Posted: You receive the item, and the system records an inventory cost based on the $100 per unit (since there were no prior transactions, this becomes the starting cost for the item).
Invoice Posted: When you post the invoice, the vendor charges $90 instead of $100.
Cost Adjustment Posted: The system detects a $10 difference per unit (since $90 is lower than the initially recorded $100). Therefore, it posts a negative cost adjustment of $10 per unit to bring the inventory valuation down to $90 per unit, matching the actual cost on the invoice.

Key Points to Remember

Moving Average Costing dynamically adjusts with each transaction to ensure accurate inventory valuation.
Cost Adjustments are posted automatically when there is a price difference between the receipt and the invoice.
A negative cost adjustment means the invoice cost is lower than the initial receipt cost.
Moving Average Cost is updated with each purchase transaction, so any discrepancies between received and invoiced costs will lead to immediate adjustments.

This process ensures your inventory valuation is always aligned with actual costs, which is essential for accurate financial reporting.