• SAGE50 Premium Slow Performance with New i7 PC with SSD & 16GB RAM

    Hi, I recently upgraded one of my customers from Simply Accounting Pro 2006 to Premium 2017, what was running fast on 2006 is now ultra slow in 2017, sometimes taking close to a minute to create a new customer! I indexed the database which is quite…
  • RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far! I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…
  • Query for job costing across three databases

    I would like to construct an SQL query, which dumps to Excel, an analysis of the job costing for a range of jobs across three different organizations. All have virtually identical structures and naming conventions. There is not a ton of data to grab,…