 |  |
Colin Rees wrote:
Re: duplicate invoice_id
From: Shawn Hogan
Date: Wednesday, December 10, 2003
Time: 12:24:07 pm
> 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
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page
| home | |
| products | |
| services | |
| support | |
| email lists |
| optigold isp | |
| optigold isp news | |
| home inspection | |
| inspectrix | |
| java companion | |
| oracle | |
| quickdns pro | |
| search engine | |
| veterinary |
| tips | |
| employees | |
| free tools | |
| portfolio | |
| jobs | |
| contact |
888/4-DPOINTSupport:
858/452-3696