Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / inventory transaction ...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by stephen.liu@tectura... 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,511 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

  • stephen.liu@tectura.com Profile Picture
    stephen.liu@tectura... 35 on at
    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,099 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,880 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans