web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Costing
Finance | Project Operations, Human Resources, ...
Unanswered

Costing

(1) ShareShare
ReportReport
Posted on by LA-13110446-0 23
Cost posting in physical transaction
Hi professional, 
I had a PO, after posted PO received, I found "Price difference for moving average" occurred and cost recorded in Cost adjustment, leading to when I post invoice, cost amount is negative. Before PO, this item does not have any transaction.
Could you help me clarify when system records value in Cost adjustment field?
Categories:
Dynamics 365 Finance
I have the same question (0)
  • LA-13110446-0 Profile Picture
    LA-13110446-0 23 on at
    Costing
    Hi Saif Ali Sabri,
    Thanks for your detail explanation, but on the PO the unit price of item does not change when receive until invoice. Because the price difference posted so it leads to cost amount after post invoice is 0 and I so confused.
  • Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,346 Super User 2025 Season 2 on at
    Costing

    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:

    1. 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.

    2. 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.

    3. 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.

    4. 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 886 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 870 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 697

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans