Topic

Messages

Job Numbering in C&P: The Horror of Exceeding 1000 Jobs

Has anyone found an effective way to combat the way C&P numbers jobs after you exceed 1,000 jobs?

For those who haven't reached that number of jobs yet in C&P, when C&P numbers jobs, jobs numbered 1000--1009 appear between 100 and 101, 1010--1019 appear between 101 and 102, jobs 1020--1029 appear between 102 and 103, etc. This is AFTER you choose to sort your jobs in numerical order. Hence, if you have a lot of jobs open from the beginning of the year, your

We still have lots of jobs open from the beginning of the year that are on-going projects. Job look-ups are a pain. It also renders the job log report pretty useless.

Alex Luken Traffic Manager
"You can only go half way into the darkest forest, and then you are coming out the other side."
Marketing

We ran into the same problem about 7 months ago. You didn't mention how your job #s are formatted. We used to use yr-client code-job # Since then, we changed the preferences to exclude the dashes.

User

You have more than 1000 jobs per client? If not, break them up by client. Say you have Ford and Pontiac for clients. F03-001 for Ford, 2003 and their first job then P03-001 for Pontiac, and so on.

Jim Kennedy Brokaw Inc.
"What we need are a couple of good hangings" - FTC Chairman Orson Swindle, regarding email spam

Alex -

I believe C&P has a maximum of 10 "characters" to be used in a job number. You can change your format to accommodate that. Any "horror" jobs you have opened already, you can renumber them to the new format. (Utilities, re-number)

Diane Smith Business Manager Donaldson Makoski Inc.

We give all our clients three letter codes followed by a job number. The three letters roughly correspond with the client's name. So MetLife is MET and the job numbers are MET-1001, MET 1002, etc. Haven't had any problems reporting this way.

Madelyne Kirch

We number jobs sequentially one after the other using System numbering. Have never had a problem - are in the 5,000's

What numbering method do you use?

-- Cynthia Hobbs Business Manager Marketing By Design
www.mbdesign.com

We change the job number prefix at the beginning of every year. For example, at the beginning of 2003 we changed our XXX client jobs from 02-XXX-651 to 03-XXX-001. It works well for us.

Barry J. Owens Controller MAI Sports, Inc.

Christine--

Thanks for your response. We are using the year-client code-job number format as well, without the dashes, and are still having problems with numbering.

Alex Luken Traffic Manager

We use the same method as MAI Sports. We would have to exceed 1,000 in a year to have your problem, after 999 it just goes back to 000, 001 etc. If you do exceed 1,000 in a year for one client I would either split the client into two codes (same billing name address etc) and categorise them into DryClean USA Corporate (DUC0 and DryClean USA Promotions (DUP), or try and shorten your prefixes or take out the year or hyphens. It is what best works for you.

Sebastian Ogden Quantum Communications Int'l. Ltd.

Alex -

I believe C&P has a maximum of 10 "characters" to be used in a job number. You can change your format to accommodate that. Any "horror" jobs you have opened already, you can renumber them to the new format. (Utilities, re-number)

Diane Smith Business Manager Donaldson Makoski Inc.

We give all our clients three letter codes followed by a job number. The three letters roughly correspond with the client's name. So MetLife is MET and the job numbers are MET-1001, MET 1002, etc. Haven't had any problems reporting this way.

Madelyne Kirch

We go a few steps further to eliminate this problem, and number our jobs

Client - Number - Year

For instance

MAT - 099 - 03

And then add a user defined "Project" field for the Year "2003"

This was we can quickly search for all jobs in the 2003 for client MAT. The number sequence for that client starts at 001-04 at the beginning of a new year.

Gregory Galik AADLAND MARKETING
Visit us online - www.aadland.com

We use C&P to generate the job numbers but we had to cheat a little to = make it match our old numbering system.

We use the Client + Number format, for example: CA231298

Each year we give it a new numbering scheme where the number starts with = the year (as 2 digits) and then adds 4 more digits, giving us 9,999 jobs = each year.=20

this was easy back in the 1900's since we used 97, 98, 99 as the year. For = the 2000's we chose to use 20 (2000), 21 (2001), 22 (2002) 23 (2003) = because C&P would not allow us to start a number with "0". We figured that = by the year 2020, we would be doing things differently anyway, so it was = OK to use 20, 21, etc. So on the first day of 2004, we will tell C&P to = number jobs beginning with 240000.

The only real problem with this is that when sorting, the older jobs from = 1999 and before are sorted after any job in the 2000's, but it does allow = us to sort by client.

This works great for us. mindy -- mindy mcCain

We are using client and job number. For example: ABC1000. We did not use years or dashes when we initially set up the system because we were afraid that a numbering limitation might happen.

Jody Breiland McClenahan Bruer Communications

We've been doing it this way also and never had any problems.

Aggie

We do the same thing and are in the upper 2000s.

Liz Clapham