Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
BOM Component not listed
07-09-2021, 06:53 PM, (This post was last modified: 07-09-2021, 07:10 PM by wissedenis22.)
#1
BOM Component not listed
I have failed to understand why some of BOM items are not showing yet when you run Bill Of Material Listing report they show.
I have a manufactured part 'COMFORT01' which totally returns null when you want check it's BOM list. yet on Bill Of Material Listing report  shows that BOM components exists like it's in pic 1.

pic 2 

Another case is again manufactured Part 'NEWTEST' has a missing BOM item missing yet on Bill Of Material Listing report it exists.

I tried to run this query manually from this file "BOMs.php" which displays [b]Component Details, again it returns null manufactured part '[b]COMFORT01[/b][/b]

Code:
    INNER JOIN stockcategory
                ON stockcategory.categoryid = stockmaster.categoryid
                    INNER JOIN locations ON
                bom.loccode = locations.loccode
                INNER JOIN workcentres
                ON bom.workcentreadded=workcentres.code
                INNER JOIN locstock
                ON bom.loccode=locstock.loccode
                AND bom.component = locstock.stockid
                INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND locationusers.userid='admin' AND locationusers.canupd=1
                
                WHERE                
                 bom.component IN ('JUM002','FIR001','POLY002','TCOR001','COO001','TCOR005','TGLUE001','TPOLY001','TPOLY002','TPOLY003')
                AND bom.parent IN ('COMFORT01','JUM003','TCOR001');

but when I tried to remove this AND RUN AGAIN
Code:
INNER JOIN locstock
                ON bom.loccode=locstock.loccode
                AND bom.component = locstock.stockid

 it returned some values.

So I failed to understand when creating New Component Details does the system sometimes fail to link the two tables "locstock and bm" or I there is  a step I missed when creating locstock


Attached Files Thumbnail(s)
       
Reply
07-10-2021, 10:01 AM, (This post was last modified: 07-10-2021, 10:01 AM by TurboPT.)
#2
RE: BOM Component not listed
(07-09-2021, 06:53 PM)wissedenis22 Wrote:
Code:
INNER JOIN locstock
    ON bom.loccode=locstock.loccode
    AND bom.component = locstock.stockid

Should the last part of that join possibly instead be:
Code:
INNER JOIN locstock
    ON bom.loccode=locstock.loccode
    AND bom.component = stockmaster.stockid
...based on the FK reference to bom.component?
Reply
07-11-2021, 04:31 PM,
#3
RE: BOM Component not listed
(07-10-2021, 10:01 AM)TurboPT Wrote:
(07-09-2021, 06:53 PM)wissedenis22 Wrote:
Code:
INNER JOIN locstock
    ON bom.loccode=locstock.loccode
    AND bom.component = locstock.stockid

Should the last part of that join possibly instead be:
Code:
INNER JOIN locstock
    ON bom.loccode=locstock.loccode
    AND bom.component = stockmaster.stockid
...based on the FK reference to bom.component?

If I do SO and replace 
Code:
AND bom.component = stockmaster.stockid
it returns values but they it's  repeating the components and the list is too long, I mean it's not supposed to be like that!
Please check the attachments.


Attached Files Thumbnail(s)
       
Reply
07-12-2021, 10:23 AM, (This post was last modified: 07-12-2021, 10:49 AM by TurboPT.)
#4
RE: BOM Component not listed
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?
Reply
07-12-2021, 06:45 PM, (This post was last modified: 07-12-2021, 06:51 PM by wissedenis22.)
#5
RE: BOM Component not listed
(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


Attached Files Thumbnail(s)
               
Reply
07-13-2021, 12:20 PM, (This post was last modified: 07-13-2021, 12:51 PM by TurboPT.)
#6
RE: BOM Component not listed
To ensure I'm looking at the same code, what version are you using?

It's going to take me a little time to dig into this area.
Reply
07-13-2021, 03:04 PM,
#7
RE: BOM Component not listed
(07-13-2021, 12:20 PM)TurboPT Wrote: To ensure I'm looking at the same code, what version are you using?

It's going to take me a little time to dig into this area.
 Am using webERP version 4.14.1
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)