Deactivate/Delete active cost price of a product in AX 2012 R2

Finance and Operations/AX User Forum
1

Hi,

I just want to ask if there is any way I can delete the active cost price of an item or deactivate it located in Manage cost tab > Item Price in the Product details. If I click the delete button, nothing happens.

Thanks in advance,

Kristine

2

Dear Kristine,

In AX 2012 you can’t delete the Active Cost Price since the system already allows movements based on the cost date created. However you can create a new cost version and activate the same to the item.

Hope it solves your problem.

Prabu

3

From the released product details, clear the Item price and Date of price fields on the Manage costs fast tab.

4

As Prabu suggested, you can create and activate a new price for the same period which deactivates the existing cost record.

5

Hi Prabu,

Thank you so much! Another question, is there any way i can reverse those items that has been sold already? I know there is an adjustment process in Closing and adjustment in Periodic but it is only for purchased transaction. Hope you can also help me on this.

Thanks,

Kristine

6

Can you please elaborate what you are looking for and please explain the process.

Prabu

7

Reversal would be by credit note, however if this is cost related the cost comes from the purchases rolled up ultimately.

8

Hi Prabu and Adam,

This is what happened. The user uses inventory adjustment journal receiving the item with cost amount which is wrong. Should be zero/blank cost amount. So, the user creates an inventory adjustment journal again with negative quantity having a cost amount also. Then, we run the adjustment process in “Closing and adjustment” in Periodic in Inventory management. This process adjust the cost of receiving to zero cost amount but for inventory adjustment journal that has been made with negative quantity, it has still cost. How I will zero out those sold one?

9

It will have a cost based upon your costing method, so unless there was zero in stock financially there cannot be zero - that is financial costing. You needed to mark the outbound transaction or have dimensions to financially cost in the same manner to have picked up the cost incorrectly booked in. You would need to work out the physical transaction this was associated with, adjust the cost of that transaction to 0 and then run the close to push the cost through - however if you are average costing it would not matter anyway as the cost taken is clearly the average cost as financially defined.