Archive for the ‘Sage 50’ category

Do you have field staff?

March 27th, 2010

Well my first iPhone application has now passed approval and is available on the app store, you can find out more here. This is a great little app for viewing your customers/suppliers/products as well as sales and purchase orders. It will work anywhere, even if you are in an area that doesn’t have wi-fi or 3g. The app is a viewer only but what I am finding now talking to business owners is that they want to equip field/remote sales staff with the ability to enter orders. The iPhone doesn’t lend itself to any volume of data entry but the soon to be released iPad certainly does and this now becomes a viable proposition.

If you have remote workers that perhaps need to be in close contact with your Sage accounting solution then please get in touch to see what your options are.

Mobile Sage and iPhone Development

February 4th, 2010

I have just spent the weekend on a gruelling (but a very rewarding) 3 day iphone development bootcamp, big thanks to the instructor Charles (http://www.perculasoft.com/). My first project is to make available all common Sage information on the iPhone. Essentially the project will comprise of two parts; First a small stand-alone web server gets installed on one of your computers and this handles all the requests as well as paging data so you are not waiting for long for the data and secondly the application on the device itself which will give you access to sales, purchase, stock and nominal information.

If this is something of interest I am looking for beta sites (5 in total) who have a need to deliver their Sage information remotely and who will receive their iphone apps and the server portion completely free. If you want to take part simply contact me via the email link on the About page.

Initially I will target Line 50 but as soon as the first build is complete I will be working with 200 and 500/1000 also.

Sage Explorer and Dashboard

January 20th, 2010

As I get many requests daily for both of the above products (which if you havent grabbed them are free) I do get the occassional problem reported back to me. Either product will work with any version of Sage Line 50 or Sage Instant. The programs work by using the read-only ODBC driver that gets installed along with Sage. Now typically any problems with either program will come down to not being able to find a file called ‘COMPANY’.

This file will reside typically in one of two places. For versions upto 13 (Sage 2007) it will be in

C:\Program Files\Sage\Accounts

For versions 14 and beyond it will typically be in

C:\Documents and Settings\All Users\Application Data\Sage\Accounts\<version> where version will be 2008, 2009, 2010 etc.

Why is this important? Simply because it is the company file which contains the path to where the Sage data files reside. If this file cannot be found you are on to a non-starter.

So if you are having problems look for a .ini file which will be in the same directory as either application. You can open this using notepad and make sure the homedir= value is set to one of the above directories, or if you have a non standard install then try and locate the file and specify the directory where it resides.

One small further note regarding version numbers. Sage decided to drop the old versioning system of numbers (yeah I know it worked fine) and adopted the (daft) Microsoft strategy of using the year of release as the version. So version 13 became Sage 2007, version 14 became Sage 2008 etc etc. So if you are running version 2010 then the version needs to be 16. For the dashboard the installer hasn’t been updated to include this version but again the .ini file has a setting called version= which can simply be set manually.

I hope this helps resolve any issues.

Sage Line 50 for iPhone?

October 11th, 2009

You know I start lots of little projects, some end up as products, others get consigned to the bin. What I have learnt over many many years in business is that now I don’t waste much time on things unless their is a definite market of willing buyers for any prospective project. So as much as an exercise for me to learn iPhone development (and perhaps join the app store goldrush which seems to be taking place!)

I have the bare bones of, for want of a better term, a sage line 50 ‘viewer’ for the iphone. For those technically inclined I have a small php web server which reads data from line 50, packages it as XML which then gets consumed by an application on the iphone. Cool? certainly, commercially viable? unknown at the moment, if you have a few seconds spare I would be grateful if you could complete the poll on the right.

Cost wise I would probably give away the iphone application and charge a nominal fee for the server portion of the solution. In real terms it would enable you or your staff to remotely view Line 50 data (Sales, Purchase, Nominal, Stock and transactions) anywhere they could get wi-fi or a 3g signal.

Sage Line 50 ODBC

October 9th, 2009

I get alot of requests on how to extract data from Sage Line 50. It always revolves around using the supplied ODBC driver which gets installed along with Sage. However I have taken things a step further and developed what I call ‘Sage 50 Explorer’. This is a visual tool which uses the ODBC driver and allows you to query the data in any Sage table, issue SQL against at and, even better, export the data from any table to a comma separated text file or an Excel spreadsheet.

Best of all its, FREE and will be available early next week for download.

epay for Direct Debit Processing

August 4th, 2009

Do you have to process payments that you collect via Direct Debit? Some years ago I developed a program called epay for Sage Line 50. epay will take the direct debit collection file that you receive from your bank, post all the cash for each account in the file and then allocate this cash to either the outstanding amount on the sales ledger account (i.e. try and match multiple invoices) or match against a single invoice. My biggest customer of this software processes 2500 direct debits monthly and it saves them approximately 1.5 days a month of manual labour. The software also provides a full audit trail and exception reports where any errors occur. You can see more in this video here:

Why Sage may never get saas

July 7th, 2009

Dennis Howlett has made an interesting post regarding the rapid release and the subsequent silent demise of Sage’s own Software as a Service (Saas) offering which you can read about in full hereĀ Why Sage may never get saas

Obviously Sage have a large legacy in the Line 50 market with some users having been happy users for years so what do you do to embrace the Internet and provide a SaaS solution? Of course the SaaS players will say the web is the future and all software will go this way. Ardent fans of Line 50 and those concerned about potential security issues still favour the traditional windows approach. The above article mentions lack of R&D funding but my thinking is whilst a product still sells commercially its hard to plough money into a new offering. No more is this evident than in the Sage Line 500/Sage 1000 products. Architecturally and user interface wise it is a disaster. Functionality wise it offers much. Bottom line is both those products still sell into the high end market-space making a radical re-write low down on the list and commercially expensive!

Posted using ShareThis

What happened to SageLive?

June 5th, 2009

Well it seems that the SaaS offering from Sage has met a premature end. Even given the amount of time to develop this and get it right (and perhaps test it?) before launch it seems to have flopped and quietly disappeared. I commented some time ago that my initial experiences of it were poor which were echoed by other users as well. But it seems a big opportunity to miss with the SaaS bandwagon rolling on and now we have SaaS providers all looking to erode the Sage 50 user-base. I have already done one data migration tool for Kashflow and now I am in discussions with another SaaS provider to do the same for them. Suits me, this is a commercial venture after all and not a Sage fan club! They may have massive market share in that sector but unless action is taken there are lots of hungry wolves snapping at their heels.

Dashboard for Sage 50 2009

January 26th, 2009

One of my users pointed out to me that the free dashboard available for download from this site currently only works with versions of Line 50 up to 2008. I have now recompiled the install package so that it will now work with all versions of Sage 50 and Sage Instant up to 2009 (Version 15). The download is available here.

If you are an existing user and you do not want to download it you can simply look for the file Sage50Dashboard.ini (located in the same directory as the dashboard application) and set the line that says ‘Version=’ to read ‘Version=15′ and it will work fine!

Sage Additions

January 26th, 2009

I often get asked if there are add-ons for a specific piece of functionality. Your first port of call should be the Sage additions catalogue. This lists a large number of add-ons in different market sectors and there could be just what you need already available. However finding the catalogue on the Sage website isn’t that straight-forward so here is the link to the PDF.

Sage Additions Catalogue

However there may be products which are not listed in additions so it is always worth googling your requirements!