PDA

View Full Version : Verify problem - Invalid salesperson - QBPro2003


Maurice Carr
02-04-2007, 04:55 AM
I'm running QBPro2003 which has run faultlessly up until recently.

I cannot verify my company file and checking the QBWIN.LOG is see the following error;

Error: Verify Master: Invalid salesperson. Rcrd = 1224161. Ref = 32

There's about 3 pages of these errors going from 2004 to recently.

The common denominator Error: Verify Master: Invalid salesperson. Ref = 32 in all of them

Anyone have any clues what this means and how I go about fixing it?

Mo

Joe Williams
02-04-2007, 05:40 AM
One of the Rep names has damage. Try opening the Write Check and click in the pay to order. Press Ctrl-L and open the names list. Click Names then Resort list.
Go to the Rep list and one at a tile click their name then the Sales Rep button then Find in transactions. If there is still a "bad" one it will fail. You can then edit that Rep and change the Rep's initial and save it. This causes all of the transactions using that rep to be re-linked.
Run verify to see of the problem is corrected.

Maurice Carr
02-04-2007, 11:14 AM
Cheers - thanks for that, I'll try that when I get to work this morning. Will let you know how I got on

Mo

Maurice Carr
02-04-2007, 09:14 PM
Run verify to see of the problem is corrected.

Well, that didn't fix it and in fact I did not find one "bad" rep.

However what I did find was comparing the Rep List to an earlier copy of a file that I could verify, I found that three Reps were missing in my latest file.

We only ever use reps to identify where our leads come from eg YP initial would stand for Yellow Pages, V would stand for advertsing on our Van etc etc.

Out of the 3 missing reps, 2 only had one invoice each liked to them and the 3rd had the other 62 invoices.

The "Ref = 32" that came up, for anyone's interest, "32" represents the number assigned to that Sales Rep.

So do you think I should;

In my latest file, re-enter the missing sales reps exactly how they were before, and then go to each invoice affected and reassign the rep there?

or........?????

Mo

EDIT: SUCCESS - I re-entered the missing sales reps exactly how they were before, and then went to each invoice affected and reassigned the rep, then did a rebuild and IT VERIFIED !!!! Yahoooooooo!! Thank you Joe

qbsrox
02-07-2007, 05:00 PM
I would keep a close eye on this - something made it go whacko in the first place - so verify on a regular basis. Glad you were successful!!