Inventory average cost Adjustment

(0) Share

Report

Posted on by Community Member

We are using WA item model group. We have done a inventory closing after 2 years after live and after that we are seeing discrepancies in the average cost. Some cases average cost more than sales price.

Would like to adjust average cost, so that here after system takes updated average cost. I have tried closing and adjustment -> transactions options but it is not updating.

With out performing one more inventory closing could anyone suggest a recommended approach?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nagendra Varma K on at

Like (0)

Report

HI Kroobesh,

1. When you click on the adjustment->Transaction have you click on Select and input date range for which you want to retrieve transaction and post the adjustments.

2. Once you retrieve the transaction you can edit the price. each transaction level or value or quantity based.

refer below screenshot follow the sequence adjustment->transactions->select->input date->than edit price.

ensure necessary GL setup are done to post adjustment amount.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can navigate inventory and management / periodic / closing and adjustment

you can use select button to specify transaction criteria

Once the screen populates with transactions you are able to adjust the transaction cost amount. Enter the amount you want to increase or decrease the transaction amount by in the edit now field.

specify posting date then post

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (3)

Report

Hi kroobesh@hotmail.com,

Why do you want to adjust your average cost price?

If your inventory closing results in a cost price that is higher than the sales price, I would first start analyzing why this is the case and do an analysis of the cost prices.

Making a simple adjustment will help you fixing some data in AX but you might continue 'burning' money.

I would thus analyze those items that have a cost price that is larger than their sales price and then decide what to do.

Best regards,

Ludwig

Was this reply helpful? Yes No
imana 15 on at

Like (0)

Report

Hi all,

I have the same issue, but my client has already run the inventory closing for 2019, and found that the average cost is very low. They request to change the value calculated by AX2012 and not editing the entry transactions since they are too many.

Is there a possible way to do that?

Was this reply helpful? Yes No