Sage 50 Nominal Reports

Sage 50 Nominal Reports

Didn't find your answer?

Please help, I'm near the end of my tether!

I have been running nominal departmental analysis reports in Sage 50 for as long as I can remember, and exporting them as .csv files without a problem. Today I have ran these reports and for some reason they keep on duplicating the last transaction on the .csv file for each nominal code. It's fine when I run the data for one nominal code, there's only one duplication to remove, but when I run it for multiple nominal codes I'm getting frustrated at having to delete multiple duplications! The duplications only occur when the data is exported - the preview and pdf prints show everything just fine.

I've noticed that the Report Browser screen has changed on my machine lately, but not on that of any of my team. When I say it's changed, it looks as if it's something you would have found on a basic, old version of the software. There's not the generic Sage 'look' to it. I don't know if this would be relevant to my problem (a bug perhaps??). Apologies if this is a bit vague, it's been a very long and frustrating day.....

Thank you so, so much in advance of any help that might just stop me going crazy!

Replies (5)

Please login or register to join the discussion.

By Moonbeam
16th Apr 2013 18:26

Sage Reports are the pits

I regularly have to delete duplicate lines on reports from Sage. Yes there are lots of bugs in them. These are reports I've been using trouble free for years, but over the last few years I've been getting duplication problems. I assume it's because they haven't been properly updated when the program has been updated.

Thanks (1)
avatar
By rhodders
17th Apr 2013 09:18

Thanks Moonbeam - do you know if there is any way that this can be resolved? Or would it involve the costly support package from Sage? Seems somewhat ridiculous that this report function (which I imagine is quite commonly used) is producing errors that are this significant!

I was wondering last night as well, do you think it's possibly a compatibility error with Sage Payroll RTI edition? We're using v17.0 odf Sage accounts and v19.0 of payroll.....

Thanks (0)
By Moonbeam
17th Apr 2013 09:29

I have the Costly Support!

I have given up asking Sage to help me with the bugs that have appeared in the reports. That's because I don't use them that often and because there isn't much data I can delete the extra lines by eye. Sage could probably help me sort the problems out, but I would spend more time than I would like asking them for help.

Thanks (0)
avatar
By DerekChaplin
17th Apr 2013 16:46

Excel 2007 onwards

If you are using Excel 2007 or 2010, can you not just use the "Remove Duplicates" function in Excel?

Only got 2003 at work so can't remember where to find this, but I'm sure it is there somewhere. Probably on the Data tab of the work ribbon at the top - or you could search the Excel help files for "Remove Duplicates"

This obviously doesn't stop the problem from happening in the first place!

You could try editing the report and saving with a different name. It may be that someone else has been in and edited the report, and done something to it which is not obvious, but needs sorting. Do you have an old backup of the report you could restore?

Thanks (0)
avatar
By russdickinson
30th Oct 2014 11:47

Bump - Excel is your friend here

Had the same recurring problem as rhodders, but Excel 2007 has the fix.

I've just exported a VAT detail file from Sage for a quarter, created a pivot from the data and it didn't agree to the VAT summary report - despite the fact it comes form the same data!

It was down to duplicate lines on the export.  

To get rid of them easily, I selected all of the data (including the headers) then went to Data - Remove Duplicates.  Making sure all the header boxes are ticked, Excel then searched and found 38 duplicates, removed them and my pivot now agrees :-D

Much better than going through Sage support!

BTW This isn't a report that I had edited in any way - this is the bog standard sage report that exports to a csv with duplicate lines, tut tut Sage.

Thanks (0)