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

hi, i cannot open it

have tried several solutions.

this problem occurred when sage updated.

I'm having a similar issue, last month reconciliation was fine this month report error as above.

Not sure how this has occured or how to solve.

I can open previous reports directly.

Any help would be appreciated

We have been unable to resolve and now keep paper copies of the reconciliations i.e. a "print list" of the allocated items before running the bank reconciliation which fails to complete for reporting.  Sage believes the issue to be with our access permissions settings but our IT cannot resolve this.  We also restored data to new companies a few times, as suggested by Sage, and the report then works the first time it is run afterwards, but the error report returns on the second use, so we abandoned that resolution as it was so temporary.

It is interesting that the report runs the first time but not the 2nd or subsequent times. What this suggests to me is that it works the first time because the PDF fie does not exist and it gets successfully created on the first run. Then on subsequent runs something is stopping the existing PDF file being overwritten and this is causing the error message. Would be worth confirming this is the case by deleting, moving or renaming the existing PDF and trying again.

I don't believe the pdf files are overwritten - a new file name is created each time based on the bank nominal code and date e.g. 4444 2021-12-31 01 would be bank account 4444 and 1st reconciliation on 31/12/21.  The reconciliations are listed under the relevant bank accounts but have not been saved to a .pdf file in the statements folder.

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

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!

May I ask if you have had repeated success with the bank reconciliation reports after effecting this resolution?  It seems very similar to the "fix" we tried but this only worked temporarily and the problem soon returned, and had to be redone again.

Peter, We have just reconcilled several accounts and all appears to have worked correctly. No error reports.