Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

Posted on by 35

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.

  pastedimage1627011511804v1.png

   

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,480 User Group Leader on at
    RE: inventory transaction with value open status is "NO" are adjusted after inventory recalculation

    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 :

    1. 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
    2. 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, 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: inventory transaction with value open status is "NO" are adjusted after inventory recalculation

    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

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

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: inventory transaction with value open status is "NO" are adjusted after inventory recalculation

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans