How do I join SalesSalesTaxItemGroupCode column to EcoResProduct table?

(0) Share

Report

Posted on by agneum

150

I have a view that joins InventTable to EcoResProduct, EcoResProductTranslation and InventItemGroupItem.
I now want to add a table that will show SalesSalesTaxItemGroupCode column, exactly as it is shown and exported in the "Released Products V2" entity.

Unfortunately I do not have access to Visual Studio or a development environment to see the joins, is there anyone who knows which table I can find the SalesSalesTaxItemGroupCode column in? And also, how it joins to one of the tables mentioned above?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

GirishS 27,829 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi agneum,

I found that the SalesSalesTaxItemGroupCode field is coming from InventTableModule. On that table there will be field named ModuleType which is enum field which stores values against "Purch", "Sales","Invent".

Based on your requirement you can join InventTable with InventTableModule along with ModuleType to get SalesSalesTaxItemGroupCode field.

Thanks,

Girish S.

Was this reply helpful? Yes No
agneum 150 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for the prompt reply Girish. Your solution worked great!

I joined

dbo.InventTableModule ITM to dbo.InventTable IT on the following condition:

ITM.ItemId = IT.ItemId AND ITM.DataAreaId = IT.DataAreaId AND ITM.ModuleType = 2

Was this reply helpful? Yes No