Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Unanswered

Database Error When Assigning Sale Tax Codes

(0) ShareShare
ReportReport
Posted on by 20

Hi everyone,

I have been trying to assign tax codes to e-commerce transactions through the following method: 

pastedimage1675110047768v1.png

However, when I try to get a response, the following error is thrown:

{"Database error 'Unknown' occurred for 'execute stored procedure '[crt].GETTAXREGIME_V2''. Procedure or function 'GETTAXREGIME_V2' expects parameter '@nvc_COUNTRYREGIONID', which was not supplied."}

I have the country codes (both three letter and two letter ISO region names) filled out in the ShippingAddress node for the sales transaction as seen here:

pastedimage1675110132796v2.png

pastedimage1675110154001v3.png

Has anyone else run into this issue and know how to fix it?

Thanks!

  • huijij Profile Picture
    huijij 19,811 on at
    RE: Database Error When Assigning Sale Tax Codes

    Hi,

    Please be patient and wait for the answers from others in the forum.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans