hello everyone, i need help here
I have made a button in Inventory Management > Periodic > Transfer Orders > Lines
which deletes the Inventory Transactions which is not Reserve Physical (when partial) here is the picture:
I have this code to delete the Not Reserved Physical (on order):
void clicked()
{
InventTransOrigin inventTransOrigin;
InventTrans inventTrans;
ttsBegin;
{
select forUpdate inventTrans
join inventTransOrigin
where inventTrans.InventTransOrigin == inventTransOrigin.RecId
join InventTransferLine
where inventTransOrigin.InventTransId == InventTransferLine.InventTransId
&& inventTrans.StatusIssue != 4
&& InventTransferLine.TransferId == InventTransferTable.TransferId;
inventTrans.delete();
}
ttsCommit;
super();
InventTransferLine_ds.refresh();
InventTransferLine_ds.executeQuery();
}
--------
when i run this, the table becomes blank, it looks like this:
so I close and open it again, and the Table Data shows up, and the On Order is now removed ( meaning the Delete Code Works, but the Data does not Refresh in the Table)
Now, what I need is to Refresh the Table Data of the Form after the Deleting, (the Datasource is InventTransferLine_ds)
Please help me, thanks.
