The situation is like this...
The stock has value but no quantity.
I tried to write-off the stock value using the "Adjustment" button of "Closing and Adjustment" form.
But I couldn't edit the "Edit Now" column.
If I use "Value" option to update the stock value, AX said: "On-hand total must be positive".
Any other way(s) to write off the stock value?
I tried also adjusting the transaction instead of OH - but during closing/recalculation this seemed to be reversed back by AX.
Also, wouldn't it make the previously calculated cost becomes wrong, if we were to adjust the transaction created in the closed period?
- This problem seems to be caused by "back-door" database update to force purchase return.
- AX version 4.0 SP2.
Thank you in advance.
If you have a stock value without quantity then the records in table InventTrans are not correct. This is not something you can solve by making financial or inventory transactions through the application. The records will have to be corrected on database level. The first thing you should do is run a "Consistency Check". That is a program that you can find in Basic> Periodic > "Consistency Check". Run the program with option "Check" first. That will produce a report with any inconsistencies that are found. This might run quite a while and the error should show up on the report. Check the report and then run the program again in "Fix Error" mode to correct the inconsistencies that were found. (Make sure you have a database backup before running).
Most likely this will solve the problem. If not then someone has to check the records in the InvenTrans table and make adjustments manually if necessary. InventTrans is a quite complicated table and any corrections should only be made by someone with very in-depth knowledge. I've seen experienced consultants mess that up.
The consistency check did identify the troubled part no, and the PO with the wrong settled quantity.
But the "Inventory Value Per Item Group" still shows value with no quantity.
Did you run the consitency check with the "Fix error" option? Did that change anything?
Yup...out of 11 errors, 6 were fixed by AX.
If that didn't fix the problem then it's unfortunately not really possible to give you much more advice without seeing the exact transaction details. You said that the problem has been caused by a consultant who probably made mistakes when he/she manually changed values in the database. Most likely he changed some values and forgot others. Someone will have to look at the tables now and check the inventory transactions and financial transactions for that purchase order to figure out what was done wrong and how to correct it.
To get to the root of the problem these cases usually require some extensive "detective work" by someone with technical knowledge about database structure and business knowledge about inventory and finance - especially if users already tried to make corrections through the application. It would help if you still have contact to the consultant and could ask him what exactly he changed. He/she might also offer further assistance. Every consultant overlooks something sometimes - especially when it comes to tricky "back-door" fixes. If my clients make me aware of something that went wrong because of an oversight on my part then I fix it without further charge. It doesn't hurt to ask.
If you choose not to go through the effort of fixing the original problem then make sure that at least the financial postings for the purchase order were correct. Is it just the inventory value in the inventory tables that is wrong or is the dollar amount on your inventory account wrong too? (Was it a high value item or are we talking just about a few cents?). As long as the general ledger account values are correct discontinuing the item might be an option.
I realize that my answer is not helping you much. Sorry for that! I wouldn't want to give further advice though without seeing the details.
I have experienced the same issue, and after very detail research i have found the marking is missing from many items
The reason when you run the Inventory closing or inventory recalculation , the cost of the item couldnt fix properly.
You have to go to Inventory management -> Inquiry -> Transactions
Lot ID and Reference lot ID must be fill in for all items which are come from Production ( or you can use 'Production' in reference )
all the missing Reference lot ID items , you need to go back on these production orders and mark automatically, then run the recalculation , the item cost will fix properly inshAllah.