Description of STOCK.COMPONENT_CODE_1 on SOPBOM.Layout

[sam200500]

Hi,
I am new to sage, I am using Sage 50 Account Professional 2010.
For printing Sales Order I am using SOPBOM.Layout
It prints STOCK.COMPONENT_CODE_1 and No.of Qty required to build that Item.
I want to insert component description for STOCK.COMPONENT_CODE_1 (this description is not same of SOP_ITEM.DESCRIPTION)
In Product explosion PRDEXPL.report it has table COMPONENT.DESCRIPTION

How can I add table COMPONENT.DESCRIPTION to Sales order SOPBOM.layout ?
or How can I get component description on SOPBOM.Layout ?
Please can anyone help me out.

[billshankley]

Firstly before amending reports always make a copy so you can go back to the drawing board.

You want to go to "data/joins" in the top toolbar and add the component.description table and then link it on a primary key like stock code to stock code then go back to your report and add the variable.

I'm not sure if that will work immediately but if not you might need to play with the join type, if the component.desription table doesn't always have a record for what your looking for i think you might want to look at using a parent outer join.

Shanks

[Site4]

Don't know whether this helps, but..

The component table is an alias for stock, so you'll need to add the stock table and call it component, then join on stock.component_code_x > component.stock_code. And then as far as I can see, repeat for all (50?) component codes.

[sam200500]

Don't know whether this helps, but..

The component table is an alias for stock, so you'll need to add the stock table and call it component, then join on stock.component_code_x > component.stock_code. And then as far as I can see, repeat for all (50?) component codes.

Hi,
Thanks, but BOM Heading [BOMCode -- Description --- QtyRequired] is printing after each record even on those item which dont have BOM,
and even if two item has BOM on same sale order it gives BOM detail only for first item.

Please can any one tell me what changes I should do to ( ITEM_NUMBER footer ) following fillter was already their:
STOCK.COMPONENT_CODE_1 <> "" AND SOP_ITEM.STOCK_CODE NOT IN ("M","S1","S2","S3")

My new alias stock tabe name is COMP1 and I am taking variable "description" COMP1.DESCRIPTION
(STOCK.COMPONENT_CODE_1 = COMP1.STOCK_CODE)

[Site4]

Well, I'd suggest starting with the section filters that come with the standard report as that seems to be working properly here... These are

Details - STOCK.COMPONENT_CODE_1 <> ""
Item_Number footer (that contains the qty_ordered & Stock_code etc) - SOP_ITEM.SERVICE_FLAG = 0
Item_Number footer (that contains the BOM header text) - STOCK.COMPONENT_CODE_1 <> ""
Item_Number footer (that contains the Component_Code_1 etc) - STOCK.COMPONENT_CODE_1 <> ""
Item_Number footer (that contains the Component_Code_2 etc) - STOCK.COMPONENT_CODE_2 <> ""
and so on to
Item_Number footer (that contains the Component_Code_10 etc) - STOCK.COMPONENT_CODE_10 <> ""

Then, I think you will need to create aliases COMP2 - COMP10 based on (STOCK.COMPONENT_CODE_2 = COMP2.STOCK_CODE) etc and use COMP2.Description etc to get the correct descriptions for each component.