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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How can the Cost amount get so high suddenly? AX 2012

(0) ShareShare
ReportReport
Posted on by 18

Hello

On one of the items in our AX 2012, the "Cost amount" got very high suddenly. And it's an article that hasn´t had many transactions lately.

How can it got so high?

Any suggestions?

pastedimage1607352557511v1.png

regards BCC

I have the same question (0)
  • Junaid Idrees Profile Picture
    2 on at

    Hi BCC,

    Please check the inventory transaction details of this product and try to track the cost origin. Which inventory costing method are you using (Weighted Average/Standard costing/FIFO)?

    Please check the following thigns:

    1. Check the cost from "Cost Explorer" under costing section to track the cost that system used it for this Sales transaction.

    2308.PNG

    2. What was the last purchase price you received of this product from Purchase Order?

    3. Can you check on release product screen if someone modified the Cost price under Manage cost section?

  • BCC Profile Picture
    18 on at

    hello Junaid

    Thank you for trying to help me.

    The latest recent purchase cost ,was  150,21 EUR (on a P.O in 2019). And in November, the Cost amount was over 1,5 million EUR for one of that article. see pic below when two were purchased.

    And the latest day the price was changed, was in 2017 .

    Its a FIFO article.

    Its a mystery.

    pastedimage1607376588143v1.png

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    305,946 Super User 2026 Season 1 on at

    Hi BCC,

    It looks like the transaction is related to a sales return. Was there also a ledger entry with this enormous high amount? Can you check on the sales order line if there was a return cost price filled or a return Lot ID? Anyway as it is a 'purchased' transaction, you should be able to adjust the cost amount via the Closing and Adjustment periodic option.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello BCC,

    Can you please let us know the exact system version that you operate (build no).

    Also, have you experienced something similar in the past?

    Many thanks,

    Ludwig

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

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 458 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 450

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans