Consolidated Table or Pivot Item Table

[csalinas]

Hello friends.

I'm trying to make a consolidated table of the materials entered in each of the items called "Individual BOM".

As you can see the image below, if I go to the "Materials" tab of each project, it shows me all the materials, however, as each "Individual BOM" may have repeated materials, the Materials tab also shows them repeated, and what I need is to do the sum of these and group them by material.



I tried to do this with the function Pivot Table by Item of the extension, however, the pivot table shows me the products entity and not the materials entity and does not allow me to do the sum and group them.





Any idea of how to solve this?

This is my entities structure:









PS: I also notice that certain functions of the extension show me weird names, for example Pivot Table of Items is shown as "TEXT_EXT_ITEM_PIVOT_TABLES". Could it be that I have something wrong installed?

[support]

TEXT_EXT_ITEM_PIVOT_TABLES should be defined in plugins\ext\languages\english.php file
Try to reload files.

[csalinas]

It's defined already.



What about consolidated materials table and how I can make a relation between Materials and Proyects so I can make a Item Pivot Table between this 2 entities.

[support]

What about consolidated materials table and how I can make a relation between Materials and Proyects so I can make a Item Pivot Table between this 2 entities.

Sorry, it's not supported.

[csalinas]

But why the Item Pivot Table take Productos as entity, when I am dfine Materials as source data.

[support]

See documentation https://docs.rukovoditel.net/index.php?p=86
Productos - is entity where report will be displayed in your case.

[csalinas]

Nop, I define "Proyectos" as entity where it will be show, not Productos.