印仔 发布的文章

若表属性 Valid Time State Field Type 属性不为空,则对应行在ValidFrom、ValidTo时间外不可被选中,需要加入
ValidtimeState(dateMin,dateMax)越过此限制。
select validtimeState(dateMin,dateMax) tb;

inventJorunalTransFirst.clear();
inventJorunalTransFirst.data(inventJorunalTrans);
inventJorunalTransFirst.JournalId = headerTb.JournalId;
inventJorunalTransFirst.RecId = 0;
inventJorunalTransFirst.InventTransId = '';
//inventJorunalTransFirst.LineNum = InventJournalTrans::lastLineNum(journalId)+1;
inventJorunalTransFirst.insert();
update_recordset prodJournalBOM setting IWS_InventJournalId = headerTb.JournalId,IWS_InventTransId = inventJorunalTransFirst.InventTransId
    where prodJournalBOM.IWS_InventJournalId == inventJorunalTrans.JournalId     
        && prodJournalBOM.IWS_InventTransId == inventJorunalTrans.InventTransId;
inventJorunalTrans.doDelete();
InventUpd_Reservation::newMovement(inventJorunalTransFirst.inventMovement(),inventJorunalTransFirst.Qty,true).updateNow();