Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Dual write between Fin...
Finance forum
Suggested answer

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

Posted on by 20

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

  • Ani Staykova Profile Picture
    Ani Staykova 20 on at
    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 Profile Picture
    Deepak Agarwal 148 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans