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.
Thanks for the prompt reply.
I saw your suggestion at other post with similar issue, so I did run the "Consistency Check" this evening.
For the start date of July 2011, the problem still persisted.
Before leaving office, I run it again with start date of June - lets see the result tomorrow.
Absolutely agree that only AX technical consultant who is very familiar with InvenTrans table should do the changes.
Will update on the result tomorrow.
Suhardi said: This problem seems to be caused by "back-door" database update to force purchase return.
What do you mean by that?
Due to user pressure, former AX technical consultant updated the database directly to enable several purchase return.
Never do that, it may leads to Data consistency.
The business login and necessary validation will not get executed when it is done from the database.
When ever qty in InventTrans(Transaction table) gets update the system will update the InventSum table(On Hand table)
The necessary logic is valid only when it is performed from the AX.
As there is no guarantee that reversing the database update will solve the issue, I was thinking of phasing out the current part no - and use new part no for future transaction.
Not sure though what to do with the existing transactions that use the old part no - from AX point of view.
If you have other suggestions, please share with us.
I've seen this situation before: zero physical qty, with financial value either possitive and negative. What we found was caused becouse in the inventory dimension group of the item, at the whse level, physical inventory was checked and financial not... so financial adjustments are made at the site level only
Just take a look to be sure
The setup is good...this problem only started to happen in July for one item only.
Seems that it was caused by manually updating the database
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.
I met this problem before, and my situation was due to some transactions have wrong markings so they cannot be settled.
You can try to find the item which hav no QTY but hav value. Check its transactions, to see if there are any trans which hav not got "settled qty" (but hav financial value). and try to find out why they cannot be settled.
Hope this can help u. Thanks!