Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Categorising customer groups

Sage 50 general help forum - Free help and support for all general issues
Post Reply
jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Categorising customer groups

Post by jimbell » 18 Aug 2015, 06:56

We are running SAGE line 50 2012 version 18 on Windows 7
We have 300+ customers listed & plan to import another 200+ in one go due to an acquisition
We would like to categorise the new additions into 2 groups so we can monitor activities on them over the next year
At the same time we would probably like to divide the existing customer base into 2 groups
Eventually giving us 4 groups
What is the best way to do this please
Any help would be much appreciated! :)

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4631
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Categorising customer groups

Post by brucedenney » 18 Aug 2015, 09:15

There are lots of ways...

The "best" is dependant on a lot of factors

The easiest way to do it would be to use one of the three "Analysis" fields. These are often used to associate customers with regions, sales reps, source, grade, priority, spend and so on.

There are some reports that use them out of the box, the salesmen reporting for example.

You can set the value of these on import, you can also use batch changes to alter them as you go.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

jimbell
User
User
Posts: 32
Joined: 26 May 2012, 08:21
Sage Version: v2012 18 UK/Europe/Africa

Re: Categorising customer groups

Post by jimbell » 19 Aug 2015, 05:42

Perfect - thanks for the advice Bruce
We will go with that

Post Reply

Who is online

Users browsing this forum: No registered users and 11 guests