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) / Item Cost price
Microsoft Dynamics AX (Archived)

Item Cost price

(0) ShareShare
ReportReport
Posted on by Gaurav Chandak 955

Hi All,

In AX 2012, i am using at Item with WA costing method. Is there any possible way that my item cost price should automatically update in the sales order & purchase order.

Thanks in advance,

Gaurav Chandak.

*This post is locked for comments

I have the same question (0)
  • Gaurav Chandak Profile Picture
    Gaurav Chandak 955 on at

    I meant that unit price should be filled automatically with Item cost price in Sales order & purchase order.....

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

    Hi Gaurav,

    When you enter a purchase price in the PO, the cost price will be updated at the moment of invoice posting. If you have set on your item model group that also physical value should be included, this will also have the cost price updated in AX at the moment of posting your product receipt.

    The cost price field on the sales order is important at the moment of a retuned item.

    Otherwise an average cost price will be used for posting your packing slip. If no cost price is know at this moment, it is 0.

    You have to run the inventory recalculation/closing regulary to have the correct cost prices updated on the inventory transactions. With this  recalculation the WA costing method will be applied.

    During e.g. a month a temporary average costprice will be used for issued item transactions. If you run the recalculation at the end of the month, the appropriate costing method will be applied. Note that your margin can show other figures after a recalculation.

  • Verified answer
    Gaurav Chandak Profile Picture
    Gaurav Chandak 955 on at

    Thanks André Arnaud de Calavon a ton for your descriptive answer. It helper alot.

    Have a nice day & peaceful week ahead,

    Kind Regards,

    Gaurav Chandak

  • sreess Profile Picture
    sreess 125 on at

    Hi Andre,

    But in our case, the cost price is not showing or picking from the Item masters even though we can see the default price in Item master window. Do we need to do any more update to show item cost price in PO and Sales transactions. Please advice

    Thanks

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

    Hi Sreess,

    I cannot fully understand your question. This post was about the weighted average. What inventory model are you using? When talking about PO and Sales transactions: do you mean the PO and sales lines or the related inventory transactions?

  • sreess Profile Picture
    sreess 125 on at

    Hi Andre,

    We have uploaded the opening product list with price in Ax 2012. But when we are doing any transaction in Adeaca (Advacned Project) related to these items, the cost price is not automatically showing there.

  • Corey Warawa Profile Picture
    Corey Warawa on at

    We are also having the issue of getting the item cost price to populate on Project Item journals in standard AX 2012 CU8.  I assume I am missing a parameter or something.  Were you able to resolve?

    Thanks,

    Corey

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    In Ax 2009.

     In inventory management -->Journals -->item transaction -->movement,  I was selected a record and printed that record ,in that cost price and cost amount is not displaying.

    but few records are displaying these two fields.Can you please tell me why this is happening.is there any changes need in my inventory set up?

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

    Hi Pallavi,

    It depends on the quantity field. Negative quantity is not retrieving a cost price. Positive transactions are trying to get a cost price based on the item settings. If there is no known cost price, it will also be zero.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

          Thanks for your reply.I was checked the  above  mentioned solution. If there is any negative quantity it was printed with negative cost price and cost amount.Not at all problem with this.but some records are not showing negative or positive cost price and cost amount,these reports are showing these two fields at back end(select a record-->lines-->Inventory-->transactions).while coming to the lines and print-->journal these two fields are  empty.

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