Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Adjust Item cost with zero quantity in Ax 2012

(1) ShareShare
ReportReport
Posted on by 425

How can we adjust item cost with zero quantity.

I post item through inventory adjustment journal. as a result item quantiry become zero where as item showing cost in inventory value report with zero quantity.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Is that item still somewhere used in partly completed transactions such as sales orders where the final invoice is missing or purchase orders where the vendor invoice has not been posted?

    If this is the case then the report output (0 qty but financial amount) could be explained.

    If this is not the case then there must be something wrong with the valuation of that item.

    In this case you have to run an inventory close and adjust the value for that item.

    Before doing that test this carefully in a demo/test environment and note that you won't be able to backdate transactions to a date before the inventory close.

    Best regards,

    Ludwig

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    425 on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    After recalculation I check the amount of an item in inventory value report .Amount still showing with zero quantity

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Hi Mohammad,

    The inventory recalculation will adjust the issue costs based on the inventory model selected.

    If your quantity is zero but a value is there then the issue costs must be wrong and the inventory recalculation should fix that.

    Best regards,

    Ludwig

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    425 on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Using average method

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    425 on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    open without any filter

    Open for all items

  • MATTGUO Profile Picture
    22,317 Moderator on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Hi,

    What filter is checked when you click on the select?

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    425 on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Because I post inventory throgh adjustment journal.

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    425 on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    But in closing and adjustment only purchase order transactions are showing . How can we see all transaction there.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Hi Mohammad,

    Please try to run an inventory recalculation. If you see a financial amount in the inventory value report then the inventory recalculation should take care of that and bring also the value back to zero.

    Best regards,

    Ludwig

  • MATTGUO Profile Picture
    22,317 Moderator on at
    RE: Adjust Item cost with zero quantity in Ax 2012

    Hello,

    Do you mean that now the item has cost but the quantity is zero?

    What is cost model of the item?

    Please try to change the cost in the path Inventory management > closing and adjustment > adjustment > transaction > select. Refer to Doc: docs.microsoft.com/.../adjust-transactions-form-inventory

    Moved to AX forum.

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,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans