Dynamics Community Forum Thread Details

Transfer Order : Create status from created to shipped after importing excel lines

Hi every one i have been trying to work on the transfer order to change its status from created to shipped but the status changes to received dont now the reason,

Code:

//public void usingExcel_Receive(Args _args)
//{
// InventTransferTable transferTable;
// InventTransferLine transferLine;
// InventDim inventDim;
// InventDimCombination dimCombination;
// KHDI_InventTransferLineTmp TransferLineStag;

// Dialog dialog;
// //RecordInsertList recordInsertList;
// DialogGroup dialogGroup;
// FormBuildControl formBuildControl;
// FileUploadBuild fileUploadBuild;
// FileUpload fileUpload;
// FileUploadTemporaryStorageResult temporaryStorage;

// int rowCount, i;

// System.IO.Stream stream;
// ExcelSpreadsheetName sheeet;
// FileUploadBuild fileUploadB;

// dialog = new Dialog("Import transfer-order lines");
// //recordInsertList = new RecordInsertList(Tablenum(InventTransferTable));
// dialogGroup = dialog.addGroup("@SYP4881191");
// formBuildControl = dialog.formBuildDesign().control(dialogGroup.name());
// fileUploadBuild = formBuildControl.addControlEx(classstr(FileUpload), "@SYS117211");

// fileUploadBuild.style(FileUploadStyle::MinimalWithFilename);
// fileUploadBuild.fileTypesAccepted('.xlsx');

// if(dialog.run() && dialog.closedOk())
// {
// fileUpload = dialog.formRun().control(dialog.formRun().controlId("@SYS117211"));
// temporaryStorage = fileUpload.getFileUploadResult();

// if (temporaryStorage != null && temporaryStorage.getuploadstatus())
// {
// stream = temporaryStorage.openResult();
// using (ExcelPackage excelPackage = new ExcelPackage(stream))
// {
// excelPackage.Load(stream);
// ExcelWorksheet worksheet = excelPackage.get_Workbook().get_Worksheets().get_Item(1);
// OfficeOpenXml.ExcelRange range = worksheet.Cells;
// rowCount = worksheet.Dimension.End.Row - worksheet.Dimension.Start.Row + 1;

// delete_from TransferLineStag;

// for (i = 2; i <= rowCount; i++)
// {
// TransferLineStag.clear();

// TransferLineStag.TransferId = range.get_Item(i, 1).value;
// TransferLineStag.ItemId = range.get_Item(i, 2).value;
// TransferLineStag.InventSizeId = range.get_Item(i, 3).value;
// TransferLineStag.InventColorId = range.get_Item(i, 4).value;
// TransferLineStag.QtyShipped = range.get_Item(i, 5).value;

// TransferLineStag.insert();
// }
// }

// try
// {
// update_recordset transferLine
// setting QtyShipped = TransferLineStag.QtyShipped
// join inventDim
// where inventDim.inventDimId == transferLine.InventDimId
// join TransferLineStag
// where inventDim.InventSizeId == TransferLineStag.InventSizeId
// && inventDim.InventColorId == TransferLineStag.InventColorId
// && transferLine.TransferId == TransferLineStag.TransferId
// && transferLine.ItemId == TransferLineStag.ItemId
// join transferTable
// where transferTable.TransferId == TransferLineStag.TransferId
// && transferTable.TransferStatus == InventTransferStatus::Shipped;

// Info(strFmt("Transfer-order lines were imported successfully"));
// }
// catch (Exception::Error)
// {
// error(strFmt("While updating lines, import from staging was unsuccessful. \n "));
// }

// //recordInsertList.insertDatabase();
// //this.createTransferOrderLines(_args);
// }
// }
//}

Quick Links

Leaderboard