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
- - - - - - - - - - - - - - - - - - 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
Service Item Lines being Duplicated when Printing
-
- User
- Posts: 14
- Joined: 02 Sep 2013, 16:25
- Sage Version: v2013 19 UK/Europe/Africa
Service Item Lines being Duplicated when Printing
We have tweaked the existing SOP Plain A4 Layout to our needs. Originally we found that when using service Items no description was being printed. This was quickly resolved by changing the 'Text' filed to 'Description' in section 3.Details. However now when printing all Service Code lines print twice, but normal stock item line print correctly once.
We're really stumped on this as this is a second company, and the original template was copied from the first company, which appears to print ok?
Can anyone spot what we're missing?
We're really stumped on this as this is a second company, and the original template was copied from the first company, which appears to print ok?
Can anyone spot what we're missing?
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
There are 2 sections in this sort of layout, one is for service items and one is for product items
If you look at 4. ITEM_NUMBER Footer you will see that it has a filter of SOP_ITEM.SERVICE_FLAG = 0 on it. so this section only prints if this is a not service item.
If you look at 3. Details it has a filter of SOP_ITEM.SERVICE_FLAG <> 0 so it only prints if it is a service item.
It looks to me that you have service items that have no long description (TEXT) and where you want to print the short description (DESCRIPTION)
You have got both so when you have something in both you will get them both on top of each other. Is this the issue or are you getting separate lines, printing twice is vague.
If you look at 4. ITEM_NUMBER Footer you will see that it has a filter of SOP_ITEM.SERVICE_FLAG = 0 on it. so this section only prints if this is a not service item.
If you look at 3. Details it has a filter of SOP_ITEM.SERVICE_FLAG <> 0 so it only prints if it is a service item.
It looks to me that you have service items that have no long description (TEXT) and where you want to print the short description (DESCRIPTION)
You have got both so when you have something in both you will get them both on top of each other. Is this the issue or are you getting separate lines, printing twice is vague.
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
- Posts: 14
- Joined: 02 Sep 2013, 16:25
- Sage Version: v2013 19 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
Hi Bruce,
Sorry it was so vague, for example with have a stock code AFDEL, so if we raise a Sales Order (Service Item not Stock):
CODE Description Qty £
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200999 1 25.30
What actually prints is:
CODE Description Qty £
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200999 1 25.30
AFDEL Del Ref: 200999 1 25.30
Sorry it was so vague, for example with have a stock code AFDEL, so if we raise a Sales Order (Service Item not Stock):
CODE Description Qty £
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200999 1 25.30
What actually prints is:
CODE Description Qty £
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200123 1 11.73
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200525 1 10.13
AFDEL Del Ref: 200999 1 25.30
AFDEL Del Ref: 200999 1 25.30
-
- User
- Posts: 14
- Joined: 02 Sep 2013, 16:25
- Sage Version: v2013 19 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
Also we only enter the product description details in the Description box, we don't use the long text box.
I tried what you describe and I don't get the duplication.
I tried what you describe and I don't get the duplication.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
Excuse me for asking, but why are you using a service product if you are not using the text box, that was the only point of having service items, or is there something I am missing?
I can't reproduce the duplication by doing what you are describing on the demo data.
Are you sure the layout you posted is the one you are using?
I can't reproduce the duplication by doing what you are describing on the demo data.
Are you sure the layout you posted is the one you are using?
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
- Posts: 14
- Joined: 02 Sep 2013, 16:25
- Sage Version: v2013 19 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
Yes it's the correct layout.
I've also attached a screen shot of a Sales Order and then a copy of the pdf showing how it prints using the templates.
We've also cross reference the Sales order template with the delivery note and invoice one as they print correctly, to see if we had set up section flags and such wrong, but can't see anything........
I've also attached a screen shot of a Sales Order and then a copy of the pdf showing how it prints using the templates.
We've also cross reference the Sales order template with the delivery note and invoice one as they print correctly, to see if we had set up section flags and such wrong, but can't see anything........
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
I have done the same thing and I don't get the same results!
There is something strange happening.
I think that we need to establish what is happening for sure.
I assumed that the duplication is because both sections The Service (3) and the not service (4) sections are both printing for the one line on the order. they both look identical so it is hard to tell them apart. Attached is a slightly modified version of the original you posted that show the service flag on each line. Can you print the order using this layout so we can see if the the same line is repeating or if it is different lines.
Can you also try adding an "S3" service item to an order and see if that duplicates.
There is something strange happening.
I think that we need to establish what is happening for sure.
I assumed that the duplication is because both sections The Service (3) and the not service (4) sections are both printing for the one line on the order. they both look identical so it is hard to tell them apart. Attached is a slightly modified version of the original you posted that show the service flag on each line. Can you print the order using this layout so we can see if the the same line is repeating or if it is different lines.
Can you also try adding an "S3" service item to an order and see if that duplicates.
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.
Re: Service Item Lines being Duplicated when Printing
Hi Bruce,
Just reading through this as i'm having a similar issue on the service lines printing multiple time, and i think for myself it's because I've included the GDN table which you helped me with a while back.
I've managed to pull this expression in for the service line INVOICE.ITEM.TEXT field as per
"Length(INVOICE_ITEM.DESCRIPTION) = 0 ? INVOICE_ITEM.TEXT :
Substring(INVOICE_ITEM.TEXT,0,Length(INVOICE_ITEM.DESCRIPTION)) = INVOICE_ITEM.DESCRIPTION ? INVOICE_ITEM.TEXT :
INVOICE_ITEM.DESCRIPTION + "
" + INVOICE_ITEM.TEXT "
We use both fields and this pulls both descriptions in quite nicely. I'm not sure if this is useful, as i was getting duplication prior to adding this in.
All the Service item fields are in the Details section and set to reset after "Details", and i think i'm getting duplicated lines depending on how many items are on the dispatch note.
I've tried different reset groups etc but nothing seems to work.
The filters for each group are as per your advice, so i'm not exactly sure where my focus should be to try and resolve it ?
Thanks for your time again in advance.Paul
Just reading through this as i'm having a similar issue on the service lines printing multiple time, and i think for myself it's because I've included the GDN table which you helped me with a while back.
I've managed to pull this expression in for the service line INVOICE.ITEM.TEXT field as per
"Length(INVOICE_ITEM.DESCRIPTION) = 0 ? INVOICE_ITEM.TEXT :
Substring(INVOICE_ITEM.TEXT,0,Length(INVOICE_ITEM.DESCRIPTION)) = INVOICE_ITEM.DESCRIPTION ? INVOICE_ITEM.TEXT :
INVOICE_ITEM.DESCRIPTION + "
" + INVOICE_ITEM.TEXT "
We use both fields and this pulls both descriptions in quite nicely. I'm not sure if this is useful, as i was getting duplication prior to adding this in.
All the Service item fields are in the Details section and set to reset after "Details", and i think i'm getting duplicated lines depending on how many items are on the dispatch note.
I've tried different reset groups etc but nothing seems to work.
The filters for each group are as per your advice, so i'm not exactly sure where my focus should be to try and resolve it ?
Thanks for your time again in advance.Paul
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
Best if you attach the layout and I can have a look.
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.
Re: Service Item Lines being Duplicated when Printing
Hi Bruce,
Here is the attached.
Here is the attached.
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
I am unable to reproduce the result you are experiencing, it must be a number of conditions that need to be in place to make it happen, using the demo data, nothing would print, because there were no GDNs, having created GDNs, they all print fine with no issues. I tried adding S3 items and non stock items from stock, I couldn't get the same results.
Without being able to reproduce the issue, I can't really help much.
Without being able to reproduce the issue, I can't really help much.
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.
- brucedenney
- Site Admin
- Posts: 4643
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Service Item Lines being Duplicated when Printing
I had another go and managed to reproduce the issue.
The problem is that you are linking to the GDN_ITEM table, so all the items on the GDN are returned for each invoice so you get multiple lines.
I am not sure why you don't get this on the Stock Items...
Anyway if you add a filter to limit the records returned to just one eg " GDN_ITEM.ITEM_NUMBER = 1 " then it will work.
The problem is that you are linking to the GDN_ITEM table, so all the items on the GDN are returned for each invoice so you get multiple lines.
I am not sure why you don't get this on the Stock Items...
Anyway if you add a filter to limit the records returned to just one eg " GDN_ITEM.ITEM_NUMBER = 1 " then it will work.
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.
Re: Service Item Lines being Duplicated when Printing
Bruce you genius!!
I was just about to write to you as i'd remembered a difference between an invoice template that we use based on raising invoices from new, where the sales order information is not built in on the Order Tab, where it works no problem and this one we are looking at which is an invoice raised automatically from a sales order once dispatched.
So, i was just about to look at that GDN table myself and just saw your reply.
I cannot thank you enough for re-visiting this for me.
This solution works like a dream.
Many thanks
Paul
I was just about to write to you as i'd remembered a difference between an invoice template that we use based on raising invoices from new, where the sales order information is not built in on the Order Tab, where it works no problem and this one we are looking at which is an invoice raised automatically from a sales order once dispatched.
So, i was just about to look at that GDN table myself and just saw your reply.
I cannot thank you enough for re-visiting this for me.
This solution works like a dream.
Many thanks
Paul
Who is online
Users browsing this forum: No registered users and 1 guest