Is there a way to correct negative stock value for out of stock items

(0) Share

Report

Posted on by Aartserp

Version: Dynamics Ax 2009 SP1 RU8 5.0.1500.6491

A client of mine has his Ax system for 11 years and comes with the following question/issue:

Throughout the years several products have been retired and the stock level is zero. However when we run the Inventory value report (en-us language: inventory management > Reports > Status > Inventory value > Inventory value report) the INV: Financial amount is not for all the items zero, most have a negative balance.

The Inventory value report is using the following setup:

The inventory model group is setup to use FIFO.

Anyone has experienced this and knows if this is possible to solve?

Side note: There are 90 items like this so I really hope there is a script or function that can help me with

To give additional information about a possible reason the inventory value is off balance could be transactions before a cost price was set like the following (and in this case reversed after the cost price was set):

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

André Arnaud de Cal... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Aartserp,

Are you running the inventory recalculation and closing periodically? During several postings, an average cost price is used for inventory transactions if you use FIFO. The inventory recalculation and closing will calculate the correct cost price for inventory deductions and post adjustments.

You can read more about this in the cost management whitepaper available here: Download Microsoft Dynamics AX 2009 White Paper: Cost Management from Official Microsoft Download Center

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Aartserp,

Please run an inventory recalculation / close first and then the inventory value report.

Do you still see the negative amounts?

Best regards,

Ludwig

Was this reply helpful? Yes No
Aartserp 62 on at

Like (2)

Report
Copy link

Link copied!

Hi André, Ludwig,

Thank you for your response.

No the inventory closing has never been run.

I just turned it on in the test system and i will see what the result is.

Once the closing is done and i understand the result I will share it here.

Was this reply helpful? Yes No
Aartserp 62 on at

Like (0)

Report
Copy link

Link copied!

Thanks André and Ludwig. This did the trick. I asked why the closing was not done regularly and it turned out that when the application was just introduced the closing was giving strange values. Maybe in the early version of Ax 2009 there were some bugs with the closing(?).

Can this function also be used to revalue items to a new cost price? For example when there is an item that is not being actively sold anymore so you want to deduct the value off the inventory (cost price 0) but want to keep the qty so any 'accidental' sales can still be recorded against the item? Some items were counted with value 0 but now have a value again, i suspect because the cost price on the item was filled with the original value from when the item was actively sold.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Aartserp,

There were indeed some bugs in early AX2009 versions but I don't remember details. If you are lucky you can still find them on LCS. Please check it out.

The inventory closing and adjustment form can also be used for adjusting cost prices. Yet, the example that you mentioned is often handled by recording adjustments on special GL accounts only to avoid getting the inventory values and costing messed up. Accountants are usually doing this at the end of the year as part of their year end closing process.

Best regards,

Ludwig

Was this reply helpful? Yes No