Inventory Management Cost Price

(0) Share

Report

Posted on by Community Member

Currently I am using the BOM Movement Journal, There is one item that the Cost Price is 255 as wrongly inputed in the system. Yesterday I corrected it by Changing it under Released Product of Product Information.

When I make the posting today in my BOM Movement Journal, it still appears the 255 as cost price with 6 pcs of quantity Total Cost Amount of 1530. But when I check the transactions the total cost amount will just appear 958.47 and when i check the cost price under on Hand it shows of 159.745 per unit.

and when I checked the Trial balance in the affected account it shows the 958.47 as well.

I am really confused why like this and how it come up with the 159.745.

Is there anyone who can explain to me why?

Thank you very much in advance.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (3)

Community Member on at

Like (0)

Report

PS. I Change the cost price to 15 only under Released product.

Was this reply helpful? Yes No
Verified answer

Weaveriski 23,620 Moderator on at

Like (0)

Report

Changing it on the released product does not impact the cost of the product you have processed.

You have not said if the item is consumed or manufactured in the journal, you have not said what the costing method is, what transactions happened before or the onhand. AX will obey the costing method of the item on consumption and update to the known transaction cost, the production will use the item cost for inventory at receipt.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

When you are looking at the On-hand inquiry for the cost price, ensure that you set the 'Dimensions display' correctly. You should show all Dimensions on the Storage and Tracking dimension groups which are both 'Active' and have 'Financial inventory' ticked. When looking at costs, you should hide any dimensions where 'Financial inventory' is not ticked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much sir!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are using the weighted average method sir, but I am just wondering why we have different prices in different warehouses.

Or what is better method to use, the weighted or the standard?

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

You can have different cost prices in different warehouses if 'Financial inventory' is ticked on the 'Warehouse' line of the Storage Dimension Group.

Neither method is 'better', as far as I know. With one you are recording actual costs, with the other you are recording standard costs and variances from standard. Your financial controller might have a view which is better! Hopefully they will say 'actual', which is why you are using it!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much sir for a big help.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jizon,

If there is nothing left open or unanswered then it would be great if you could verify the answers provided.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much sir.

Was this reply helpful? Yes No