• Nominal Ledger Activity Data import into Microsoft Power BI

    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…
  • Empty Sage50 database table : Connection with Power Bi/Excel

    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…
  • Practice data

    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
  • How mobile working could help your business

    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…
  • Historic Supplier accounts with nil balance but entries remaining, marked cash

    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…
  • vat return error 8507

    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…
  • Report Filter Expression Based On DATE, But Limited To 12 Months

    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…
  • Are you saving time with automated backups yet?

    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…
  • Sage keeps freezing

    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…
  • Cleaning up the Product file

    Our business has been trading for a few years and the product file needs tidying up. There are lots of duplicates, errors, products that we no longer sell etc. etc. It would seem to me that the easiest way to do this would be to export the product list…
  • Demo / practice data

    Can I copy my live company data to the demo or practive company area in sage? I wish to test a link between a third party software that we use to generate invoices and Sage 50. I would like to test the link practice area to pracitice area but with data…
  • Reinstall problems

    Hi I had a problem during the upgrade from v23 to v24. I was told to uninstall then reinstall Sage 50 accounts to overcome this. I remove all parts of Sage as instructed on your guides and reinstalled my v23 from the disc. It has now come up with…
  • Dispatched Sales Order Report - Line Level

    Hi, Is it possible to create a report which will export the data in the following columns? Order Date / Order Number / Account Ref / Account Name / Product Code / Product Description / Quantity / Price £ / Net £ / Trying to do this without…
  • Sage Accounts 50 not allowing further addition of existing companies to new PC with New 24.2 install

    Hi. I have a new Windows 10 PC for our accounts team to try out before upgrading everyone and I've installed Sage Accounts 50 v24 and upgraded to V24.2. Sage has allowed me to add 9 of the 25 companies, and then refuses to add the rest. Even though…