(07-12-2021, 10:23 AM)TurboPT Wrote: Ok, well, that join suggestion is obviously not helpful. I'll have to ponder that some more.
Can you add an explain output for the original query, in case it might be helpful?
Hello @TurboPT thanks for your great work.
Well, We have different
manufactured parts as you can see in pic BOM 1.JPG. We already created BOM but in some
manufactured part the BOM doesn't reflect as you can see in pic BOM 2.JPG with manufactured part COMFORT01 yet in BOM 3.JPG COMFORT02 return all the created BOM lists. When you run Bill Of Material Listing report, it shows that all the
Bill Of Materials exists as you can see in report.JPG that
COMFORT01 as a manufactured part contains BOM.
COMFORT01 - Comfort Toilet Papers from Walusubi
JUM003 Jumbo Stock-Walusubi 01/07/2021 04/07/2041 WTC PAC01 11
JUM003 Jumbo Stock-Walusubi 01/07/2021 04/07/2041 WTMPAC01 11
POLY002 Polythene bag 10T-PAK1 (41pcs@Kg) 9x2x2 05/07/2021 06/07/2041 WTC PAC01 10.00
TCOR001 Small Cores 42mm 05/07/2021 06/07/2041 WTC PAC01 6.25
TPOLY001 Printed Polythene for Comfort Big 05/07/2021 06/07/2041 WTC PAC01 10.00
TPOLY002 Polythene bag 10T-PAK2 (41pcs@Kg) 9x2x2 05/07/2021 06/07/2041 WTC PAC01 10.00
TPOLY003 Box Polythenes 100pcs (10pcs@Kg) (25.5x5x5x42) 05/07/2021 06/07/2041 WTC PAC01 1.000
The question is why are some bill of materials not appearing on
Quote:Multi-Level Bill Of Materials Maintenance/ BOMs.php
and others do? Is there some step we're missing