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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Inventory adjustment

(0) ShareShare
ReportReport
Posted on by

While performing issuance in inventory management, a user has mistakenly put a positive quantity of 300  rather than to be negative. Now I need to adjust the positive quantity which is now considered purchased by AX with zero value. Please guide me what should I do. I have couple of suggestion in my mind along with the problem with every one:

1.  Use item issuance of -300 which will eventually knock off the quantity with the positive 300 and then issue -300 more for actual issuance but in this case there will be an issue of item rate. If i perform issuance 1st time it will issue item with the rate based on item model group which is Weighted average and same is the problem with actual issuance. I need to adjust quantity not rate.


2. What will happen if i use adjustment journal, as far as i know it will hit only profit and loss account if we adjust items quantity. Will it effect on rate/unit too or nor?

3. Is there any way to reverse the line of issuance journal which is in positive 300, if it does will it adjust the rate of per unit item or not? also will it also reverse the voucher transaction or not?

If there are any suggestions please help

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Imran Khan,

    Can't you use the same journal type that you have used for recording the positive amount? If you make use of the marking functionality, the receipt and issue price should be identical and should not affect your inventory closing procedure.

    Have you tested that already?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    How can I use the mark functionality?

  • Community Member Profile Picture
    on at

    I have checked the marking functionality but it only shows negative quantities.

  • Suggested answer
    Syed Fasih Profile Picture
    2,442 on at

    You can use the Item Model group parameters. If you un-check the post financial entry and then post an adjustment journal, then it will only update the quantity and not the price/amount.

    Once completed, you can check mark the post financial entry in the item model group.

    I will suggest you to test this out in a test environment to see if it's working perfectly.

  • Verified answer
    Guy Terry Profile Picture
    29,019 Moderator on at

    Hi Imran,

    Following Ludwig's suggestion, I created a positive adjustment for a quantity of 300 and posted it. I then create a negative adjustment for the same quantity. Using the 'Inventory' -> 'Marking' function, I can see previous receipts which this adjustment out can be marked against:

    4478.Marking.jpg

    You can set the 'Marking' before or after the adjustment out is posted.

  • Community Member Profile Picture
    on at

    Thanks Guy terry.

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 July 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