Hello everyone,
I am currently in version 16 and I have the following situation. Lets suppones I have the following MO to produce a product X
Type of product - component | Product | Quantity for order in BoM | Real quantity used in MO (flexible consumption) |
Storable | A | 130 | 140 |
Storable | B | 15 | 20 |
Consumable | C | 109.5 | 100 |
I want to generate a report that will allow me to compare, for several MOs, the difference between the quantity demanded by the BoM and the real quanity used in each MO.
When creating the report, I try exporting to excel with all kinds of different combinations of fields, but the difference in the generate report is confusing. I post a example of all the different fields tried.
The generated report creates something like this:
Component | Component>quantity_done | Component>product_uom_qty |
A | 140 | 130 |
A | 0 | 10 |
B | 20 | 15 |
B | 0 | 5 |
C | 100 | 100 |
C | 0 | 0 |
In the created report, there is no clear difference between what was originally demanded and what was realy used, specially for product C (consumable).
If the situation of components was the contrary for each component I would get something like
Component | Component>quantity_done | Component>product_uom_qty |
A | 120 | 120 |
A | 0 | 10 |
B | 10 | 10 |
B | 0 | 5 |
C | 120 | 19.5 |
C | 0 | 1.5 |
The data is extremely confusing, there is no real way to deterine wether a component was used in a lower or greater quantity than demanded by the BoM.
Has anyone needed to create a simialr report? How can I generate the correct data?
