Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Costprice (not) updating?

Posted on by 30

Hi all,

I am new to Dynamics AX and I am trying to find out if it is possible to tackle an issue which we have.

In our purchase orders we order a product. This product is also in (open) sales orders. When we receive the purchase order we would like to have the cost price in the sales order to be updated to the cost from the purchase order.

As I have searched the forum I understood that it should be possible to have this updated, but I cannot seem to get it working. We use Item model group FIFO with inventory model FIFO and the Include Physical value checkbox is active.

When the purchase order is received we tick in the Posting checkbox but the prices are still open. Only when the purhcase order is Invoiced the cost price is updated. Issue here is that the invoice in a lot of cases will be weeks later then the order receive date so we use for weeks the wrong cost price.

Can you advise?

Thanks for your help. 


I hope my question is clear; as I am new to the forum and AX I can imagine my question is not as clearly formulated as is should be...

*This post is locked for comments

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,188 Super User 2024 Season 2 on at
    RE: Costprice (not) updating?

    Hi HansV,

    A purchase price will not be used to update cost on open sales orders. You can update the cost price field on the product details itself.

    As you are using FIFO, you have to periodically use the inventory recalculation and closing to have the FIFO recalculated an applies to sales (inventory) transactions.

    During postings AX will use an average cost for issues.

    You can download a whitepaper which explains this procedure with examples. The document is written for AX 2009, but still applies to AX 2012 if you are using FIFO.

    www.microsoft.com/.../details.aspx

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans