- November 11, 2022
- Posted by: admin
- Categories: Blog, Sage
The layout determines whether the inaccuracy is right or not in the charts of accounts.
I/O Error When Posting to Sage 50
Description of Error:
When trying to publish sales invoices from ESC 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 ESC 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 system to aid you in locating and correcting these errors.
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.
- In Sage 50, go to Maintain Inventory Items to create a new non-inventory part.
- Go to File → Select Import/Export…
- Select Inventory → Inventory Item List then click Export.
- On the Filters tab, enter the part number you created in the From and To fields of the Item ID.
- Click OK (this will select everything and export it to the default location).
- 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.
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.
- Have all users log out of Peachtree/Sage 50.
- Log into Peachtree/Sage 50 on the computer that houses the database.
- Make a backup of the Peachtree/Sage 50 database.
- Now navigate to the Maintain menu and select Company Information. Make a note of the directory in which your database is being stored.
- Navigate to the directory where your database is stored after closing Peachtree/Sage 50. Go to the C: drive, then the Sage folder, then the Peachtree folder, and then open the Company folder if your directory was “C:SagePeachtreeCompanyfoldername”.
- The name of the folder containing your database should be visible in the Company directory; do not, however, open it. Pick Rename from the context menu when you right-click that folder. Press Enter after finishing the folder name by adding “OLD.”
- Peachtree/Sage 50 will now be opened once more. Click Close if the “Open Existing Company” popup appears.
- Go to the File menu and select Restore.
- Browse to and select the backup of your Sage database made in Step 3. Click Next.
- Choose the option to “Create a new company user with the restored data.” Fields for Company Name and Location ought to be automatically filled in. If not, give this database a company name and then browse to the directory where you want your database to be kept. Choose Next.
- The parameters from the backup that should be restored to this new database can now be chosen. Click Next when you’re finished.
- The Confirmation screen will now appear and request that you confirm the accuracy of the data. Click the Finish button to complete the restore process, and your database will then be restored.
- You’ll be required to log into the database when the restore process is complete. Since this is a duplicate of your original database, use the administrative username and password from that repository.
- Click Connect after opening the ESC Accounting Server. It ought to automatically detect this new database and connect. Note: Select the “Remember this configuration” box and then click Yes if a dialogue asks you to “enable Coastal Computer Corporation to operate with your Sage 50 Software.”
- Ensure that all workstations have their Sage 50 connections verified and are pointed to the new database.
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.