Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
When Errors occur in the Sage Database, if these cannot be repaired then the only viable option is to restore to the last valid Backup. However, the users have to first Print out any Data that they have entered into Sage since the last valid Backup and…
Allow ODBC connection or connection via sage report designer to the table that holds the data of reocurring invoices, including frequency, value, start date, invoice item lines etc. This would allow us to audit the reocurring invoices setup in our software…
it would be nice if 3rd party applications hitting a deadlock on Sage Data through SDO, would get an error back stating what data file is locked by which workstation and the date/time of lock creation, instead of just "hanging forever" or until lock is…
I recently ran into a Company Data issue, one instance worked with Remote Data Access in offline mode causing data entries to become out of sync. Once connectivity was restored we used the upload this instance's data in the hopes of keeping live changes…
I have used Sage accounts for more than twenty years. About a week or so ago I was told that Sage would be denying us access to all of our records (hundreds of thousands of items) unless we agreed to start paying them a monthly fee of what started at…
Hi,
We have just migrated to Sage V28 hosted on our server within our head office, we run a business management system written in VB.NET that sits on remote PC's, in days gone by we have periodically copied data from sage into an identical data structure…
To protect your accounts data it's important to run the Check Data option and back up your data on a regular basis. If your Check data shows any errors, you must repair your data before continuing to process.
A dedicated support hub has been added to…
To protect your Sage Accounts data we recommend checking your data and backing up regularly. We've dedicated an area of the Help Centre to this very subject, covering data checking, scheduling backups and much more.
Check it out now >
To protect your accounts data we recommend you run the Check Data option and back up your data on a regular basis. Find out more in the Help Centre where there's a topic dedicated to data protection.
Read more >
Taking data backups doesn't have to be a chore.
You can use the Backup Manager to make regular backups automatically. Meaning no more staying behind to back up, or waiting for others to log out.
Read more
Hi,
I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…
Hi,
I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…
Hello,
My company recently bought a server running windows server 2019 essentials. Can sage data service run on this OS? I would like to host my data on this server. Alternatively Could I run a virtual machine with Windows 10 on the server to host…
Hi everyone!
I've scoured the internet and still can't find an answer to my question.
I use Excel to keep track of large projects and stock levels, as well as how many complete sets I can make of a project.
This also helps me see what is holding…
We suffered some data corruption a couple of weeks ago, we only spotted it on Friday sadly. I have spent the weekend rectifying the situation and at the final stage, re-entering the transactions, I had 17 errors that were not stated on Sage's help page…
hi all,
I would need to ask some help. I need to train a new employee to do sales orders with sage 50. is there any practice section we can use?
thank you in advance
Do you allow your staff to work remotely? Depending on your business, this might be an essential part of the way you work. But beyond sales teams and home workers, some businesses are actively encouraging staff to take up mobile working.
So can working…
I am getting the following error with the Sage Line 50 v23 32-bit Odbc driver:
ERROR [08001] Cannot find all files in data path ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 23.2 ERROR [IM006] [Microsoft][ODBC…
I have several historic Supplier accounts with Nil balances. They have not been deleted when I have archived records because there are still entries on them.
These entries are marked Cash and do not off set each other - often it is just one item. For…
I am trying to send an online VAT return and it has failed the HMRC data check. I have an error code 8507.
I have looked up what this error code covers and I do not see any problems with the details I have entered.
We have never had problems running…
I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…
Taking regular backups is vital when protecting your data against corruption or computer failure. The Sage Accounts Backup Manager was introduced in Sage Accounts v21 so you can schedule backups to run automatically and you don't even need to log everyone…
I've recently ran the upgrade to v22 and most of the workstations in the network are working ok, however our Terminal server when starting sage gives an error that it's unable to talk to the data service on 127.0.0.1 (localhost) however its supposed to…
Hi,
I'm on Sage 50, newest version all updated. Everything is through Sage Drive.
Sage keeps intermittently freezing on my Microsoft Surface (once today, 6 times yesterday). I'll click on something e.g. put a payment through, the box pops up and then…
