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
Search found 48 matches
- 11 Jul 2017, 10:35
- Forum: Sage 50 UK version General Help
- Topic: Reconcile Bank will not run on USD dollar account but will for GBP
- Replies: 5
- Views: 3463
Re: Reconcile Bank will not run on USD dollar account but will for GBP
Well, i've gone into my server, logged in as manager, no access rights i can change for that, that i can see, and i started the process 20mins ago, and it's still going. I'm not sure this is access or permissions? maybe something else ?
- 11 Jul 2017, 08:06
- Forum: Sage 50 UK version General Help
- Topic: Reconcile Bank will not run on USD dollar account but will for GBP
- Replies: 5
- Views: 3463
Reconcile Bank will not run on USD dollar account but will for GBP
Hi, I'm a little stumped with this one, as Sage are too. So, when running the Reconcile function on our UK bank account (1200), no problems at all, and until a few days ago the USD Dollar account (1220) just brings up and hangs on the small processing window which we have to crash out of sage in ord...
- 30 Jun 2017, 12:41
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Yes that's worked ! when you say "it will not support different addresses for different purposes, it will just the the account address." i'm unsure what that means exactly? Also, can i use this report now for the DELPLAINA4 Layout used for producing notes via the Despatch Notes process. I ...
- 30 Jun 2017, 11:34
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Yes they do, i updated all of them the other day
- 30 Jun 2017, 11:18
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi,
I replaced your file to the default and ran - but i get the error no data could be returned, i changed the data source to my version 22 just to be sure, i had tried that filter but nothing runs, as soon as i take it out, it works (??)
I replaced your file to the default and ran - but i get the error no data could be returned, i changed the data source to my version 22 just to be sure, i had tried that filter but nothing runs, as soon as i take it out, it works (??)
- 30 Jun 2017, 08:04
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi Bruce, Well i'm not sure why this is an issue but, i was trying to figure out why the data was being displayed an extra 6 times in addition to the single entry i want to see. So, i looked at the report and the only thing i could see that could potentially trigger an extra 6 entries is the address...
- 29 Jun 2017, 12:59
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi Bruce, I found your post http://forum.makingithappen.co.uk/viewtopic.php?t=2334#p7235 which discusses the very issue i'm having relating to the service lines, sadly it looks like it wasn't resolved from the user who raised the query. The templates attached to the post don't open now, i'm guessing...
- 28 Jun 2017, 14:59
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi, yes that default was not setup, i have done that now, ran it again but still getting 7 repeats of the same data line. I took out the communication table join and the report produced the same single service data line over 6 pages :shock: so, i've put that link back in for now. Anything else i can...
- 28 Jun 2017, 12:06
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi, yes i had that in originally but i get the error No Data was returned for this report (?) I took it out and it runs.
- 28 Jun 2017, 09:00
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi Bruce, Well i think I've sorted it. I double checked all the joins, fields etc from your sample to mine and was still getting the wrong results. So, i went and checked the page and group headers and i could see that i didn't have a GDN_NUMBER header or footer. I did have a Page header and footer,...
- 27 Jun 2017, 12:23
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi, and thanks for this - i'm following the advice and working through each field - I followed the advice from sage itself regarding the linking of the SOP_ITEM table and the GDN_ITEM table to the Sales order number. Probably followed that wrong :) So, i am working through the changes and below is w...
- 26 Jun 2017, 11:43
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi Bruce, finally got round to attaching my report template. Hope this is correct?
I have left the suppress duplicates in Details on the stock code and description fields just as an example of the different things i am trying.
Thanks Paul
I have left the suppress duplicates in Details on the stock code and description fields just as an example of the different things i am trying.
Thanks Paul
- 26 Jun 2017, 10:43
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi again,
Just to add - do i need something like a new section for the GDN Item Unique ID ? To limit the data lines being produced maybe ?
Thanks Paul
Just to add - do i need something like a new section for the GDN Item Unique ID ? To limit the data lines being produced maybe ?
Thanks Paul
- 26 Jun 2017, 08:31
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
Hi, thanks for that reply. So, i tried the filter of 7 (you were correct with that- GDN/GRN) in letter type and i was just getting the error of no data could be returned. So, i went back to the joins and removed the link to communication addresses, disabled the criteria GDN_ITEM.GDN_NUMBER and re ra...
- 23 Jun 2017, 15:29
- Forum: Sage 50 Report Designer
- Topic: GDN Report produces multiple pages for a single data line
- Replies: 24
- Views: 14361
Re: GDN Report produces multiple pages for a single data line
I have to shut down now, but I've copied this out very quickly GDN_ITEM.QTY_DESPATCHED <> 0.0 this is within data source properties, I've also included a criteria within GDN_ITEM.GDN_NUMBER In an attempt to just pull one report per GDN at a time, mainly because it was easier than running every recor...