Finance | Project Operations, Human Resources, ...

How can I join TaxCode and TaxGroup tables?

(0) Share

Report

Posted on by agneum

150

Hi,

I have exported the following tables: TaxCodeEntityStagin, TaxCodeValueEntityStaging, TaxGroupEntityStaging (entities from D365: sales tax groups, sales tax codes, value etc.)

I need a table that lists code, the group it belongs to and the value. I'm having difficulty connecting the Code to the Group. How do I do that.

I have the same question (0)

All responses (6)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi agneum,

There is relation between TaxCodeEntityStagin and TaxCodeValueEntityStaging based on

TaxCodeValueEntityStaging.TaxcodeId == TaxCodeEntityStagin .TaxCode

I don't see any relation with TaxGroupEntityStaging. What is your exact requirement here?

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Agneum,

According to the entity relations, it's TaxItemGroupEntityStaging.TaxCodeId = TaxCodeEntityStaging.TaxCode and TaxItemGroupEntityStaging.DataAreaId = TaxCodeEntityStaging.DataAreaId

Was this reply helpful? Yes No
agneum 150 on at

Like (0)

Report

The thing is, I cannot find this table "TaxItemGroupEntityStaging" in the list of entities:

When I filter entities I can only find this one (TaxItemGroupHeadingStaging):

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi agneum,

You may need to refresh the entity list from Data management - Parameters form. By the way, which version are you using?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi ageneum,

What do you want to do with the exported tax data?

Best regards,

Ludwig

Was this reply helpful? Yes No
agneum 150 on at

Like (0)

Report

Rates change on monthly basis and we want an easy way to export the data so that we can easily identify changes in rates and update across hundreds of sales tax groups. Ideally also adjust in bulk to D365.

Was this reply helpful? Yes No