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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156