Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

BOM items on delivery note-amending existing expressions

Report design issues and solutions.
Post Reply
gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 23 Jul 2019, 13:32

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

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

Re: BOM items on delivery note-amending existing expressions

Post by brucedenney » 23 Jul 2019, 13:54

You can attach the screen shots or even the actual layout / report file using the Attach option below the compose window
Untitled.png
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

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

Re: BOM items on delivery note-amending existing expressions

Post by brucedenney » 23 Jul 2019, 14:00

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?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 23 Jul 2019, 14:05

Thanks Bruce, much appreciated-hopefully these have attached.
Login to access the files attached to this post.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 23 Jul 2019, 14:15

Here are 2 exapmle...thanks
Login to access the files attached to this post.

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

Re: BOM items on delivery note-amending existing expressions

Post by brucedenney » 23 Jul 2019, 14:36

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....
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 23 Jul 2019, 14:44

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.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 23 Jul 2019, 15:11

Hi Bruce, please see the attached.

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

Many Thanks
Login to access the files attached to this post.

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

Re: BOM items on delivery note-amending existing expressions

Post by brucedenney » 24 Jul 2019, 09:39

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 24 Jul 2019, 12:38

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.

gazmoz17
User
User
Posts: 108
Joined: 19 Sep 2018, 13:58
Sage Version: v2018 24 UK/Europe/Africa

Re: BOM items on delivery note-amending existing expressions

Post by gazmoz17 » 24 Jul 2019, 12:40

.... 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
Login to access the files attached to this post.

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

Re: BOM items on delivery note-amending existing expressions

Post by brucedenney » 24 Jul 2019, 16:46

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 16 guests