Search Again: Re: duplicate invoice_id From: Colin Rees Date: Thursday, December 11, 2003 Time: 6:29:38 am Shawn, Q)How do you generate invoices? normal, fast mode, or? A)Use Fancy Invoices [Yes]. Use Fast Mode [No]. We generate invoices in batch mode with exception of the initial invoice as AR department does that once customer activated. Q)If you go to Maintenance & Preferences -> Clean Up -> Validate Record IDs, does anything come up? A) Nothing comes up. Colin -----Original Message----- From: Shawn Hogan [mailto:shawn@digitalpoint.com] Sent: Wednesday, December 10, 2003 4:21 PM To: Optigold ISP List Subject: Re: [Optigold ISP] duplicate invoice_id Colin Rees wrote: > Running invoices in batch mode a week ago and one of our Credit Officers > happened to have two printed invoices on their desk and went into these > accounts. Maintenance was needed on one of these invoices which they > performed flawlessly (data entry error on initial invoice which was being > corrected). Credit officer then noticed when they sent the invoice to > printer, then went into another account it changed the invoice on that > customer. > > I suspected it had to be behind the scenes..dumped out "Invoice_data" from > "Maintenance & Preferences > Export Raw Data and queried the "invoice_id" > and yes sir a duplicate emerged. id of 16040 tied to two separate invoices. > > Q) Any ideas as to how that could happen? > Q) More importantly how can I fix? > > PS- This is the only duplicate in our database of "invoice_id". How do you generate invoices? normal, fast mode, or? If you go to Maintenance & Preferences -> Clean Up -> Validate Record IDs, does anything come up? - Shawn ---------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html --------------------------------------------------- --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: duplicate invoice_id by Colin Rees on Dec 8, 2003 at 10:31:32 am Re: duplicate invoice_id by Shawn Hogan on Dec 10, 2003 at 12:24:07 pm Re: duplicate invoice_id by Colin Rees on Dec 11, 2003 at 6:29:38 am Re: duplicate invoice_id by Shawn Hogan on Dec 12, 2003 at 12:07:32 pm Re: duplicate invoice_id by Colin Rees on Dec 12, 2003 at 12:27:04 pm Re: duplicate invoice_id by Shawn Hogan on Dec 17, 2003 at 10:23:19 am Re: duplicate invoice_id by Colin Rees on Dec 17, 2003 at 11:45:26 am Re: duplicate invoice_id by Colin Rees on Dec 23, 2003 at 9:46:36 am Re: duplicate invoice_id by Shawn Hogan on Jan 6, 2004 at 3:13:32 pm