Sage 50 Cannot Create Report – Please close some reports and try again

Unable To Create Reports in Sage 50

The management of reports is crucial in Sage 50, and the report center serves as a vital component in this process. Various reports are available to provide a clear view of essential details, which are categorized as Vendors & Purchases, Financials, Projects, Banking, Financial, Profit and Loss, Tax, and so on. However, there are instances where errors occur while opening reports in Sage 50, such as the inability to create a report. This article provides a comprehensive guide on resolving the issue of why Sage cannot create reports.

Causes Behind “Sage 50 Cannot Create Report. Please Close Some Reports and Try Again” Warning

Why Does the Error: “Cannot Create Report. Please Close Some Reports and Try Again” Happen on the Screen?
Here is the list of causes for the Sage 50 failure to generate a report:

1. Corrupted printer driver
2. When Email Writer is set as the Windows default printer
3. The logged-in user failed to have desired admin rights to the program path

Find and follow Step-by-step instructions for Sage 50 Excel Integration to generate reports anytime you want just from select and export in CSV and .XLS format easily.

How to Resolve the Sage 50 Won’t Generate Report Error?

Here is the list of methods to fix the failed-to-create report issue:

Method 1: Sage 50 E-mail Writer is set as the default printer in Windows

In Windows, the email writer should be set as the default printer, check the email writer settings. Follow the below steps:

1. Open the Control Panel
2. Choose the Device & Printers option
3. In case the Email writer in Sage 50 is set as the default printer then right-click on a printer
4. Now choose Set as Default Printer
5. Verify that you can print a report

What types of option user have whenever Sage 50 Can’t Export Excel issue comes during generating reports on Sage 50 Pro, Premium, quantum accounting.

Method 2: Check DDF Files and Permission

1. Find the desired company folder
2. Now locate the cosess.dat, *.ddf, and *.ptr.
3. Delete them

Method 3: Sage 50 Network Check

1. Open the folder named data path
2. Now locate the specific company folder and right-click on it
3. Choose Properties tab
4. Click on the tab named Security
5. Hit Advanced option
6. Choose the tab labeled permissions
7. Place a mark on the option Replace all child object permissions with object inheritable permissions using the data path folder

Method 4: Create a New Data Location in Sage 50

Follow the below steps to generate a data path in the same location:

1. Close Sage 50 on all computers.
2. On the computer hosting the data, press Windows Key + R.
3. Type services.msc, then click OK.
4. Right-click and stop these services if listed:
   • Peachtree SmartPosting ####
   • Sage 50 SmartPosting ####
   • Actian PSQL Workgroup Engine
5. Open the data path folder on the computer.
6. Rename the data path directory to OLDDATA.
7. Open Peachtree###.ini File.
8. Update the Datapath=line with the new directory name from Step 6.
9. Download and install the Database Repair Utility for your Sage 50 version.
10. If prompted, select Run instead of Save.
11. When the utility opens, click Yes to continue.
12. Accept the agreement by clicking Agree.
13. Click Create New Local Datapath.
    Important: In multi-user setups, ensure Sage 50 is closed on all computers before proceeding.
14. Click OK.
15. Enter the original data path from Step 5 in the New Datapath field.
16. Click OK.
17. Confirm the utility completes the process successfully.
18. Close the Database Repair Utility.
19. Open the OLDDATA folder.
20. Copy these directories and paste them into the new data path created by the utility:
    • Forms
    • Sample
    • Company directories
21. If asked to merge directories, select Yes.
22. If asked to overwrite files, choose Skip and check the box to apply the action to all conflicts.
23. Restart the computer.
24. If a restart is not possible, open Task Manager, end zenengnsvc32.exe, and restart the Actian service.
25. Open Sage 50.
26. If Sage 50 does not start activation automatically:
27. Go to Help > Sage 50 Activation, Licensing, and Subscription Options.
28. Follow the steps to activate.
29. Open the File menu and select Open Company.
30. Verify that company files appear and open without errors.

Method 5: Run Sage 50 as Administrator

1. Right-click the Sage product icon on the desktop.
2. Select Run as administrator.

In the End!

Hopefully, the “Sage 50 cannot create report” error will be resolved with the guide. In a situation, if the issue does not resolve or you feel there might be other causes associated with the error then talk to experts. The team will help you to give correct answers to all your queries. Use a Sage 50 Live Chat, phone number, or email address to opt for assistance. Stay connected to keep the doubts away!

Frequently Asked Questions