Report designer error

Question

When I try and reconcile the bank, I get the error message "Report Designer was unable to generate the report: Access to the path 'C:\PROGRAMDATA\SAGE\ACCOUNTS\2018\COMPANY.000\ATTACHMENTS\Nominal\1200\Statements\1200 2019-04-03 01.pdf' is denied"

Ian C · Answer

Hi, 
 Thanks for using Sage City. 
 Are you able to browse to that file path and try and open it? 
 Was the PDF open when you tried to access it? 
 If you try with a different windows user does the problem still persist. 
 If this has answered your question please click More > Verify Answer. 
 Regards, 
 Ian 
 Sage UKI

ScottNH · Answer

I have resolved this problem and will post the answer tomorrow.

ScottNH · Answer

Ok so I had this problem too, after uptading to V28. The problem seems to be that the statements folder cannot be written to by sage. I tried granting all the access methods but nothing worked. So this is what had to be done. In this method you will not lose any company specific Report Designer Forms such as Invoices or Statements but they will lose their FAVOURITE status so you will have to relocate them and give them back their 'stars'. (if you have a lot best to write these down before you start) 
 Take two full backups of all files& reports (tick everything box in the backup options) preferably on different media such as a local HDD & a USB. MAKE SURE THERE ARE NO ERRORS. Now goto HELP>ABOUT and note your data file folder path. 
 Now rename your company to xxx OLD by going into SETTINGS>COMPANY PREFERENCES>(Enter Password if required) >NAME Tab. Then OK. Now go to FILE>NEW>COMPANY (enter password if required). You will find 4 pictograms CREATE, CONNECT, RESTORE, DOWNLOAD. Click RESTORE. Now you be offered two boxes. 
 The first will be to browse to your backup file (just taken) The second is for the new folder so if your old folder was C:\Programdata\sage\Accounts\2019 choose a new one (maybe offered already) such as 2022. Now allow the restore to take place. Once restored leave Sage and re start sage. 
 You should now be offered the two companies (one marked OLD) choose the NEW one and check that everything works including reconcilliations of bank accounts without failure reports. 
 Now you may want to delete the OLD company. Personally I would leave it a few days or even weeks to make sure all is well. But if you need the disc space....? 
 Goto FILE>OPEN>COMPANY DATA. This should show you the OLD company and its folder location. Click on the three dots to the LEFT of the box. Click FOLDER LOCATION this will open file explorer. Leave file explorer open and go back to the page you just left. Click the three dots again and choose REMOVE COMPANY. It will warn you that this will not delete the data only the company. Thats fine. THIS MUST BE DONE BEFORE DELETING ANY FOLDERS otherwise you will get errors. 
 Now go back to the file explorer page and delete the old folder (2019 in this example). 
 
 Hope this helps, it worked for me but i'm no expert!

Sage 50 Accounts

Report designer error

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING