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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Items don't have f...
Microsoft Dynamics AX (Archived)

Items don't have financial cost amount

(0) ShareShare
ReportReport
Posted on by Community Member

I got a report of purchase orders and journals in which the items don't have financial cost amount, i don't know what is the problem. The Inventory recalculation  was run for the period but unfortunately did not solve the issue.The issue  is in AX 2012 R2.Someone could help me, please?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Vanessa,

    Please specify which inventory model you are using? What is the costing method (e.g. Fifo, Average, Standard, Moving average)? Did you enable the option 'Include physical value' on the Item model or not?

    Are these purchase orders fully invoiced?

  • Community Member Profile Picture
    Community Member on at

    Hi André,

    The costing method is average, the option include physical value is not enable and the purchase order are fully invoiced.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Vanessa,

    Are you sure it is 'Average' and not 'Moving average'?

    If it is average, I would like to know which type transactions were used to have the inventory on stock. Can you look at the transactions fro one item which has a problem?

    Did you use purchase orders, inventory journals, etc?

  • Community Member Profile Picture
    Community Member on at

    It is cost average date(AX 2012 R2)  and i got some purchase orders and some inventory journals with that issue

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Please have a look at the orders and see whether there was a purchase price or on the journals if there was a cost price specified.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre , i found the issue. The problem was in the product creation process, some items don't have active the check for purchase price update and cost price update .

    My question is: these checks must be activated manually or the system should do it automatically?, as not being active, the fields where prices are defined have zero value which prevented financial costs from being loaded when creating the journals or purchase orders

    I have another question,  the item prices have to fill manually ?, what happen if prices vary? I have to make the change manually? The ideal would be that the system does it automatically

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Vanessa,

    As you are using an Average cost price, the purchase price is used as base for the cost when you purchase the goods. For inventory journals AX picks the price from the Released product. So for the purchasing side price fluctuations are covered.

    The Purchase price update and Cost price update are not automatically enabled, but you can achieve it using an Item template where the fields are enabled.

  • Community Member Profile Picture
    Community Member on at

    Now my question is with that item template i could cover the  price fluctuations for the cost side?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Vanessa,

    No. The template can be used at item creation to enable the Purchase price update and Cost price update field.

    Price fluctuations are covered by the purchase price per Purchase order. During posting of the Vendor invoice the purchase and cost price will be updated on the item.

    When you use an inventory journal where the inventory will be increased, you have to check the cost price field. It is taking the cost from the Item, but when needed you can change it.

  • Community Member Profile Picture
    Community Member on at

    Please , do you know any tutorial for items creation using a template?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans