Hi everybody,
I have table VTVSheetingOrderLine that has 2 fields InventBatchID & ItemId.
And table VTVSheetingOrderLine related to InventDim, InventTrans, InventBatch.
The relations will be like:
InventDim.InventDimId = InventTrans.InventDimId
InventTrans.InventTransId = VTVSheetingOrderLine .InventTransId
InventDim.InventBatchId = InventBatch.InventBatchId.
I create form B from table VTVSheetingOrderLine . Add a button “Create Batch Id” on that form.
I wrote codes but it seem not enough, because I don’t know how to create the relations between those table
void clicked()
{
InventNumGroup inventNumGroup;
Num _num;
int increment;
SalesTable _salesTable;
InventTable _inventTable;
InventNumGroup _inventNumGroup;
NumberSequenceTable _numberSequenceTable;
VTVSheetingOrderLine _vtvSheetingOrderLine;
;
increment =1;
_inventTable = InventTable::find(vtvSheetingOrderLine.ItemId);
_inventNumGroup = InventNumGroup::find(_inventTable.BatchNumGroupId);
_numberSequenceTable = NumberSequenceTable::find(_inventNumGroup.NumberSequenceId);
if(vtvSheetingOrderLine.ReamId ==’’)
{
_num = NumberSeq::numInsertFormat((_numberSequenceTable.NextRec + increment - 1),_numberSequenceTable.Format);
ttsbegin;
select forupdate _numberSequenceTable where _numberSequenceTable.NumberSequence == _inventNumGroup.NumberSequenceId;
if (_numberSequenceTable.InUse == NoYes::No)
_numberSequenceTable.InUse = NoYes::Yes;
_numberSequenceTable.NextRec += increment;
_numberSequenceTable.update();
vtvSheetingOrderLine.InventBatchId= _num;
vtvSheetingOrderLine.update();
ttscommit;
vtvSheetingOrderLine_ds.reread();
vtvSheetingOrderLine_ds.refresh();
vtvSheetingOrderLine_ds.research();
}
// super();
}
I don’t know how to filled almost fields of InventTrans, InventDim,InventBatch.
How can I create InventBatchID by Code with the relation structure like above following to the standard way that Microsoft Dynamic AX has done - the way AX create InventBatchID for an Item:
Purchase Order Details → create Purchase Lines → Inventory → Registration → click Auto create → Post all → inventBatchId of an Item is created.
Appreciate & thanks in advance for your help [:)]