Finance | Project Operations, Human Resources, ...

Dual write between FinOps and CE - error Tax exempt number in Accounts

(0) Share

Report

Posted on by Ani Staykova

Hello,

we are trying to synch Accounts (CE) to Customers (FinOps) and it is ok until we fill Tax exempt number in the Account.

When we fill in the Tax exempt number, we receive an error on Save which is coming from a validation in FinOps:

"Unable to write to Finance and Operations apps due to following error(s): {"Write failed for entity Customers V3
with unknown exception - Value 55666777 in the Tax exempt number field is not found for country/region
USA neither in the relating table Tax exempt number table, nor in Registration IDs.\nvalidateField failed on field 'CustCustomerV3Entity.TaxExemptNumber'"}
Please rectify your data and try again. If issue persists after multiple retries, please contact your system administrator."

The error in FinOps can be skipped if we fill in the Tax exempt number in TaxVATNumTable /form: Tax exempt numbers/, but we don't see an option to fill it from CE /automatically or manually/.

Could you please share what may be missing in our setup.

Thanks

All responses (2)

Answers (0)

Ani Staykova 20 on at

Like (0)

Report

RE: Dual write between FinOps and CE - error Tax exempt number in Accounts

Hello Harry,

We don't want to record default value in Tax exempt number. We are using the out of the box mapping between Customers V3 and Accounts /the same that you share above in the first link/ and we are testing to fill in any value as it will be populated later by user in CE, but no matter what we fill in the field, the process to save the record ends with error.
Suggested answer

Deepak Agarwal 148 on at

Like (0)

Report

RE: Dual write between FinOps and CE - error Tax exempt number in Accounts

Does that mean you done have any field in CE for Tax Exempt number, I would suggest to raise this with MS.

Additionally, if you want to pass any default value in this field and If I recall the Dual write mapping, there must be way to put a default value.

Check below link with says there are mapping available.

Dual-write mapping reference

Default values