Sage 50 Posting to I/O Error | +1-866-973-9785

Description of Error:

When trying to publish sales invoices from Powerbookllc to Sage 50 or Peachtree, the following problem is seen:

There was an I/O error in the data file. import is stopped.

Cause of the Error:

The incapacity of Sage 50 Peachtree to read or write data to its database tables is evident from an analysis of I/O problems from the Sage Peachtree Accounting Community as well as other web resources. It’s critical to realise that any I/O difficulties encountered when posting from Powerbookllc are solely attributable to issues with the Sage 50/Peachtree database.

Even if your Sage 50 or Peachtree databases are not connected with other services like Electronic Service Control, this problem frequently arises. Sadly, we have discovered Sage Support to be a bunch of jerks who won’t assist you in fixing it. We have therefore created a method to aid you in locating and correcting these problems.

Test the Database:

The I/O issue is typically caused by a corrupted Inventory database in Sage 50, according to our experience. Here is a quick test to see if imports into that table function correctly.

1. Create a new non-inventory part in Sage 50 by going to Maintain → Inventory Items
2. Go to File → Select Import/Export…
3. Select Inventory → Inventory Item List then click Export.
4. On the Filters tab, enter the part number you created in the From and To fields of the Item ID.
5. Click OK (this will select everything and export it to the default location).
6. Now click Import and select OK. This will import everything we just exported.

If the file imported without a hitch, a faulty sector on the hard disc where your database is kept may be to blame for the I/O issue. Because of this, you might have noticed the I/O error in applications other than Sage 50 and Peachtree. If so, please speak with your IT specialist as soon as you can to resolve this problem because it could result in data loss.

Resolution:

Your Peachtree/Sage 50 database may be corrupt if the file could not be imported, but don’t become alarmed. We’ll get you back up and running with a fresh, working database in just a few simple steps, and you won’t lose any data in the process!

1. Have all users log out of Peachtree/Sage 50.
2. Log into Peachtree/Sage 50 on the computer that houses the database.
3. Make a backup of the Peachtree/Sage 50 database.
4. Now navigate to the Maintain menu and select Company Information. Make a note of the directory in which your database is being stored.
5. Close Peachtree/Sage 50 and then navigate to the directory in which your database is being housed. If your directory read “C:\Sage\Peachtree\Company\foldername”, then navigate to the C: drive, then the Sage folder, then the Peachtree folder and finally open the Company folder.
6. In the Company directory, you should see the folder name that contains your database, but do not open that folder. Instead, right-click on that folder and select Rename. Add “OLD” to the end of the folder name and hit Enter.
7. You will now re-open Peachtree/Sage 50. If the ‘Open Existing Company’ screen appears, click Close.
8. Go to the File menu and select Restore.
9. Browse to and select the backup of your Sage database made in Step 3. Click Next.
10. Select the “Create a new company user the restored data” option. The Company Name and Location fields should be filled in automatically. If they are not, enter a Company Name for this database and then Browse to the directory in which you want your database to be stored. Click Next.
11. You may now select what options from the backup are to be restored to this new database. When you’re finished, click Next.
12. The Confirmation screen will now be displayed and ask you to verify that the information is correct. To finalize the restore process, click the Finish button and your database will be restored.
13. Once the restore is finished, you will be prompted to log into the database. Use the administrative name and password from your original database – afterall, this is an identical copy.
14. Now open the Powerbookllc Accounting Server and click Connect. It should recognize this new database and connect automatically. Note: Should a message appear asking if you want to “allow Coastal Computer Corporation to run with your Sage 50 Software”, select the “Remember this setting” box and then click Yes.
15. Be sure to check the Sage 50 connection on all workstations to make sure they are pointing to the new database.

Additional Information:

When our customers try to contact Sage Support, they frequently run into problems getting the help they need because all problems are attributed to third-party integrations (even if the same problems equally affect Peachtree/Sage 50 databases that aren’t connected to any other software). If Sage is needed, please refer to the Import test you completed after reading this post. They will be informed that there is a problem with the database itself because the test does not rely on, use, or effect any integrations.