Can't import excel wmsLocation in formula coproducts v2

(1) Share

Report

Posted on by Sachin Mittal

I have added /ReceivingLocationId/ to fromula coproducts v2 entity entity however I noticed that the location data can be exported but I cannot import these values. After searching I found this question so similar but nobody answered it. I Think I should fill map field to in InventInventoryDimensionEntityFieldsMapping but because it is extension I cannot. Do you have any solution?

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Martin Dráb 239,647 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You said you added the field, but not what the entity field is bound to. Please add this information.

By the way, what is the AOT name of the entity?

Was this reply helpful? Yes No
Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!

its bound to inventdim datasource already available in entity
entity name is PmfFormulaCoProductV2Entity

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,647 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

InventDim data source is read-only, which is correct, because you can't simply change a value in InventDim table. When you want a different combination of inventory dimensions, you need to find or create a different record in InventDim.

I also don't think you can change the mapping in an extension, but you surely have some options. For example, you can use CoC to extend mapEntityToDataSource(). You'll let the system to assign InventDimId from the mapped dimensions, but then you'll take the other dimensions into account, find/create a new InventDimId and assign it to coProduct.InventDimId.

Was this reply helpful? Yes No
Verified answer

Sachin Mittal 4 on at

Like (0)

Report
Copy link

Link copied!
[ExtensionOf(tableStr(PmfFormulaCoProductV2Entity))] final class PmfFormulaCoProductV2EntityOAB_Extension { public void mapEntityToDatasource(DataEntityRuntimeContext _entityCtx, DataEntityDatasourceRuntimeContext _dataSourceCtx) { next mapEntityToDatasource(_entityCtx, _dataSourceCtx); switch (_dataSourceCtx.name()) { case dataEntityDataSourceStr(PmfFormulaCoProductV2Entity, FormulaCoProduct): PmfFormulaCoBy coProduct = _dataSourceCtx.getBuffer() as PmfFormulaCoBy; InventDim inventDim = InventDim::find(coProduct.InventDimId); inventDim.wMSLocationId = this.wMSLocationId; coProduct.InventDimId = InventDim::findOrCreate(inventDim).inventDimId; break; } }

Thanks , for suggestion , it worked

Was this reply helpful? Yes No