Sage 50 Smart Posting Error

Sage 50 SmartPosting error occurs when the service isn’t running or has crashed because of issues with program files. Missing and damaged files for SmartPosting are often the primary cause of this error.

But most users are able to fix the error by simply restarting the SmartPosting service from the services.msc menu. If the SmartPosting program isn’t responding when you’re working with Sage 50, then restarting the service is an easy option to fix this problem.

The Sage 50 will work in batch posting mode until SmartPosting is restarted. In this, you will need to post the transaction manually. To do this, go to Tasks>System>Posts. Here you can choose which journals to post. Normally, this is where you will post all the journals.

• SmartPosting cannot be restarted. Because the service of SmartPosting is not running.
• SmartPosting has crashed or hung and cannot be restarted.
• ClosedSmartPosting cannot be stopped.
• ClosedSmartPosting cannot be started because it has an unresolved error exists.
• can’t find ClosedYou state.xml file.

In this post, you’ll learn how to fix Sage 50 smart posting errors.

Possible Causes of Sage 50 SmartPosting Error

• Damaged application files.
• The smart posting service has stopped.
• Damaged or corrupt transactions
• Off-balance transactions
• Anti-virus and firewall can also be a reason.

Solutions for Sage 50 SmartPosting Error

If the SmartPosting isn’t running or responding, then simply starting or restarting the service can fix this error. You may have to fix the SmartPosting error if a certain file for it is damaged. Lastly, you may have to fix database connection issues.

Solution #1: Start the SmartPosting service

You can restart the SmartPosting service if you receive an error while working with Sage 50. The restart option is available from the services.msc file.

Steps to start SmartPosting service:

• Log into the system running SmartPosting.
• Go to the Start menu, and open the Control Panel.
• Choose Administrative Tools.
• Click on Services.
• Double-click on Sage 50 Smartposting.
• Choose Start, then click on Ok.

Steps to restart SmartPosting in Sage 50:

• Go to the File menu in Sage 50.
• Choose SmartPosting Manager.
• Click on Start SmartPosting.

Solution 2: fix the SmartPosting service

This solution can be used if the SmartPosting service isn’t responding to your system. Even when you try to restart the service, the SmartPosting service doesn’t start working.

Use these steps to restart the SmartPosting service using Windows Services Console.

Steps to start SmartPosting service:

• Log into the system running SmartPosting.
• Go to the Start menu, and open the Control Panel.
• Choose Administrative Tools.
• Click on Services.
• Double-click on Sage 50 Smartposting.
• Choose Start, then click on Ok.

Steps to restart SmartPosting in Sage 50:

1. Go to the File menu in Sage 50.
2. Choose SmartPosting Manager.
3. Click on Start SmartPosting.

Use these steps if you cannot restart the SmartPosting service from Windows Services Console.

• Close the SmartPosting process from Task Manager.
  • Press Windows + Shift + Esc to launch the Windows Task Manager.
  • Click on the Processes tab.
  • Choose Show processes from users.
  • Choose the Smartposting(Year).exe from the processes list.
  • Choose End Process and click on Yes to confirm that you want to end the process.
• Close all Sage 50 windows except the main one.
• Choose Tasks, then go to System.
• Click on Post.
• If you receive an error when you post a journal entry, then fix the error.
• Restart Smartposting in Sage 50.
  • Go to the File menu in Sage 50.
  • Choose SmartPosting Manager.
  • Click on Start SmartPosting.

Use these steps only if the above methods failed to restart SmartPosting in Sage 50.

• Close the SmartPosting process from Task Manager.
  • Press Windows + Shift + Esc to launch the Windows Task Manager.
  • Click on the Processes tab.
  • Choose Show processes from users.
  • Choose the Smartposting(Year).exe from the processes list.
  • Choose End Process and click on Yes to confirm that you want to end the process.
• Type Administrative Tools in the Start menu, and hit Enter.
• Choose Services.
• Double-click on the Sage 50 SmartPosting (Year) option.
• In the Smartposting properties dialog, choose the Log On tab.
• Mark the option “Allow service to interact with desktop” under the Local System Account. Then click on Ok.
• Restart your system.
• If any other errors occur, fix them.
• Go back to the Sage 50 SmartPosting Properties dialog.
• In the Log On tab, Unmark the option “Allow service to interact with desktop” under the Local System Account. Then click on Ok.
• Restart your system.
• Restart Smartposting in Sage 50.
  • Go to the File menu in Sage 50.
  • Choose SmartPosting Manager.
  • Click on Start SmartPosting.

Solution 3: Fix database connection errors

Sage 50 SmartPosting crashes if the connection with the database is lost. Because the data required to continue the process isn’t available, the whole process fails and you receive an error. You need to fix database connection errors if you’ve hosted your Sage 50 company file on a separate server.

Use these steps to verify the data path in Sage 50.

• Steps for locating an open company file:
  • Click on Maintain from the main menu.
  • Choose company information.
  • Click on Directory to find the location of your company file.
• Steps to locate a remote data access company.
  • Choose the Systems option from the left panel.
  • Choose Company Maintenance.
  • Note down the location of the company file.
• Steps to locate from the New Company screen:
  • Go to the File option.
  • Choose Open Company.
    Note: all company files will be listed here.
  • Choose Open an existing company file.
  • Note down the location from the Directory column.
• Steps to locate with file search in windows:
  • Open File Explorer.
  • Click on the Search field in the top right corner of the window.
  • Choose All Files and Folders.
  • Input COMPANY.DAT and hit enter.
  • Choose Detail as the view option for windows explorer.
  • Note the location of the company file from the Folder column.
• Steps to locate company files through windows registry.
  • Press Windows + R.
  • Input Regedit and hit enter.
  • From the left panel, browse to HKEY_CURRENT_USER\Software\Peachtree\Version.
  • Expand the key for your version of Sage 50.
  • Choose Open History.
  • Choose the flavor folder beneath the open history option.
  • From the right panel, note down the location of the company file available in the Data column.
  • Close the Registry Editor.
• Steps to locate the data and program paths for Sage 50 company file:
  • Open the File Explorer.
  • Go to C:\ProgramData\Sage\Peachtree.
  • Double click on the Configuration File for Sage 50.
  • Choose Notepad as the program and hit Ok.
  • Find DATAPATH=, and note down the data path of the company file.
  • Find PROGRAMPATH=, and note down the program path of Sage 50.

Use these steps to change network profile settings to enable Sage 50 SmartPosting to easily communicate with the database.

• Go to the Start menu and open the Control Panel.
• Go to Network and Internet Settings.
  • If you’ve set your network as Public, then go to Properties option, and change it to Private.
  • If you’ve set your network to private, then don’t make any changes.
• Go to the Network Profile option, and choose Private.
• Go back and click on Settings.
• Choose Test connectivity.
• Try to open the company file.

Use these steps to reinstall Actian on your system to fix connection issues with Sage 50 SmartPosting.

Steps to uninstall Actian from your server.

• Close all instances of Sage 50 running on your server.
  Note: ask all users to log out before you close Sage 50; otherwise, the changes made to data won’t be stored.
• Press Windows + R and enter AppWiz.cpl in the input box. Hit Enter.
• In the Programs & Features window, right click on Actian PSQL v13 Workgroup R2.
• Choose Uninstall and follow the on-screen instructions to remove Actian from Windows.
• Go to the C Drive and delete the pvswarch and pvsw folders.
• Further, delete the pvsw.log file and PSQL_v[version number os Sage 50]_Install.log file.
• Remove the Pervasive Software folders from Program Files and Program Files (x86) folders.
• Press Windows + R and input regedit, and hit enter.
• Right click on Computer, then choose Export to save a backup of your registry, which may be required later if something doesn’t work properly.
• Browse to HKEY_LOCAL_MACHINE\Software and delete the Pervasive Software and PEYX489ZK.
• Exit Windows Registry Editor.

Steps to reinstall Actian in windows:

• Press Windows + E to launch the File Explorer.
• Go to C:\Sage\Sage50_[version] or the custom location that you chose to install the software in.
• Go to the PervasiveMin folder and launch the SetupGroup32_x82.exe. Then click on Next.
• Accept the terms of service, then click on Next.
• Click on Complete, then Next.
• Choose Install, then Finish after the installation finishes.

Conclusion

Sage 50 SmartPosting error prevents the accounting software from automatically identifying and posting transactions. You can use the solutions in this post to troubleshoot the SmartPosting error and fix it. However, if you cannot fix the error on your own, then you can get in touch with our team of Sage 50 experts.

FAQ