We have mentioned customer analytics before briefly. Still the theory is all well and good but what about actually mining the data and doing something with it. This tool has been under development for about a year and is being fine tuned. It works with any Sage product from Instant right up to Line 500. [...]

Continue reading " Customer Analytics #3 "

Do you want to determine just who your best customers are? The ones that buy most often or spend the most? You see the key to this information is in your accounting system. It is a commonly held belief that a customer relationship management system will generate a return on investment (ROI). Fact is CRM [...]

Continue reading " Customer Analytics #2 "

What is normalisation and why should you care? Normalisation is the removal of duplicate data across tables in database. You wouldn’t store a customers complete details against each purchase order, you would store the customer details in a separate table and link your purchase order table to it via a ‘key’. Now the Sage Line [...]

Continue reading " Normalisation "

I mentioned in my last post about SQL Server reporting services (SSRS) and how you really must consider it not just as an enhancement to Sage reporting but a complete replacement. I have produced many reports that provide detailed cost centre, project costing and time booking reports the likes of which do not even exist [...]

Continue reading " Sage Reporting #2 "

Do you want to easily segment your existing customer base? How about by how often your customers buy, how recently they last bought and how much they spend? This is the essence of ‘Customer Analytics’. If you could provide highly targetted offers into existing your customer base what sort of reponse do you think you [...]

Continue reading " Customer Analytics #1 "

So a common thing I get asked to do is re-coding of supplier codes in the accounts payable ledger, account codes in the general ledger, you get the idea. In fact this is easier to do with the Sage database than alot of systems because it does not enforce any business rules (referential integrity) in [...]

Continue reading " Extract Transform Load "

Are you still using Sage to do all your reporting? Finding it tedious to get the information on the format that you and your users want? Then STOP! Whilst the reports deliver what they say on the tin the format is something akin to old character based UNIX and DOS systems and you have no [...]

Continue reading " Sage Reporting #1 "

So Sage have a new product that has just been announced; Sage Line 1000. Actually it isn’t a new product at all, Line 1000 is simply a ‘bundling’ of two existing products, Sage Line 500 and Sage CRM MME. I say ‘bundled’ because (at the moment) they are two standalone products which while can sit [...]

Continue reading " Sage Line 1000 "