Consolidated Table or Pivot Item Table

Ask your questions here.
Post Reply
csalinas
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:

Consolidated Table or Pivot Item Table

Post by 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.

Image

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.

Image

Image

Any idea of how to solve this?

This is my entities structure:

Image

Image

Image

Image

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?

User avatar
support
Site Admin
Posts: 3657
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Consolidated Table or Pivot Item Table

Post by support »

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

csalinas
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

Post by csalinas »

It's defined already.

Image

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.

User avatar
support
Site Admin
Posts: 3657
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Consolidated Table or Pivot Item Table

Post by 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
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

Post by csalinas »

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

User avatar
support
Site Admin
Posts: 3657
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Consolidated Table or Pivot Item Table

Post by support »

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

csalinas
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

Post by csalinas »

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

Post Reply