Dynamics Community Forum Thread Details

Invent Journal Trans quantity not updating quantity in transactions

Ok so I have this api, in the request body i send an updated qty for the lines of a Transfer Journal. the quantity gets updated successfully, but when i go look into the inventory transactions for that item and search it with that journal id, the quantity remains same as before.

But when i do this process directly from dynamics. If i update the quantity of the line, lets say it was -5 before, i change it to -7 and save it on the form, then if i refresh the inventory transactions, the quantity of it also changes accordingly.

I have attached relevant screenshots and the code, Kindly help.

if (_InventJournalTrans.UnitQty != _currLine.parmQty() * -1)
{
//ttsbegin;
////inventJournalTrans.modifyInventJournalTransUnitQty(inventJournalTrans.Unit);
//_InventJournalTrans.selectForUpdate(true);
////_InventJournalTrans.Qty = _currLine.parmQty() * -1;
////_InventJournalTrans.UnitQty = _currLine.parmQty() * -1;s
//_InventJournalTrans.Qty = _currLine.parmQty() * -1;
//_InventJournalTrans.editUnitQty(true, _currLine.parmQty() * -1);
//_InventJournalTrans.Notes = _currLine.parmNote();
//_InventJournalTrans.modifyInventJournalTransQty();
//_InventJournalTrans.update(NoYes::Yes);
//ttscommit;
ttsbegin;
_InventJournalTrans.selectForUpdate(true);
_InventJournalTrans.Notes = _currLine.parmNote();
_InventJournalTrans.editUnitQty(true, _currLine.parmQty() * -1);
_InventJournalTrans.modifyInventJournalTransQty();
_InventJournalTrans.doUpdate();
ttscommit;
}

Categories:

Microsoft Dynamics AX

@SA-15031413-0

Without investigating and testing your exact scenario, I can give you a hint why it's probably not working from code.

I see you are using the doUpdate method instead of the update method on the InventJournalTrans table buffer in your code. Why is that?

Calling doUpdate on the table buffer skips the code in the update method of the table and just updates the data in your table buffer. Usually speaking you should always call the standard insert, update and delete methods so that any logic present will be triggered. In some rare cases you might want to call doInsert, doUpdate or doDelete that but this is certainly a case where you don't want to.

When you are in F&O in a form and changing data manually and the data is saved, the system calls the update method of the datasource so that any business logic present may be triggered.