Lets face it the telesales module in Line 500 is pretty cumbersome (28 pages of system key configuration for a start!) and doesn’t lend itself too well to quickly entering price/quantity discount breaks. I have developed an add-on which is massively quicker to update multiple products across multiple warehouses and allows you to set up [...]

Continue reading " Telesales Matrix Pricing "

Something I get asked is what do you do with analytics beyond the basic scoring?
Well one thing you can do is to take two or more metrics and do a joint measure. This gives you a way to further narrow down your customer base. If we look at something used in analytics marketing called a [...]

Continue reading " Customer Analytics #4 "

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 "

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 "