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) / Reversing stock adjust...
Microsoft Dynamics AX (Archived)

Reversing stock adjustment journal in weighted average cost

(0) ShareShare
ReportReport
Posted on by Khushi 145

Hi Experts,

A stock adjustment journal has been posted as receipt (with cost price as 1) since there was some error in item load. Now since the item load is done, the adjustment journal needs to be reversed. However when I tried to post the reversing journal with negative quantity, the cost price is getting updated from item master and system is not allowing to change it since the costing method is weighted average cost. 

Please help me with a solution.

Thanks in advance

Khushi

*This post is locked for comments

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

    Hello Khushi,

    I do not think that you can do that directly in the journal because you cannot influence the issue price.

    What you can do alternatively is making an adjustment to the inventory value after running the next inventory close.

    In the closing and adjustment form that you use for running the inventory close you can post adjustments that help you getting this corrected.

    Best regards,

    Ludwig

  • OsmanIstanbul Profile Picture
    OsmanIstanbul 2,820 on at

    Hello Khushi,

    Can you try marking function? this function eligible even after post. after marking, system will take the cost from receipt. you must recalculate weighted average cost after marking.

    best regards.

    Osman

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

    Hi Osman,

    Marking shouldn't work in this case because a negative adjustment needs to be recorded.

    At least it doesn't work in my system. If you can make this work then this would be the best solution.

    Can you share details/screenshots how you realise that?

    Many thanks and best regards

    Ludwig

  • Khushi Profile Picture
    Khushi 145 on at

    Hi Osman,

    Marking was the first thing tried but that didn't work in this situation.

    Thanks & Regards

    Khushi

  • Khushi Profile Picture
    Khushi 145 on at

    Hi Ludwig,

    I will try this.

    Thanks for your time and response.

    Best regards

    Khushi

  • OsmanIstanbul Profile Picture
    OsmanIstanbul 2,820 on at

    Hi Ludwig,

    Thank you for your warning. I supposed that post sender has a negative record.

    "However when I tried to post the reversing journal with negative quantity"

     

    Best regards.

    Osman

     

     

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