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

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 ?

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...

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 ...

Yes they do, i updated all of them the other day

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 (??)

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...

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...

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...

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.

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,...

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...

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

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

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...

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...