• Transition from TASBooks to Sage 50
    Easy with the Right Partner and Remarkably Beneficial
  • Transition from TASBooks to Sage 50

KB Category: Sage 50 Accounts

Sage 50 Accounts

Download and run the Aged Reconciliation reports (4)

Written by Pimbrook Support on .

Download and run the Aged Reconciliation reports (4)

If the previous steps have not highlighted the discrepancy, it is likely that it is caused by the allocation dates on some transactions.

For example, a PI dated after the report date, has been allocated to a PC with an allocation date prior to the report date. The Aged Reconciliation reports highlight any transactions with allocation problems or links removed.

For a more detailed explanation of link removed transactions, please refer to article 14578.

To download the Aged Reconciliation reports

Sage Accounts v21 and above – Download and restore the Sage Accounts v21 and above – Additional Reports Backup.

Sage 50 Accounts 2014 (v20) and below – Download and restore the Sage 50 Accounts 2014 (v20) and below- Additional Reports Backup.

Sage Instant Accounts 2014 (v20) and below – Download and restore the Sage Instant Accounts 2014 (v20) and below- Additional Reports Backup.

For further information about how to download and restore these, please refer to article 28447.

 

Click here Continue to (5) or  here to go back to Summary

Check for journals posted to the Creditors Control Account nominal code (3)

Written by Pimbrook Support on .

Check for journals posted to the Creditors Control Account nominal code (3)

1. Run the following report:
 Nominal codes > Reports > Day books > Day Books: Nominal Ledger.
Sage Accounts 2014 (v20) and below – Modules > Nominal Ledger > Reports > Day books > Day Books: Nominal Ledger.

2. Enter the following criteria:
 Transaction Date: Between (inclusive) – 01/01/1980 and the last day of the month being reconciled.
 Nominal Code: Is 2100.
2100 is the default code for Creditors Control. You can check this in Settings > Control Accounts.

3. Check the totals for the Debit and Credit columns. If the values are the same, then journals are not the reason for the difference. If the values are different, subtract one from the other to give the difference.

If a journal is posted to the Creditors Control Account, it changes the value on the nominal code. However, the same value is not reflected anywhere in the supplier’s record, and as a result does not affect the aged creditors reports, resulting in the discrepancy.

Under normal circumstances, you should not post journals to the Creditors Control Account. The only time this should happen is when entering and reversing opening balances.

Difference

  •  If there is a difference, you must determine if the journals are correct or not.
  •  If they are correct, no further action is needed and there will always be a difference between the Aged Creditors and the Creditors Control Account because of the journal.
  •  If they are incorrect, the journal could be reversed or a further journal can be posted to move the discrepancy to a different nominal account.

If you are not sure if the journals are correct or not, please refer to your accountant.

No difference

If there is no difference, it means that the journals posted to the control accounts are not causing the discrepancy.

 

Click here Continue to (4) or  here to go back to Summary

Ensure that you run the correct trial balance report with the correct criteria (2)

Written by Pimbrook Support on .

Ensure that you run the correct trial balance report with the correct criteria

You must use the following:

Report
  • Nominal codes > Reports > Trial balance > Period Trial Balance. Criteria
  • Sage Accounts 2014 (v20) and below – Modules > Financials > Reports > Trial balance > Period Trial Balance.
Criteria
  • Period – Choose the month being reconciled.
Figure

The total for the Creditors Control Account.

 

Click here Continue to (3) or  here to go back to Summary

Ensure that you run the correct aged creditors report with the correct criteria (1)

Written by Pimbrook Support on .

Ensure that you run the correct aged creditors report with the correct criteria

Before running the aged creditors report, ensure there is no search applied to the Suppliers list and that no suppliers are selected.

You must run the following report:

Report

  • Suppliers > Reports > Aged creditors > Aged Creditors Analysis (Summary). Criteria

If there are any suppliers with an underscore, or other non-alphanumeric characters, in their account reference, for example, Z_01, the aged creditors report may exclude some suppliers.

Criteria

  • Supplier Ref – Leave as default.
  • Report Date – Enter the last day of the month being reconciled.
  • Inc Future Tran – Clear.
  • Exc Later Payments – Select.

Figure

Click here Continue to (2) or  here to go back to Summary

Check for updates – There are no new updates (Sage 50 V24.2)

Written by Pimbrook Support on .

Error

If you are prompted to check for updates in Sage Accounts v24.2 but no updates are found, you can manually download these updates instead.

 

Solution:

1. Log onto your computer as an administrator and close all software.

2. You can log into our website to download Sage 50 Accounts v24.2, then click Save link as or Save target as.

3. Make a note of the file name, browse to the Windows desktop, then click Save.

4. On the Windows desktop, double-click the downloaded file, then follow the on-screen prompts.

 

The data service cannot be updated because there are xx other users still using Sage Accounts (Sage 50 V24.2)

Written by Pimbrook Support on .

Error – The data service cannot be updated

After updating to Sage 50 Accounts v24.2, the following message appears: – ‘The data service cannot be updated because there are xx other users still using Sage Accounts’

 

Solution

A)Restart the computer where your Sage 50 Accounts data is held

if the reboot is not possible, follow the steps below on the computer that holds the data:

1. Browse to the following location:

  • 64-bit computers: c:\program files(x86)\sage\accountsservicev24
  • 32-bit computers: c:\program files\sage\accountsservicev24

2. Locate and rename the following file: sg50scv_v24.exe changing the .exe file extension to .old

3. Download the following file:

4. If prompted to save the file, note the file name, Sage_50_Accounts V24.2_Dataservice.exe then click Save.
Depending on your web browser, the file may automatically save to your Downloads folder. To view your download folder, press Ctrl + J on your keyboard.

5. Browse to and double-click the downloaded file, then follow the on-screen prompts.

Integration – ‘The Foreign Currency on the account does not match the Foreign Currency on the transaction’

Written by Pimbrook Support on .

If you integrate Sage Job Costing or integration with 3rd parties with Sage Accounts and try to post an invoice to a Sage Accounts customer or supplier account, the following message may appear:

‘The Foreign Currency on the account does not match the Foreign Currency on the transaction.’

This can occur for the following reasons:

  • You tried to post a transaction to a customer or supplier record that has a non-base currency. This is because in Sage Job Costing, there’s no option to use foreign currencies.
  • The base currency in Sage Accounts v23.1 or above is not set to Pound Sterling.
  • Rename the original sg50sdoEngine230.dll in the syswow64 folder to old and Replace the sg50sdoEngine230.dll with the new attached file.

 

Sage 50 System Requirements V24 (2018)

Written by Pimbrook Support on .

This article lists the system requirements for Sage 50cloud Accounts, Sage 50 Accounts, Sage Instant Accounts and Sage Accountants’ Dataset Manager.

As part of our policy of continued product development, we occasionally release updates to make improvements to the software and address any issues we’ve identified. To ensure your software is up to date, from within your software click Help then click Check For Updates.

Storing Sage Accounts data on non Windows operating systems, for example NAS drives, is not tested and therefore not supported. For more information on non-windows operating systems, please refer to article 24287. For more information on using Sage Software on an Apple Mac, please refer to article 15524.

If your version of Sage Accounts isn’t compatible with your computer, you may need to upgrade your software.

Sage Accounts v24

Supported operating systems

All 32-bit or 64-bit variants of the following operating systems:

Please ensure all the latest Microsoft Service Packs and Updates are installed.

  • Windows 10 (except Windows 10S)
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Server 2016 (except  Windows Server 2016 Essentials)
  • Windows Server 2012 (except  Windows Server 2012 Essentials)
  • Windows Server 2012 R2 (except  Windows Server 2012 R2 Essentials)
  • Windows Server 2008 (not supported on Small Business Server/SBS 2008)
  • Windows Server 2008 R2 (not supported on Small Business Server/SBS 2008)

Microsoft Small Business Server (SBS) 2008 and 2011 – due to a small number of customers seeing performance issues we don’t recommend the use of Microsoft Small Business Server (SBS) 2011 or 2008 with Sage Accounts v24. The installation of Sage Accounts v24 on SBS is blocked by default but, if required, you can still install the software by following the steps in article 32387. For further information on SBS 2011, please refer to article 30792 . We do not support any issues you might have using these operating systems.

Sage Accounts is not tested on virtual environments, for example, Hyper-V servers. We therefore can’t guarantee Sage Accounts will install and work correctly on these environments.

For details of using Sage software on an Apple Mac computer, please refer to article 15524.

Hardware requirements

  • 2 GB RAM (4 GB RAM if running a 64-bit operating system).
  • 2GHz processor or higher.
  • 5GB of free disk space.
  • 1Gbps network (100mbps minimum).
  • Screen resolution between 1024 x 768 and 1920 x 1080 – this applies to 4k and hi-res monitors.
  • Maximum DPI setting of 125%

Sage Accounts v24 requires you to install the Sage Data Service on the machine where your data is held. If this isn’t possible, you won’t be able to share your data on that machine. Although not supported, previous versions may have worked as they didn’t use the Sage Data Service. For more information on storing your data on non-Windows operating systems, please refer to article 24287.

Office integration

Some features of Sage 50 Accounts interact with and require an installation of Microsoft Office.

These features include:

  • Emailing invoices and reports
  • Exporting report and screen lists to excel

The information below relates to the use of these features:

  • Office 64-bit versions – In Sage Accounts v24 you can use the File > Microsoft Integration > Contents to Microsoft Excel feature and also run Excel ODBC queries with Office 64-bit. Other features aren’t compatible.
  • Office 365 32-bit – desktop version only

To check if it’s the desktop version, Control Panel > Program > Default Programs > Set your default programs > check if Microsoft Outlook is the desktop version.

  • Office 2016 32-bit edition
  • Office 2013 32-bit edition
  • Office 2010 32-bit edition*
  • Office 2007

Microsoft Office 2007 and 2010 are no longer supported by Microsoft, therefore we’re limited in the support we can offer. We can help with basic steps, however if these don’t work, you should upgrade your software to a more recent version.

* Not compatible with Office 2010 32-bit starter edition

Sage 50cloud Accounts only

Sage 50cloud Accounts offers additional functionality using Office 365. These features require an Microsoft Office 365 Business Premium or Enterprise E1, E3, or E5 subscription.

The section below confirms the requirements for each element of Sage 50cloud Accounts:

Sage 50cloud Intelligence
  • Excel desktop edition 2013 or 2016
  • Excel online
Sage Contact
  • Outlook desktop edition 2013 or 2016
  • Outlook online (accessed via browser)

Sage Contact does not currently support the native mobile applications for mobile devices.

For further information about Microsoft Office compatibility, please refer to article 32017.

Internet Connection

A broadband Internet connection is essential to keep your Sage software up to date, and to take full advantage of features such as Sage Drive and synchronising data with Office 365.

  • Recommended minimum download speed: 4Mbps
  • Recommended minimum upload speed: 2Mbps

Sage 50cloud Accounts only – Sage Intelligence and Sage Contact make use of online features of Microsoft Office 365. For more details of system requirements, please refer to Microsoft Office 365 system requirements.

Antivirus software

To optimise performance your antivirus software should be configured to exclude Sage files from its checking routines. For further information, please refer to article 12122.

Internet browser

Internet Explorer version 11 or above.

Microsoft .NET

Microsoft .NET Framework 4.6 is required.

Mobile apps

Sage 50 Accounts Tracker app

Sage 50 Accounts Tracker is tested on the following operating systems, but may work with earlier versions:

  • iPhone 5s and above running iOS 11 and above.
  • Android 6.0 (Marshmallow) and above.
Sage 50 Accounts Mobile Sales app

Sage 50 Mobile Sales is tested on the following operating systems, but may work with earlier versions:

  • iPad mini 2 or iPad 5th gen and above running iOS 11 and above.
  • Android 6.0 (Marshmallow) and above.
Sage Capture app

Sage Capture is tested on the following operating systems, but may work with earlier versions:

  • iPhone 5 or above running iOS 9.3 or later.
  • Android 5.0 (Lollipop) and above.