BOM
Posted: 20 Mar 2018, 13:28
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
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