Page 1 of 1

BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 13:32
by gazmoz17
Hi,

How do I do the above?

Is there a way to add screen shots into my post etc.

Section
4. ITEM_NUMBER footer ; Filter SOP_ITEM.SERVICE_FLAG = 0

;Data fields below

SOP_ITEM.STOCK_CODE SOP_ITEM.DESCRIPTION STOCK.WEB_CATEGORY_1 STOCK.WEB_2 STOCK.WEB_3 SOP_ITEM.QTY_DESPATCH

;Ive abrev stck web categs above.

Want it do the same but pull through Web category values for the BOM subcomponents?

;Conditional formatting on all stock web cat's is:

Filter
SOP_ITEM.STOCK_CODE IN ("1010", "1011", "1209", "1189", "1210", "2010", "2011", "2012", "2020", "2021", "2022", "2112", "2115", "2116", "3017", "3018", "3021", "3023", "3024", "3027", "3029", "3096", "5575", "6000", "6001", "7006", "7008", "7028", "7029", "7031", "7033", "8100", "8550")
begin
SuppressPrinting: =True;
end
Properties

Many Thanks in advance
Gareth

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 13:54
by brucedenney
You can attach the screen shots or even the actual layout / report file using the Attach option below the compose window
Untitled.png

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 14:00
by brucedenney
Can you attach the actual layout you are using as there are so many things that could be issues.

From what you have said I think you want to print an expanded BOM for each item ordered and against each item in the BOM you want to put the stock category of that item.

Is that correct?

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 14:05
by gazmoz17
Thanks Bruce, much appreciated-hopefully these have attached.

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 14:15
by gazmoz17
Here are 2 exapmle...thanks

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 14:36
by brucedenney
I removed the SALES DELIVERY ADDRESS table as it was unlinked
I removed the fields from the SALES DELIVERY ADDRESS table, you want to use the ones form the SALES_ORDER table.
I added the field COMPONENT.STOCK_CAT_NAME into the details section.

It now prints the Stock Category of the Component in Red.

I used to work in a boat builders, oh the smell of GRP....

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 14:44
by gazmoz17
Haha what were the chances of that! Yeah we have a lot of boat hobbyists come in were not really large enough for any commercial marine businesses. Kind of immune to the smell now unless its catalysed going off! Having a look now, really appreciate this.

Re: BOM items on delivery note-amending existing expressions

Posted: 23 Jul 2019, 15:11
by gazmoz17
Hi Bruce, please see the attached.

After aN itemised BOM product just back to normal for next none BOM product.

Many Thanks

Re: BOM items on delivery note-amending existing expressions

Posted: 24 Jul 2019, 09:39
by brucedenney
I think you have enough to be able to complete your report.

If you need further help please feel free to make more posts, explaining what you are having difficulties doing.

I would rather you spend a little time clearly describing the issue/objective with a good title as that will help others when they have the same issues and save me repeating myself.

Re: BOM items on delivery note-amending existing expressions

Posted: 24 Jul 2019, 12:38
by gazmoz17
Hi Bruce, thanks once again for the reply. Maybe I didnt explain myself properly...the Test Kit layout asnt the layout I wanted amending (was an e.g.) the layout I wanted amending was 2017 Delivery note ADR.

The layout that youve edited I dont require the data field that you added. But I need the data tables linking so could include the component web details. I know how to do this now thanks...so Ive made these data fields now avail on the layout I do require editing.

However, I dont know how to add the sections/groups needed to pull through the BOM products with the component web details.

Re: BOM items on delivery note-amending existing expressions

Posted: 24 Jul 2019, 12:40
by gazmoz17
.... I dont know how to amend the expressions to included normal stock web category fields and Component web category fields. The same expression will apply to both.

Thanks
Gareth

Re: BOM items on delivery note-amending existing expressions

Posted: 24 Jul 2019, 16:46
by brucedenney
The way you linked the tables there are 2 copies of the STOCK table, one called STOCK which relates to the BOM and one called COMPONENTS which relates to the Components in the BOM.

By using the right reference you will get the data you want in your expression.