Finance | Project Operations, Human Resources, ...

inventory transaction with value open status is "NO" are adjusted after inventory recalculation

(0) Share

Report

Posted on by stephen.liu@tectura...

hi community

I have an issue to be investigate

background:

ax version: 2012 R3

inventory cost method : weighted average with include physical cost

issue details:

transactions have been full settled in previous inventory closing , but new adjustment occur during current inventory recalculation.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Stephen,

Is respectively was the status of those transactions closed before you run the new recalculation / inventory close?

I cannot identify that from your screenprints.

In addition, I found two issues on LCS that seem to be related to your problem.

Please check:

fix.lcs.dynamics.com/.../Details

fix.lcs.dynamics.com/.../Details

Best regards,

Ludwig

Was this reply helpful? Yes No
stephen.liu@tectura... 35 on at

Like (0)

Report

hi Ludwig Reinhard

thank you for your feedback

yes , these transactions have been closed in last inventory closing(4/30/2021), the filed in these transaction which "financial closed " is "4/30/2021" and "value open" is "no".

when recalculate inventory up to 5/30/2021, these transactions is adjust by system, new adjustment occur.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi stephen liu,

Thanks for the update and feedback.

Please have a look at the hotfixes that I shared.

If they don't apply to your system version, get into touch with the MS support or a developer to have a look at this issue.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report
Hi Stephen Liu,

Inventory adjustment is possible only if there is some value adjustment done on the Raw Material level (if manufactured item) or on the Purchase order level.

As you are using the "weighted average with include physical cost" the system will do adjustments on recalculation.

Please check the following :

If this is Manufactured Item: Please check is there any change in the cost of raw material in the last month. example: Freight / Other charges loaded to Raw Material in last month

If this is a Non-Manufacturing Item: Please check is there any change in the cost of material in the last month. example: Freight / Other charges loaded to Raw Material in last month

Let us know if this helps you.

Thanks,

Was this reply helpful? Yes No

Join the conversation

Community site session details

inventory transaction with value open status is "NO" are adjusted after inventory recalculation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

inventory transaction with value open status is "NO" are adjusted after inventory recalculation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates