SageForum for UK versions of Sage 50- Help and support.

Hi

Looking for some help with the following issues.

1. I have updated our Invoice template which prints out fine with our logo and certificate of conformity text etc

Problem is that when I try to email our clients it does not use this template even if I go to print and select template then click on email

2. Despatch notes -
Trying to get weight printed out on the despatch template.
I can get to to print the weight using the variable but not the unit weight (Kg) etc
Also if I have several of the same item (eg 3 off 7kg = £21kg) it does not add up. Would need to also add up if more than 1 item

3. Despath Note - Reprint GNDPRNT
If I have printed the despatch note and at a later date need to print another one and go into the order and despatched tab and click on Print GND it doesnt print the same template I use for normal despatch

Any help with these problems would be great

Are you sending the email as a PDF ? templates are backgrounds, they are only on PDF's

Weigth need to be and expression, eg cstring of "Qty * Weight " plus the "kg"

They are different remplate, you need to set up a template for you GRN

Hi

Thanks for the reply

Think I now have the email purchase orders (PDF) working, if I select files then click on print and then select e-mail instead of just selecting email it seems to work! Not sure why I cant just select email and it work seems to use some old type of standard template?

Can you give me some step by step instruction on how to add the weights etc on to my template?

Also the GDN file I renamed the old one on the hard drive with extension .old and copied over my new Delivery/Despatch note and called it GDNPRNT.report but it still does work any ideas or step guide.


Thanks

You can't just rename the file, the GDN uses a different set of data to the delivery note, you need to take the original gdn layout and alter it

Adding weights is a little more complex that it would at first seem.

The reason for this is that the weight is in the stock file and the stock file is not in the joined tables the layout has.

Go to data> join

drag and drop the stock table into the central area

Then drag the stock_code from the invoice_item table and drop it on the stock_code on the stock table this will create a join based on these both being the same.

This will causes a problem, because some items on invoices do not have corresponding stock items (M, S1,S2,S3) whilst you might not use these now, you could be creatign a huge headache for someone in future if you do not consider them now. They will experiance these items not printing.

The solution is easy, change the join type in the join edit to parent in both boxes, this means it will join when it can, but still return the data from the invoice item table if the join can not be made.

Save the changes to the joins and the stock table will now be visible and you can add the weight from the stock table to your report.

Hi

when I did as you suggested and added the weight for materials it showed upon the printout but didn't update the quantities e.g. 1 sheet 7kg but when I added 4 sheets still said 7kg????


Any steps I need to add would be appriciated


Neil

Hi Bruce

Any help with this would be great

Cheers

Neil

If you want to multiply the qty by the weight then you need to add an expression to the report to do the maths.

did it work?

Hi

New to sage so not sure how to do expressions can you give example or help as would like to get this to work on our despatch notes

This is rather difficult to do in a forum but here goes

Open up the report in the report designer.
In the toolbox select the expression and drop it on the report.
in the expression editor you now build the expression
you can type, double click or drag and drop.

So in the table "Stock" find the field for weight and double click it. this full name will appear in the expression editor STOCK.UNIT_WEIGHT
now type a * (this signify multiplication, it is what excel and every other maths tool uses to signify multiplication)
Now you need to enter the Qty field from the items table.

This field will now be the qty multiplied by the weight for each line in the invoice/order

Hi

Just created expression but doesn't seem to work

STOCK.UNIT_WEIGHT * STOCK.QTY_ALLOCATED

Any Ideas?

Regards
Neil

I think you would want to use QTY_DESPATCH which is the number being shipped.