Issue with report files not opening in Sage 50 V29, Sage Tech support thought fixed but still error, any suggestions.

I have Sage 50 v27, 28 & 29 on my office Server running Server 2019 essentials, also pulling through to several pcs and laptops, all reports work on the pcs but have an issue on server.  I know that technically we are advised to not install Sage 50 on a server with essentials however until someone comes up with another way for accountant practices to run it in another way since we had to stop holding the data on a NAS drive pulling through to the pcs there is no other option.

I carried out the installation as usual with the individual packages installed in the correct order, I initially had the above error message with no reports available in any dataset, even demodata.  I carried out the whole uninstall, reinstall a few times, repair installation etc then gave up as the reports were pulling over to the pcs fine.  I then went to a client's office and carried out the update on their server, in that case I updated their Sage program as they don't need the older version.  I had more serious issues with their installation so contacted technical support, after managing to get the upgrade installed they found the same report issue so tried numerous fixes.  They finally found that the use data path for reports box was not ticked so changed it and although we still got an error message when opening the program the reports were available.

We thought that fixed the issues as I did it on some of my datasets and it worked, however I have now restored a backup of a Sage dataset for a client that we have moved back from QBO to Sage 50 into the Accounts\23 folder (all the other datasets are in either \21 or \22 folder) and no matter what I try I can not get any reports in the list, even when I open report designer in that company although the folders are shown when you select one, it is blank.  See below:-

I have checked out the program data folders and found a difference in the Company Template folder in Accounts\2023 compared to 2021 & 2022.

Below is screenshot of that folder from 2022

and 2023 only has the below:

I really need to get this sorted out as when we are working remotely we have to work on the server Sage 50 for the non remote access companies and not being able to even run a aged creditors report will be a pain in the butt.

  • 0
    I have checked out the program data folders and found a difference in the Company Template folder in Accounts\2023 compared to 2021 & 2022.

    That is OK and expected as the template was simplified to remove unnecessary folders, or folders that are only used in some circumstances, as this can significantly speed up the creation of new companies.

    They finally found that the use data path for reports box was not ticked so changed it and although we still got an error message when opening the program the reports were available.

    That setting just changes where the reports are loaded from. Essentially it tells the software to use a shared location for the reports rather than the default local one. It is a little slower to do this as you are going out over the network whenever you want to find or access a report, but is useful for when you share reports with other users. I would not expect the setting to have any bearing on your problem except for the fact that if you have upgraded the data you likely had reports in the data location already from the earlier version of the software. However these reports will not be up to date so may be missing some changes/fixes or new reports added in v29.

    I carried out the installation as usual with the individual packages installed in the correct order

    I suspect this is the problem. Installing the individual packages isn't intended as the normal way to install, although it is sometimes used as a workaround for unexpected errors with the normal EXE installer.

    Given the error message you are seeing I strongly suspect that you have installed the client and server MSI files but not installed the "Sage50Accounts_ReportPack.msi" one, or possibly have but installed it out of order. This would result in you having no report files and the error message you see, as when the software opens and you connect to a company a check is made to see if you have the up to date reports in the correct location based on your current settings (local or in the data path) and the latest ones are applied to this location if necessary. It is this step that is failing and giving you the error message as the source report files do not exist.

    Should be a simple fix to just run the "Sage50Accounts_ReportPack.msi" installer file and reopen Accounts.

    Hope that helps

  • 0 in reply to Darron Cockram

    When you install Sage 50 on a server, since version 25 you have no choice except to install the packages individually, this has worked for every versionup to now on every server of mine and my clients.I had ran them in the order that v25 - 28 had to be done then realised that the order had changed for V29 as the new package is now there. Lockstrap or what ever it is called.

    I definitely installed Report Pack, also uninstalled it and reinstalled after installation several times.  Ran repair a couple of times.


    Sage Technical support also checked installation order and uninstalled the program and reinstalled themselves.

    Same issue.

    I have now had to move one of our Remote Access company datasets from the the programdata 2022/company.008 which was in v29 and after Tech support had managed to get reports to open for all those companies over to 2023/company.002.  This dataset now won't even open the reports window, just gets the error message below: -

    I have checked that the box for use datapath for reports is ticked and gone to help/about and made sure that the data directory is correct and clicked through to it.

    I have also opened the other dataset that is in the 2023 data folder to make sure that the report windows are still opening even if the reports are not there, and a couple of the datasets that are still in the 2022 company folders and I can run their reports in v29.

    I am stumped.