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?
Consolidated Table or Pivot Item Table
- support
- Site Admin
- Posts: 6181
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Consolidated Table or Pivot Item Table
TEXT_EXT_ITEM_PIVOT_TABLES should be defined in plugins\ext\languages\english.php file
Try to reload files.
Try to reload files.
- support
- Site Admin
- Posts: 6181
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Consolidated Table or Pivot Item Table
Sorry, it's not supported.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.
-
- Posts: 5
- Joined: 20 Nov 2020, 18:20
- Name: Carlos Salinas
- Location: Puerto Cortes, Honduras
- Company Name: Innova Solutions S.A. de C.V.
- Contact:
Re: Consolidated Table or Pivot Item Table
But why the Item Pivot Table take Productos as entity, when I am dfine Materials as source data.
- support
- Site Admin
- Posts: 6181
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Consolidated Table or Pivot Item Table
See documentation https://docs.rukovoditel.net/index.php?p=86
Productos - is entity where report will be displayed in your case.
Productos - is entity where report will be displayed in your case.
-
- Posts: 5
- Joined: 20 Nov 2020, 18:20
- Name: Carlos Salinas
- Location: Puerto Cortes, Honduras
- Company Name: Innova Solutions S.A. de C.V.
- Contact:
Re: Consolidated Table or Pivot Item Table
Nop, I define "Proyectos" as entity where it will be show, not Productos.