SageForum for UK versions of Sage 50- Help and support.

Hi

I need to find a way to show the bill of materials in a report so it shows the child items not the parent items I have the below but then it shows anything without a BOM as 0 quantity and is also showing only 1 item on the BOM and not the 2 as it should be.

STOCK.HAS_NO_COMPONENT = 1
? INVOICE_ITEM.QTY_ORDER
: STOCK_COMP.COMPONENT_QTY * INVOICE_ITEM.QTY_ORDER

STOCK.HAS_NO_COMPONENT = 1
? INVOICE.STOCK_CODE
: STOCK_COMP.COMPONENT_CODE

If anyone can help that would be amazing

Thank you

The Data returned from the request will only include STOCK records that have a related STOCK_COMP.

If you look at the join between the STOCK table and the STOCK_COMP table you need to alter that so that when there are no STOCK_COMP records it still returns the data from the STOCK table, you do this by altering the join to be a "Parent Outer" instead on an "Inner"