Integration between D365 F&O and CE Dual-write RefRecId field type

(0) Share

Report

Posted on by Sophs@4Sight

143

Good morning

We are experiencing a problem with an integration issue between D365 F&O and CE via Dual-write.

Our solution creates records in D365 F&O (Table A), this contains the RefRecId to a different table (Table B). Table A is then Dual Write to CE.

CE then uses this Table A record to create one or multiple records that is then passed back to F&O in a new table (Table C).

The problem we are experiencing is that the TableA.Refrecid needs to be passed over to the Table C.RefRecid so that it can be used for processing when back in F&O.

What is the field type to use in CE.

INT does not allow any fields larger than 2147483647 and when we use BigInt, it works when Syncing from F&O to CE, but when Syncing from CE back to F&O we get the following error /Dual Write core application error-unsupported source field type {biginteger}, {ddd_refrecid}, {table3.ddd_refrecid}/.

How do we solve this problem. Any help will be appreciated.

All responses (3)

Answers (0)

Martin Dráb 231,305 Most Valuable Professional on at

Like (0)

Report

Integration between D365 F&O and CE Dual-write RefRecId field type

Unfortunately, you're right. This table doesn't offer any key that can be used instead of RecId.
Sophs@4Sight 143 on at

Like (0)

Report

Integration between D365 F&O and CE Dual-write RefRecId field type

Hi Martin, thank you for your quick response.

The table I need to reference is ProjInvoiceItem. And there is no unique index, unless I am missing something.
Martin Dráb 231,305 Most Valuable Professional on at

Like (0)

Report

Integration between D365 F&O and CE Dual-write RefRecId field type

Data entities should expose natural keys, not RecIds. Can you change the design of the entity?