web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Recalculatio...
Microsoft Dynamics AX (Archived)

Inventory Recalculation And adjustment

(0) ShareShare
ReportReport
Posted on by imran ul haq 4,057

Hi Friends,

I have some issue in my inventory value, as after recalculation i found some difference in the GL and module. Also i found after recalculation of the inventory some items have negative and positive amount against the quantity zero.

So i believe we have to make the amount zero for those items, As i have gone through some blogs and posts. Here i am taking the example of 1 item:

Inventory Value before recalculation

12022.1.jpg

 

Inventory Value After Recalculation

2117.2.jpg

Now when i go to the adjustment form from the "Closing and adjustment", i found the below form:

4274.3.jpg

So how i will update the amount so that the amount for the item will be zero and by what amount as per the screen shots attached.

Please advise.. 

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Imran,

    In the closing and adjustment form that you show above, select your item and then select adjustment-on hand.

    Enter the new value (of $0) and post the transaction.

    Then run the inventory value report again.

    If you have not done this before, please test it in a demo/test environment before doing this in Live.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 4,057 on at

    Hi Ludwig,

    After recalculation "On Hand" option was grayed, so i close the inventory and then "on hand" option enabled. Then i went to Adjustment-On hand for and select my item and following form open, there i tries to enter the value but it is disabled.

    0257.4.jpg

    And when tries to enter zero the amount or value from the Adjustment button on "On Hand" form getting the following message

    "Current on-hand inventory value must be positive."

    Please guide

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Imran,

    Ok, if this does not work, have you tried posting an item counting journal?

    If you post it with a qty of 0 and run an inventory recalculation you should be able to bring down the financial values to $0.

    Would be great if you could test this and let us know if this resolved your issue.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 4,057 on at

    Hi Ludwig,

    My Inventory for this item is already zero, only problem with the value. In the inventory value report qty shows zero but with amount.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Imran,

    I understand your comment. Yet, probably just try to test in a demo environment posting a counting journal with a qty + price of $0. If you run the recalculation thereafter, your value should go down to $0.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 4,057 on at

    Hi Ludwig,

    But in this case my inventory count will increase by at least 1.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Imran,

    Do you have a test environment with comparable data that you showed above available?

    If this is the case, please test to post a counting Journal with a counting quantity of 0.

    This should be possible even if you have currently 0 on stock.

    Before posting the journal please the the other tabs and the prices that you see and once that is done, please run an inventory recalculation.

    It worked in my demo environment and it would be great if you could double check whether this also works for you.

    Best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 4,057 on at

    Hi Ludwig,

    I tried with the zero qty and zero cost, also with the zero qty and negative cost amount (refer the screenshot), but it didn't create any journal (Blank). Also i recalculate the inventory but no effect.

    8270.5.jpg

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    HI Imran,

    Ok, if this did not work can you test

    (a) posting +1 item no. 90311021 in a counting Journal

    (b) posting -1 item no. 90311021 in a counting Journal

    (c) do the recalculation again.

    If (a)-(c) do not make a different, can you then run the potential conflicts report filtered for item 90311021 to make it run fast in order to see what error/warning message you get?

    Many thanks,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 4,057 on at

    Hi Ludwig,

    Can you please tell me what cost price i have to put while passing the +1 and -1 qty journals.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans