07 April 2010 > Date: Wed, 7 Apr 2010 15:30:16 -0700 (PDT) > From: Krystal Daniel The numbering on our billing system jumped from 160921 to 690000; can you explain this? ---------------- From toby Wed Apr 7 17:10:57 2010 To: acpinvestigations@yahoo.com Sure, someone entered a large number such as 690000. Now the system thinks that was a valid number and the next number needs to be higher. I can walk someone through reseting the number, give me a call 541-619-0482 ---------------- 08 April 2010 09:02 Krystal- ACP - called Krystal is Carols legal and personal assistant since Jan. Has some experience with Linux. Jill - is new data entry, not very computer savvy. 80 jackets issued with new sequence. Some have been sent to client. None yet on statement, problem started on 5th, statements on 1st. Toby suggests: - Get up an running today: (Krystal) find proper sequence number; add 100 (to give room for 80 and a little in case miscount); (Krystal and Toby) reset sequence number; (Jill) do new work today. - Resequence invoices: (Krystal) Determine proper invoice numbers for out-of-sequence invoices; (Krystal) Determine range of out-of-sequence invoices; (Toby) connect in tonight and move out-of-sequence invoices into targetted gap; (Toby) add note containing originally issued invoice number; 09:26 13:09 Krystal - last in-sequence 161069 first 690081 - 690131 open console locate highnum /home/acp/ctab/highnum.tab /home/acp/ver4/highnum.tab cd /home/acp/ctab vi highnum.tab 690166 995612 161069 995612 ctab icon invoice -> 161070 Do not touch high sequence invoices, I will renumber them this evening and reset the highnum. 13:22 16:30 Jill - 161070 start 7 new ones enter 70, next is 73 161073 walk through last one 161077 (i)nvoice 690122 because they searched up there something else strange that just happened: Art looking for jacket, need affadavit print out search 160589 mar 01, has service info jacket out-of sequence 690121 Apr 07 12 April 2010 01:00 Could not connect in during the wee hours of the morning. Sent e-mail for Krystal to call me when she gets in. ----------------------- 15 April 2010 08:15 Krystal - Get rid of high invoices? Not all the numbers have been moved. Someone will call Toby when they are ready for help. ----------------------- 27 April 2010 13:05 Krystal - Need to delete high invoices, and reset the high number. Current highest bad invoice: 690135 Current highest good invoice: 161397 /home/acp/ctab/highnum.tab At console carmella@localhost: carmella cd /home/acp/ctab carmella@localhost: ctab ls 001*i.tab lots like 0014910i.tab carmella@localhost: ctab ls 006*i.tab 0060000i.tab 0060010i.tab 0061030i.tab 0065280i.tab 0065870i.tab 0067450i.tab 0069000i.tab 0069010i.tab carmella@localhost: ctab ls 005*i.tab lots carmella@localhost: ctab ls 004*i.tab none carmella@localhost: ctab ls 003*i.tab none carmella@localhost: ctab ls 002*i.tab none carmella@localhost: ctab ls 0019*i.tab none carmella@localhost: ctab ls 0018*i.tab none carmella@localhost: ctab ls 0017*i.tab none carmella@localhost: ctab ls 0016*i.tab about 14 carmella@localhost: ctab rm 009*i.tab carmella@localhost: ctab rm 007*i.tab carmella@localhost: ctab rm 006*i.tab carmella@localhost: ctab rm 005*i.tab carmella@localhost: ctab ls 01*i.tab none carmella@localhost: ctab ls 009*i.tab none carmella@localhost: ctab ls 007*i.tab none carmella@localhost: ctab ls 006*i.tab none carmella@localhost: ctab ls 005*i.tab none carmella@localhost: ctab vi highnum.tab 690145 995613 change to 161397 995613 ctab invoice 161398 Art had mini-stroke. 13:40 ----------------------- -----------------------