Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

BOM

Report design issues and solutions.
Post Reply
christina
User
User
Posts: 9
Joined: 16 Feb 2018, 22:08
Sage Version: v2018 24 UK/Europe/Africa

BOM

Post by christina » 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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4294
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: BOM

Post by brucedenney » 20 Mar 2018, 15:06

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"
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest