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.
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
Hi Azat,
Would you specify what are your business requirements?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156