Item base cost price does not get updated from InventItemPrice

[Newbie]

On the Price/Discount tab of InventTable form, the Base Cost Price can be
manually changed, but this change is not reflected in InventItemPrice table
which is displayed in the form - going to the form by clicking on Price
button on InventTable form.

The problem we are having is that when this item is sold in a sales
quotation line, the cost price is pulled from InventItemPrice table if it
exists. If it does not exist, the cost price is pulled from the
Price/Discount tab. This is not incorrect. We want the cost price from
Price/Discount tab which has been changed.

My question is how to have the cost price updated in InventItemPrice when
the Base Cost Price in Price/Discount tab is changed so that the sales
quotation will get the right cost price? Or how to set up the item pricing
correctly?

Please advise.

Thank you very much.
--
Ax Newbie

[Zbysek]

Inventory costing is a bit tricky in AX.
But generally the inventory recalculation should correct all the COGS
differencies.

[craig brown]

Hi Newbie- my answer to this question comes in two parts:

1) From my experience, AX takes the latest cost price that was updated,
whether it is on the item price form (accessed from the price button) or on
the base cost price record. Of course this is not always desirable.

2) If you wish to change a price. Leave the base cost proce alone and change
it on the item price form. This ensures you also have a viewable history of
item price changes. To enter a new price on this form, entera pending price,
click "save" and then the activate button activates the new cost price.

Craig

[Ievgenii Korovin]

Hello,

Please read the following article, where we described in details how Ax
works and what is future consideratios. Hope it will help.

http://blogs.msdn.com/dynamicsaxscm/archive/2010/02/10/sales-and-purchase-prices-in-relation-to-the-item-price-setup-in-microsoft-dynamics-ax-2009.aspx

--
Ievgenii Korovin , Dynamics Ax , Microsoft

[Newbie]

Thank you for all of your responses on this issue. They are definitely very
helpful. We are considering changing the process of changing item cost price.
--
Ax Newbie