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!

Delivery note edit to include product sub components bill of materials

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

Delivery note edit to include product sub components bill of materials

Post by gazmoz17 » 16 Nov 2018, 15:52

Hi,

Have a current delivery note I want it top operate in the same way as currently does but pull through sub components.

Ive made tool kits for diff pack sizes.

Can anyone edit my current delivery note im willing to pay?

Current edit doing this myself works but it keep repeating...

SKU 7000 10M Tool kit
sub component SKU 400 hammer ;1st component for above kit/sku

SKU 7000 10M Tool kit
sub component SKU 500 drill ;2nd component for above kit/sku

How do I get it to just do below:

SKU 7000 10M Tool kit
subcomponet 1
subcomponet 2
subcomponet 3; etc *without repeating the tool kit name between subcomponents?

Many Thanks
Gareth

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

Re: Delivery note edit to include product sub components bill of materials

Post by brucedenney » 16 Nov 2018, 15:57

Create a header / footer pair based on the stock code, then put the bits relating to the stock code that you do not want repeating in either the header or footer depending on where you want them to appear relative to the expansion of the BOM.

If you have an empty header and/or footer make the visible property false so they do not show.
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

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

Re: Delivery note edit to include product sub components bill of materials

Post by gazmoz17 » 16 Nov 2018, 16:20

Ok thanks Bruce I'm going to have a look at this tonight based on wht youve posted and the help guides etc when ive finished work.....

On normal products which arent BOM I have the following fields pulling though next to product description:

STOCK.WEB_CATEGORY_1 STOCK.WEB_DETAILS STOCK.WEB_CATEGORY_2 STOCK.WEB_CATEGORY_3 STOCK.WEB_DESCRIPTION

I want the same fields to pull through for the subcompenents?

Thanks in advance

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

Re: Delivery note edit to include product sub components bill of materials

Post by brucedenney » 16 Nov 2018, 17:45

You will need to link the stock table to the components stock code, this will give you a second stock table with a different name, use that as the reference to the Stock fields and you will pull the field for the component rather than the item.
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 2 guests