dual-write custom creation filtering of standard entity

(0) Share

Report

Posted on by dark_knight

1,114

Hello,

I have a standard dual-write entity "cds sales order headers". Underlying entity in AOT is SalesOrderHeaderCDSEntity

I need only those newly created SalesOrders in FO to be created in CE that have SalesOrderOriginCode equal to those values pointed out in the parameters of "Accounts receivable" module.

Simple dual-write filtering described here

docs.microsoft.com/.../customizing-mappings

isn't sutable for me as I see it. My scenario is more difficult. So I believe I should do that via code in some method of dataentity. Or I'm wrong and complex filtering can be done in dual-write UI?

If via code s what's the best dataentity method for that? InsertEntityDataSource()?

Thanks.

I have the same question (0)

All responses (2)

Answers (0)

huijij 19,811 on at

Like (0)

Report
Copy link

Link copied!

Hi Azat,

Would you specify what are your business requirements?

Was this reply helpful? Yes No
dark_knight 1,114 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have dual-write set up. SalesOrders are synchronized by means of the stdnard dual-write data entity below:

there is a standard mapping for salesorigincode field

I need only those SalesOrders to be synchronized from FO to CE that particular value of salesorigincode(SalesTable.SalesOriginID). Those particular values are pointed out in CustParameters. Therefore I need to fetch them by code like SalesParameters salesParameters = SalesParameters::find();

I can't use this standard filter of dual write (fix if I'm wrong) as far as I get it because it works only for simple constant values. I can't write there any X++ code indeed

therefore I think I should create a computed column returning boolean value depending on the value of salesorigincode and then use this value in the filter of dual write here

Is it a correct approach?

Thanks

Was this reply helpful? Yes No