Small and medium business | Business Central, N...

[URGENT] The field Tax Group Id of table Item contains a value X that cannot be found

(1) Share

Report

Posted on by Community member

We have a problem for one of our client from Belgium.

Our application is integration between Dynamics and other system and we have an issue to create an Item through API. This is happening only for this client.
The following error occurs when we try to create an Item:

The field Tax Group Id of table Item contains a value ({A1272569-9819-ED11-90EB-6045BD880AA6}) that cannot be found in the related table (Tax Group)

Tax Group Id we get from fetching Tax Groups using the correct API (Link to public docs)

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_taxgroup_get

We are using correct API and body to create an Item (Link to public docs)

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_item_create

We tried to create an Item for all Tax Groups and non of them are working.

Looking into clients Dynamics account, everything seems to be created properly (Tax Groups).

Tax Groups list contains all the Tax Groups for which we tried to create an Item.

Also, user is able to manually create an Item on Dynamics portal.

Following screenshot shows available Tax Groups on manual Dynamics creation (All of them also available through our system):

Following screenshot shows Tax Group details for above highlighted Tax Group:

Do you see any inconsistencies in above details or is there any flag in the background that determines if we can use the Tax Code in Item creation through API?

Also, not sure if this is relevant information, customer has this account for more than 10 years (Tax Groups as well).

Are there any specific settings that has to be set up for Belgium clients?

Thanks in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, is the taxGroupId assigned to the taxGroupCode? I briefly tested it and did not encounter this problem.

Get:

Post:

In BC:

Was this reply helpful? Yes No
Community member 6 on at

Like (0)

Report

Hi

How can I know if taxGroupId is assigned to the taxGroupCode? Is there a way to check it on Dynamics portal directly?

Here is a screenshot of GET response when we fetch Tax Groups from Dynamics

And later we use this ID to create an Item. Screenshot of request body

And this is the response we get

Same problem occurs for the new Tax Group as well.

Is there any specific limitations for creating Items through API for different region/country accounts (Example, an account from USA or Europe/Belgium)?

Is there any specific configuration that needs to be made for different region/country accounts in order for Items to be created through API?

Looking at the Dynamics docs, this is an example of expected request body for creating the Item

Are any of these fields mandatory?
For example, when we are creating Items we are not sending taxGroupCode, only taxGroupId.

Was this reply helpful? Yes No
Community member 6 on at

Like (0)

Report

Description moved to post bellow

Was this reply helpful? Yes No