Have you had any other problems with your computer recently?

For example, computer crashes, virus infection or loss of network connection.

NOTE:Computer or software crashes may be presented as software freezing and a message to end the program.

Yesnull;null;wiz_local1ayes,wiz_local1a Nonull;null;wiz_local1,wiz_local1a Restartnull;null;wiz1,wiz_local1a

If you have had problems with the computer, this may be contributing to the problems you are experiencing with your Sage data.

We recommend that you install Sage Accounts on a different computer until you are confident that the issues are resolved.

Nextnull;null;wiz_local1,wiz_local1ayes Backnull;null;wiz_local1a,wiz_local1ayes Restartnull;null;wiz1,wiz_local1ayes

Check that the computer meets the recommended system requirements and that you're using the latest build of the software

• For further information about the system requirements and how to check them. Read more >
  
  

  NOTE:If you use Remote Data Access, ensure you meet the system requirements for Internet speed using a wired connection on all computers that access your data through Remote Data Access.

• For a list of every version and how to make sure you are using the latest build. Read more >

Nextnull;null;wiz_local2,wiz_local1 Backnull;null;wiz_local1a,wiz_local1 Restartnull;null;wiz1,wiz_local1

Check that the amount of data is not excessive

NOTE:There is no numerical limit to the number of transactions or records that may be recorded in Sage Accounts. The capacity of Sage Accounts is only limited by the amount of disk space available. The following numbers are for guidance only and they do not represent the limit of data within Sage Accounts. We cannot give a specific limit as this depends on several factors including data size, network speed, number of concurrent users etc. For example, these numbers may be perfectly reasonable for a 2 user version of Sage Accounts running on a high specification network.

As a rough guide we recommend that to optimise performance you have:

• Fewer than 250,000 transactions
• Fewer than 50,000 invoices
• Fewer than 50,000 sales orders
• Fewer than 50,000 purchase orders
• Fewer than 5,000 customer records
• Fewer than 5,000 supplier records
• Fewer than 20,000 product records
• Fewer than 2,000 project records

To check these, open the Help menu, and choose About. The number of records appears in the Data Information section.

If you have more than the recommended number of transactions or records, we recommend that you reduce the numbers to fewer than those specified above. For further information about reducing the number of records, please refer to the following articles:

• The Clear Audit Trail option
• Invoicing and SOP - To delete invoice, credit notes or sales orders
• How to delete or reverse a purchase order
• How to delete customer and supplier records and manage lists

Nextnull;null;wiz_local3,wiz_local2 Backnull;null;wiz_local1,wiz_local2 Restartnull;null;wiz1,wiz_local2

Do you integrate Sage Accounts with any third party software or automated backup software?

Third party software uses Sage Data Objects (SDO) to write data into Sage Accounts. SDO does not have any form of validation to prevent incorrect postings, for example, a sales invoice posted to the Purchase Tax Control Account nominal code. Such entries will cause data corruption in Sage Accounts.

To check if third party software is used null;null;wiz_local3a

If you use software which automatically backs up the data you should ensure this is not ran whilst users are processing in sage as this may lock the files as it is backing up. Please refer to your wiz_local IT support to adjust the backup settings.

If third party integration is not activated and you don't use automated backup software, click Next.

If third party integration is activated, you must contact the third party software provider to confirm that it is fully compatible and tested with your version of Sage Accounts. If it is confirmed as compatible and tested, we recommend that you take a backup and check your data prior to posting anything from your third party software. You should then check your data again after posting to make sure that this hasn't caused any errors.

Nextnull;null;wiz_local4,wiz_local3 Backnull;null;wiz_local2,wiz_local3 Restartnull;null;wiz1,wiz_local3

Uninstall and reinstall the software

There may be a problem with one of the Sage Accounts files. You should take a backup, uninstall and reinstall Sage Accounts then restore the backup.

Nextnull;null;wiz_local5,wiz_local4 Backnull;null;wiz_local3,wiz_local4 Restartnull;null;wiz1,wiz_local4

Configure the antivirus software

One of the more common causes of corruption in Sage Accounts is a conflict with antivirus software. If your computer is running antivirus software, you must configure this so it doesn't conflict with Sage Accounts. Read more >

Backnull;null;wiz_local4,wiz_local5 Restartnull;null;wiz1,wiz_local5

Do you logon to multiple computers using the same username?

Yesnull;null;wiz_nw1a_1,wiz_nw1a Nonull;null;wiz_nw1a_2,wiz_nw1a Restartnull;null;wiz1,wiz_nw1a

If you logon to more than one computer with the same username, you get the message:

'This username is already in use. Do you want to remove this user from the request list and logon again?'

If you choose to remove the user form the request list when this user is still logged in on another computer, this may cause corruption.

To avoid this, before continuing to process on other computers, ensure you close Sage and logon again.

Nextnull;null;wiz_nw1a_2,wiz_nw1a_1 Backnull;null;wiz_nw1a,wiz_nw1a_1 Restartnull;null;wiz1,wiz_nw1a_1

Have you had any other problems with any of your computers recently, including your server?

For example, computer crashes, virus infection or loss of network connection.

NOTE:Computer or software crashes may be presented as software freezing and a message to end the program.

Yesnull;null;wiz_nw1ayes,wiz_nw1a_2 Nonull;null;wiz_nw1,wiz_nw1a_2 Restartnull;null;wiz1,wiz_nw1a_2

If you have had problems with any computers, this may be contributing to the problems you are experiencing with your Sage data.

We would recommend that you stop using Sage Accounts on these computers until you are confident that the issues are resolved.

Nextnull;null;wiz_nw1,wiz_nw1ayes Backnull;null;wiz_nw1a_2,wiz_nw1ayes Restartnull;null;wiz1,wiz_nw1ayes

Check that every computer meets the recommended system requirements and has the latest build of the software installed

You must check this on every computer that uses Sage Accounts.

• For further information about the system requirements and how to check them. Read more >
  
  

  NOTE:If you use Remote Data Access, ensure you meet the system requirements for internet speed using a wired connection on all computers that access your data through Remote Data Access.

• For a list of every version and how to make sure you are using the latest build. Read more >

Nextnull;null;wiz_nw2a,wiz_nw1 Backnull;null;wiz_nw1a_2,wiz_nw1 Restartnull;null;wiz1,wiz_nw1

Check that the amount of data is not excessive

NOTE:There is no numerical limit to the number of transactions or records that may be recorded in Sage Accounts. The capacity of Sage Accounts is only limited by the amount of disk space available. The following numbers are for guidance only and they do not represent the limit of data within Sage Accounts. We cannot give a specific limit as this depends on several factors including data size, network speed, number of concurrent users etc. For example, these numbers may be perfectly reasonable for a 2 user version of Sage Accounts running on a high specification network.

As a rough guide we recommend that to optimise performance you have:

• Fewer than 250,000 transactions
• Fewer than 50,000 invoices
• Fewer than 50,000 sales orders
• Fewer than 50,000 purchase orders
• Fewer than 5,000 customer records
• Fewer than 5,000 supplier records
• Fewer than 20,000 product records
• Fewer than 2,000 project records

To check these, open the Help menu, and choose About. The number of records appears in the Data Information section.

If you have more than the recommended number of transactions or records, we recommend that you reduce the numbers to fewer than those specified above. For further information about reducing the number of records, please refer to the following articles:

• The Clear Audit Trail option
• Invoicing and SOP - To delete invoice, credit notes or sales orders
• How to delete or reverse a purchase order
• How to delete customer and supplier records and manage lists

Nextnull;null;wiz_nw2,wiz_nw2a Backnull;null;wiz_nw1,wiz_nw2a Restartnull;null;wiz1,wiz_nw2a

Test the network transfer speed outside of Sage Accounts

To do this, you must copy the Reports folder from the client computer to the root of the shared folder on the server computer and time how long it takes to complete.

TIP:The standard location for the Reports folder is:

v27	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2021\Company.000
v26	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2020\Company.000
v25	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2019\Company.000
v24	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2018\Company.000

1. On the client computer, open Sage Accounts.
2. Help > About > in the Program Details area, make a note of the Data Directory.
3. Open Windows Explorer > browse to the Reports folder > right-click the folder > Copy.

   NOTE:Ensure the folder is not empty.

4. Browse to the route of the local disk on the server > Edit > Paste.
5. Time how long it takes to complete the process.
6. Repeat steps 4 and 5 two more times and calculate the average time taken.

   NOTE:Because the first transfer should take longer, you must only use the average of the second and third file transfers.

On a network which runs at 100 Mbps, the folder should transfer in 30 - 40 seconds. On a network which runs at 1 Gbps, the folder should transfer in 15 - 20 seconds.

You should now repeat the process to time how long it takes to copy the file from the server back to the client computer.

If copying the file in either direction takes longer than 80 seconds on a 100 Mbps network or 40 seconds on a 1 Gbps network, the network speed may have an adverse effect on Sage Accounts. Until the network transfer speed improves, Sage Accounts will continue to run slowly which may be causing the problems with the data. Unfortunately, we are unable to provide any further advice about what may be causing this and how to resolve it. We recommend that you refer to your network administrator for further advice.

If the network transfer speed is OK, click Next.

Nextnull;null;wiz_nw3,wiz_nw2 Backnull;null;wiz1,wiz_nw2 Restartnull;null;wiz1,wiz_nw2

Move the data to a new location and ensure that Sage Accounts is using a UNC path

Move the data to a new location null;null;wiz_nw3a,wiz_nw3 Ensure that Sage Accounts uses a UNC path to access the data null;null;wiz_nw3b,wiz_nw3

Backnull;null;wiz_nw2,wiz_nw3 Restartnull;null;wiz1,wiz_nw3

1. Create a new folder on your server > share the folder and ensure that all relevant users have Modify permissions allowed.
2. Browse to the existing Sage Accounts data directory on your server.
   

   TIP:To check the data directory, open Sage Accounts > Help > About > the data directory is shown in the Program Details area.

   Copy the following folders:

   NOTE:Depending on your version, some of these folders may not exist.

   • Accdata
   • Archives
   • Attachments
   • Bitmap
   • Configs
   • Criteria
   • Defaults
   • Exports
   • Fax
   • HMRCSubmissions
   • Imports
   • Invoices
   • Journals
   • Labels
   • Layouts
   • Letters
   • Memo
   • Reports
   • Taskopt
   • Template
   • TMail
   • VATRtns
3. Paste these folders into the new folder created in step 1.

If the problem persists, click Next.

Nextnull;null;wiz_nw4,wiz_nw3 Backnull;null;wiz_nw3,wiz_nw2 Restartnull;null;wiz1,wiz_nw3

You must do this on every client computer that accesses Sage Accounts.

1. Browse to the Company file:
   

   v27	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2021
   v26	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2020
   v25	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2019
   v24	Windows 10, 8, 7	C:\Program Data\Sage\Accounts\2018

2. Double-click the Company file > Open with Notepad.
3. Change the paths in the Company file to point to the new data location on the server. You must enter the relevant UNC path for this. For example, if your server is called Server and your shared folder is called Sagedata, the UNC path is \\Server\Sagedata
4. File > Save > File > Exit.

If the problem persists, click Next.

Nextnull;null;wiz_nw4,wiz_nw3 Backnull;null;wiz_nw3,wiz_nw2 Restartnull;null;wiz1,wiz_nw3

Do you integrate Sage Accounts with any third party software or automated backup software?

Third party software uses Sage Data Objects (SDO) to write data into Sage Accounts. SDO does not have any form of validation to prevent incorrect postings, for example, a sales invoice posted to the Purchase Tax Control Account nominal code. Such entries will cause data corruption in Sage Accounts.

To check if third party software is used null;null;wiz_nw4a

If you use software which automatically backs up the data you should ensure this is not ran whilst users are processing in sage as this may lock the files as it is backing up. Please refer to your local IT support to adjust the backup settings.

If third party integration is not activated and you don't use automated backup software, click Next.

If third party integration is activated, you must contact the third party software provider to confirm that it is fully compatible and tested with your version of Sage Accounts. If it is confirmed as compatible and tested, we recommend that you take a backup and check your data prior to posting anything from your third party software. You should then check your data again after posting to make sure that this hasn't caused any errors.

Nextnull;null;wiz_nw5,wiz_nw4 Backnull;null;wiz_nw3,wiz_nw4 Restartnull;null;wiz1,wiz_nw4

One of the more common causes of corruption in Sage Accounts is a conflict with antivirus software. If your computers are running antivirus software, you must configure this on every computer so it doesn't conflict with Sage Accounts. Read more >

 

Backnull;null;wiz_nw4,wiz_nw5 Restartnull;null;wiz1,wiz_nw5