Search Again: duplicate invoice_id From: Colin Rees Date: Monday, December 8, 2003 Time: 10:31:32 am Shawn, 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". Thanks Colin Rees --------------------------------------------------- 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