Hi Experts,
I want to validate and import the multi select field data in Sales Order Line V2 Entity.
The file is importing successfully but the data in my Multiselect Field(ManufacturingPlant_CAP) is not updating.
can anyone help out here.
[Extensionof(tableStr(SalesOrderLineV2Entity))]
internal final class SalesLineManufacturingPlantImp_CAP_Extension
{
public static void postTargetProcess(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution)
{
SalesLine salesline;
InventSite inventSite;
container tmpValues,chk;
int idx;
//check if import job is finished
if (_dmfDefinitionGroupExecution.StagingStatus == DMFBatchJobStatus::Finished)
{
SalesOrderLineV2Staging salesOrderLineV2Staging;
ttsbegin;
while select salesOrderLineV2Staging
where salesOrderLineV2Staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup
&& salesOrderLineV2Staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId
&& salesOrderLineV2Staging.TransferStatus == DMFTransferStatus::Completed
{
if (salesOrderLineV2Staging.SalesOrderNumber != '')
{
tmpValues = str2con(salesOrderLineV2Staging.ManufacturingPlant_CAP, ';');
for (idx = 1; idx <= conLen(tmpValues); idx )
{
inventSite = InventSite::find(conPeek(tmpValues, idx));
if (! inventSite.RecId)
{
error(strFmt("Value '%1' in Manufacturing Plant Field is not valid", conPeek(tmpValues, idx)));
}
}
salesline.ManufacturingPlant_CAP = salesOrderLineV2Staging.ManufacturingPlant_CAP;
salesline.update();
ttscommit;
}
}
}
next postTargetProcess(_dmfDefinitionGroupExecution);
}
}
