web
You’re offline. This is a read only version of the page.
close
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 427

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.

I have the same question (0)
  • MATTGUO Profile Picture
    22,349 Moderator on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

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

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Because I post inventory throgh adjustment journal.

  • MATTGUO Profile Picture
    22,349 Moderator on at

    Hi,

    What filter is checked when you click on the select?

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    open without any filter

    Open for all items

  • MOHAMMAD TAHA IMTIAZ Profile Picture
    427 on at

    Using average method

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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
    427 on at

    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

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans