Skip to main content

Posts

Showing posts with the label inventbatch

How to create InventBatchId for an item by Code.

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; ...
Read more

Invent Movement Journal Creation and Posting from excel

static void MovementJournalImportExcel(Args _args) { InventJournalTrans inventJournalTrans; InventDim inventDim; InventJournalTable inventJournalTable; InventJournalCheckPost journalCheckPost; InventJournalId journalId; journalTableData journalTabledata; InventBatch inventBatch; InventBatch localInventBatch; NumberSeq numberSeq; NumberSequenceReference numberSequenceReference; InventSerial inventSerial; InventSerial localinventSerial; int j,countno=0,i,k; real Scarp; FilenameOpen filename; Sysexcelapplication excelapp=sysexcelapplication::construct(); sysexcelworksheet excelworksheet; sysexcelrange excelrange; sysexcelcells excelcells; // comvariant cellvalue=new comvariant(); ; // Creating Journal Header inventJournaltable.initValue(); inventJournalTable.JournalNameId = 'ERecover'; numberSeq = new NumberSeq(); n...
Read more

Create Movement Journal And Post from excel

static void MovementJournalImportExcel(Args _args) { InventJournalTrans inventJournalTrans; InventDim inventDim; InventJournalTable inventJournalTable; InventJournalCheckPost journalCheckPost; InventJournalId journalId; journalTableData journalTabledata; InventBatch inventBatch; InventBatch localInventBatch; NumberSeq numberSeq; NumberSequenceReference numberSequenceReference; InventSerial inventSerial; InventSerial localinventSerial; int j,countno=0,i,k; real Scarp; FilenameOpen filename; Sysexcelapplication excelapp=sysexcelapplication::construct(); sysexcelworksheet excelworksheet; sysexcelrange excelrange; sysexcelcells excelcells; // comvariant cellvalue=new comvariant(); ; // Creating Journal Header inventJou...
Read more