Is SmartPosting running?

• SmartPosting delays data posting to prevent conflicts between ten or more users on a large network
• If you have Sage 50 on one computer or on a small network, you don't need it
• SmartPosting also takes up an Actian user license, which can cause this error

To deactivate SmartPosting, do the following:

1. Select Maintain, and then select Company Information.
2. In Maintain Company Information, select arrow next to Posting Method.
3. Select Real-time posting.
   • You can instead select Batch posting to post saved changes manually
   • Batch posting is similar to SmartPosting but doesn't require an extra user license
   • Batch posting helps to avoid conflicts between users on small networks
4. Click OK, and then click OK again to close the Maintain Company Information screen.

Is the company data on a local drive?

• For Sage 50 to read your data, you have to save it to the local hard drive of the computer running Sage
• If your data is on a network drive, cloud storage, an external hard drive or thumb drive, move it to your local drive

Do you have other programs that use Actian Zen?

• Sage 50 Accounting uses Actian Zen (formerly known as Pervasive) as its database engine
• If another program also uses Actian, it'll take up a user license and cause this error
• Contact Sage sales at 877-495-9904 to purchase the number of user licenses you need

New network install or increased number of users

• You need to purchase a multi-user license to use Sage 50 on a network
• You’ll need enough user licenses for each user who will log in at the same time
• If you plan to use SmartPosting or other programs that use Actian, these will use extra user licenses
• Contact Sage 50 sales at 877-495-9904 to purchase the number of user licenses you need

Recently purchased more user licenses

When you purchase new user licenses, Sage sales will issue a new serial number for you to use.  You'll need to update the serial number in the program.

1. Find your latest serial number.
2. Open Sage 50 on the server and click Help, then About Sage 50 Accounting.
3. Verify that the correct serial number displays.
   • If the serial number is incorrect, update it.
4. Open Sage 50 on the workstations and click Help, About Sage 50 Accounting.
5. Verify that the serial number on the workstations is the same as on the server.
6. If the serial numbers are different, check the data path on the server.
7. Update the data path on the workstations to match the server.
   • This will also cause the serial number on the workstations to match
8. Test to verify that you no longer receive the error.

If you've verified the serial number and data path, but still get the error

1. Log in to your server as an administrator.
2. Locate your program path.
3. Right-click SageReg.exe, click Run as administrator.
4. Select the Key Status tab.
5. Select the Check Key State button.
6. Make sure the User Count for the Permanent License Type equals the total number of licenses you purchased.
   • There will be one extra license for SmartPosting if you’re using the Quantum edition
7. If this number is incorrect, click the Sage 50 Activation tab, then select the Activate button.
8. Select OK on "Activation Success..." message.
9. Select the Key Status button again and verify the User Count is now correct.
10. Close the Sage 50 Remote Activation window.
11. Test to verify that you no longer receive the error.

Still getting the error after running SageReg.exe

The workstations having the same Computer Name can cause the error.

1. On a workstation, press the Windows key and R key on your keyboard.
2. In the Run window, type sysdm.cpl and click Ok.
3. Note the Full computer name field.
4. Repeat steps 1 through 3 on all workstations.
5. If two or more workstations have the same Computer Name, change the Computer Names to be unique.

Create a clean data folder

If the error is occurring on multiple workstations but not on the server, clean out the company data folder.  Try this before attempting the workaround below.

Workaround for restoring a backup

1. Copy the backup to your Desktop.
2. Right-click the backup and select rename.
3. Change extension of file from .ptb to .zip.
4. Create a new folder in the data path.
   • Give the new folder a name you'll recognize for later
5. Open up the zip file.
6. Extract all files in the zip to the new folder.
7. Open Sage 50 and select File, Open Company.
8. Open the company that includes the new folder you created on its Directory line.
   • If you don't see the new folder, click Browse
   •  TIP: When browsing, select the folder above the new folder, not the new folder itself 

Set a default printer on the server

• On the server, select or install a default printer
• If there’s no printer to select, contact your IT to set up a printer on the computer

Install the latest update

• Install the most recent service release for Sage 50

1. Close Sage 50 on all computers.
2. On the server, press the WINDOWS and R keys.
3. Type services.msc.
4. Click OK.
5. Right-click Pervasive PSQL Workgroup Engine and select Stop.
6. Close Services.
7. Open Computer.
8. Browse to the data path.
9. Open the specific company folder in which the error is occurring, and delete ~PVSW~.LOC.
10. Open the Archives folder for that company.
11. Open each folder located in the company's Archives folder and delete ~PVSW~.LOC.
12. Close Computer.
13. Repeat Steps 2-6, selecting Start after right-clicking Pervasive PSQL Workgroup Engine.
14. Open Sage 50.
15. Open the archived company and verify that the error no longer occurs.