Skip to main content

Notifications

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) / On-hand adjustment / n...
Microsoft Dynamics AX (Archived)

On-hand adjustment / negative inventory

(0) ShareShare
ReportReport
Posted on by joebongiorno 452

Hi

I am having issues with inventory on hand and costing (see attached).  I am trying to adjust the cost of my on hand inventory (as at Dec 22, 2018 in this example) but not able to because I have negative inventory.  The correct cost should be 0.22/unit.  But instead showing a sale of 19 units at total cost of 119,444.26. I have not idea where this cost is coming from.  From scan below...the first item sold was on Dec 13.  There were no other transactions before then.  I am confused on why this is happening and how to fix this?

Any help? Thanks

AX2Capture.PNG

*This post is locked for comments

  • joebongiorno Profile Picture
    joebongiorno 452 on at
    RE: On-hand adjustment / negative inventory

    I just spoke to my inventory specialist here at the company and we do something here that I was not aware of.  At month end, the inventory specialist gets a report of all the negative balances.  And a count adjustment is uploaded into AX and posted to bring all the negative balances to zero.  So this will actually fix it all to zero quantity.

    Thanks for all your help

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: On-hand adjustment / negative inventory

    Hi Joe,

    You can try to search for hotfixes for AX2009 on customersource: mbs.microsoft.com/.../AX2009HotFixList

  • joebongiorno Profile Picture
    joebongiorno 452 on at
    RE: On-hand adjustment / negative inventory

    Thanks. But where do I search for a hotfix?

    Joe

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: On-hand adjustment / negative inventory

    Hi Joe,

    Our replies did cross each other. This behavior seems to be the same as I had seen in the past, but is about 12 years ago and was based on AX3.0. Try to see if you can find any hotfix. Also try to correct the entry as described in my previous reply. Once the inventory is closed and correct, try to avoid negative inventory as well.

  • joebongiorno Profile Picture
    joebongiorno 452 on at
    RE: On-hand adjustment / negative inventory

    costCapture.PNGHi

    As well can someone tell me how that cost with the $119,444.26 come from?  I don't understand. This is a BOM item. The production item costing shows 22 cents.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: On-hand adjustment / negative inventory

    Hi Joe,

    It seems like there is no positive transaction for this location. In that case, the closing will not adjust this transaction. If it is one transaction in one location, you can indeed try to use an inventory journal to clear the negative inventory. Then run a closing or adjustment. Please test it in a copy of your environment first.

  • joebongiorno Profile Picture
    joebongiorno 452 on at
    RE: On-hand adjustment / negative inventory

    Hi

    The period is still open. I closed until Dec 22, thinking this would fix the issue, but it did not. I could cancel this close.

    We are using weighted average by location for costing

    This negative amount is just in one location.  The other locations are not negative and I can adjust the cost for these.  How do I fixt this?  Do I do a count adjustment to bring the item to zero?

    Thanks

    Joe

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: On-hand adjustment / negative inventory

    Hi,

    In addition, is 2018 still open for recording transactions or have you already closed inventory and your financial periods for 2018?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: On-hand adjustment / negative inventory

    Hi Joe,

    It is far from recommended to allow for negative inventory with physical items and a cost value. I have seen this behavior in AX3.0. At that time, it was almost impossible to get the cost correct. What costing model are you using? Can you check if there are customizations in this area? Can you also check if there are hotfixes related to inventory costing which are not installed? For AX3.0 there was an important fix at the time the customer decided to upgrade their AX version, but had not installed this fix. Note that a possible available hotfix would correct the behavior for new transactions; it will not correct the cost price automatically.

    If you have a copy of this environment, try to run the inventory closing/adjustment to see what would be fixed or not. Do you only have 8 transactions for this item?

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans