Hi there,
my colleague wants to transfer on-hand inventory from AX 2009 to AX 2012 R3 via inventory adjustment journals (Inventory management).
This seems to be special with R3. When we set the inventory status we cannot create InventJournalTrans because there are several key conflicts in table WHSInventReserveDelta. This problem is caused by method WHSInventOnhand::insertReserveDelta(). In this method InventDims are created for every Reservation-hierarchy-Level (Line 69-88). When it comes to "Inventory status" the InventDim::findOrCreate()-method returns a wrong InventDim instead of creating a new one because the Hash-Key is not set. This results in a key conflict in WHSInventReserveDelta. This is all system code.
If we don't set the inventory status the creation of InventJournalTrans works out but if we try to post the journal AX claims an inventory status. So we are stuck at this point :-).
Now the question is:
1. Is it even possible to create on-hand inventory via InventJournalTables (Type: Loss&Profit) in R3?
2. Is there a better way to "create" on-hand inventory in R3 than via InventJournalTables (Type: Loss&Profit)?
Greetings
Nils
*This post is locked for comments