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 "