The Specified Data Source Could Not Be Found

If when you are running a report or layout in Sage 50 Accounts 2010 from a previous version, you may get the following message:

“The specified data source could not be found. Check that the data source is correctly registered”

If you edit the problem report or layout when the message appears, you will likely either see no variables or tables in the in the variables pane, or in data>Joins, you get the message “Object reference not set to an instance of an object”

All you need to do is reset the data source within the layout or report, you can do this by:

Edit the report or layout>Data>Change Report Data Source>New Data Source>select Sageline50v16>OK>OK

Then File>Save>File>Exit


Instant Payroll with Vista or Windows 7

If you are running Sage instant Payroll with either Windows 7 or Vista, before installing the new tax year updates, you must make sure you are logged onto the current Sage Instant Payroll software as an administrator, otherwise you may encounter problems.  There is more information about this on the Sage website, so if this affects you please search for Ask Sage Article 11921 from their website.


How To – Print Labels with Sage 50 HR 2010

Technical-supportIn Sage 50 HR 2010 you can print employees names and addresses onto labels.  The software includes layouts for the following formats:
Laser A4 Employee Address Labels – 3 across by 7 down
Dot Matrix Employee Address Labels – 3 across by 8 down
These layouts can be amended to fit specific label stationary.

1. Employee Module / Tasks Pane / Employee Reports
(to print labels for certain employees, select the required employees before selecting “Employee Reports”)

2. Select the required label layout, for example, Employee Address Labels (laser A4) / Print (if required, enter criteria) / OK

3. From the Print Employee Address Labels window, choose the correct printer / enter the required number of copies / OK
(if you are starting part way through a page of labels, click Label Settings, you can select where on the sheet to start from here)


Chart of Accounts in Sage 50

Here is a short video giving a brief overview of how to configure the chart of accounts in Sage 50 Accounts.


Sage 50 2010 – Recurring Entries in Bank Module

Technical-supportA small issue has been identified in Sage 50 Accounts 2010 within a subset of recurring entries in the Bank module.  This is isolated to a small number of customers who have upgraded to Sage 50 Accounts 2010 who are using bank recurring entries and does not affect new customers.

Who does it affect?

Only customers upgrading from a previous version of Sage Accounts to Sage 50 Accounts 2010 will be affected. New customers installing for the first time will not be affected.

What you need to do

For new customers, it is business as usual however we are advising existing customers not to install their upgrade until the update is available.  In the meantime, do not use the recurring entries in the Bank module however, you can continue to process any other transactions.

A fix should be available shortly and Sage will be in touch to let you know as soon as this is ready.

What Sage is doing

Currently working on an update to fix the issue which will be made available via the auto-update service soon. Customers are being advised not to upgrade until this is available. Sage will be contacting customers directly to advise them of the issue.

How to get the update as soon as possible

In order to guarantee that you receive any automatic updates as soon as they become available take the following action: 

  • Within Sage Accounts, click Tools > Internet Options > Software Updates, ensure the following option is selected:Check for Sage software updates but ask me whether I want to download and install them [Recommended]By selecting this option Sage Accounts will automatically check for any new updates every 7 days. To override this and check for updates at any time, click Help > Check For Updates. 

     


Sage 50 Accounts – Error 42S22 in Reports

If you run reports and or layouts and get the message “Error 42S22 Column Not Found”, there are probably issues with the variables or section filters in the reports.Technical-support

This issue is quite easily rectified, please follow the instructions below:

1. Attempt to edit the report / View Menu / Preview / then click OK when the error message appears.
2. Error List pane / select the first error, then:
If the cause of the error is a variable, that variable is selected on the design window. Click the variable / click on Delete / then replace the variable if required.
If the cause is a section filter, nothing is selected in the design window. Double click the error to open up the Expression Editor window, amend or remove the filter as required then click OK
3. Make sure that you save the document with a new description and file name.
4. Run the report again, you should find that it will run without any problems.