Custom Reports Freezing After 2023 Update Sage 50

Sage is one of the most trusted accounting and finance software used by both large-scale and small-scale businesses. It has grown to be considered one of the most trusted names as it offers a smooth channel for various financial applications to take place. Some of the most remarkable features included keeping a track of income and expenses in various currencies, tracking inventory and managing the invoice. Not, just that, but this software is also suitable for various microbusinesses and freelancers as well who require a piece of better advice on how to maintain a well-organized account.

However, just like all things great, Sage is also not free from errors and glitches. One of the most commonly occurring problems has been the case of Custom Reports Freezing After the 2023 Update. So, what are these problems like and how to rectify them? Let us take a look. 

What the Latest Sage Update 2023 Features

Before we get into the main problem, let us first take a look at some of the main features of the Sage 50 update 2023:

• Efile 1099s Via Aatrix 
• Windows 11 Compatible
• Actian Zen v15.1 Database
• Modernized Help System
• Internet Explorer Dependencies Removed
• Dropped Support for Sage Intelligence Reporting

Read More : How to Fix Sage 50 Hangs on Startup

What are the Symptoms of the Custom Reports Freezing after 2023 Update?

There have been cases of the users reporting certain ‘erratic’ behavior of the software after the update 2023 was conducted.

Some of the commonly occurring signs include:

• The system not responding as well as it is expected to
• Slow and sluggish access to certain data files and folders
• The server growing completely unresponsive altogether
• The recurring of the same problems even after rectifying the issue
• Failed treatments include: reinstallation of Actian Zen, Purge Files for file clean up, the addition of more disk space, reinstallation of Sage, updating of all terminals

How to Resolve the Custom Reports Freezing After 2023 Update?

Here are a few top methods to resolve the issue. However, it is mandatory that one should be able to create the relevant backups and save all their important works before applying any of the below solutions:

Solution 1: The Case of  Damaged Userpref.dat File

Before applying the above solution you must bear in mind this process will cause all the customized screen and preferences back to default. In this case, you will have to reapply for any other options or dashboard changes made by you.

• Go to the company directory
• Start by closing Sage 50 in all systems
• Click on the Windows key + E on the keyboard to launch File Explorer
• Look through the company’s directory
• You need to rename Userpref.DAT to OLDUserpref.DAT
• Close the File Explorer
• Now, once again open Sage 50 and Company
• Finally, the verification of the list loads needs to be conducted.

Solution 2: All Transactions in Large Company

Before you apply the above solution, you need to know that when you open a transaction list Window with a time frame, be sure to set it to ‘All Transactions’. This will allow the program to display all the transactions that have been conducted in the company for that location or area. However, don’t be surprised if this takes a long time, as this greatly depends upon the length of the list. To be more efficient, you can use filter criteria when selecting ‘All transactions’ in the list window. Also selecting small time frames like ‘This Period’ before you close the window. There are chances that this problem can affect one user and not the other.

Now let’s get into how to apply the solution:

• Select Data Range
• Browse the list and select ‘This Period’, ‘This Quarter’ or ‘This Year’
• Verify if the list loads have no issues 
• You are done

Solution 3: Checking the Company Size and the Number of Records

To do so, you need to follow the below steps:

• Click select Help, Support Utilities and File Statistics 
• Browse to the bottom of the list to ‘Grand Total’
• You will have to apply Purge in order to reduce the overall size if it exceeds 300000 KB or more
• Close down File Statistics
• Go to the list that is slow and set up the Date Range to All Transactions
• Let the list load, and allow a few minutes for it to do so
• Finally, check for the number of transactions that have been listed, this is on the bottom left side of screen
• You are done.

Solution 4: The Anti-Virus

• Disable the Anti-virus
• Conduct configuration of the Antivirus so as to avoid scanning your data path
• Program path on server and workstations Sage 50 us
• Now, configure Anti-virus to not scan the C:\Program Files (x86)\Action folder or the C:\Program Files\Action folder.
• You are done

Solution 5: Checking the Damaged Files in the Program Path

• Once again reinstall Sage 50
• Verification of Run list
• Check if it opens up with no problems

Solution 6: Enabling IPv6

• Configure the Windows OS and prefer IPv6 above IPv4

Solution 7: Backup Restoration

There are times when a simple restoration of backup is applicable in case the Maintenance drop-down list is empty.

Solution 8: When the Action Runs as an Auto-Load Instead of as a Service

• Start by closing Sage 50 on all the systems
• Open the Task Manager by clicking on Ctrl+Shift+Esc on your keyboard
• Click Select the Details or Processes tab and locate w3dbsmgr.exe (on 2023.0 and later, zenengnapp.exe
• Right-click on the Process and click on End Task and End Process
• Go to the Service tab, click on Sort by name and locate psqlWGE (on 2023.0 and later, Zen engine)
• Finally right-click on psqlWGE and select Start.
• You are done 

Solution 9: Selected Asterisk Fields

• Go to Settings on the Window list located on top
• Once you have selected a column list, remove any item selected with a (*)
• You are done.
• One must bear in mind that those items with (*) at the end of the name will lead the list to load sluggishly.
• Hence, for each such list, Sage needs to perform an additional database call to extract information.

Also Read : Sage not Responding

Conclusion

So, there you have it, people. These are some of the top-rated solutions when you encounter custom reports freezing after the 2023 update issue. However, if in case you still continue to face issues, be sure to reach live chat out to us and call tollfree we will be more than happy to help you out.

Frequently Asked Questions (FAQs)