On Tue, May 27, 2008 at 12:05 PM, <..hidden..> wrote:
Quoting Chris Travers <..hidden..>:
In the db, you can run (in 1.2 or 1.3):
ALTER TABLE ar ADD UNIQUE(invnumber);
Thanks, I've just done that but it turns out that I do have a
duplicate invoice number. I do have a gap directly below it, though,
so I can just change invnumber.
Before I do that, is there anywhere else I will need to change it,
apart from ar?
Nope.... You *could* add one on (vendor_id, invnumber) to ap, but
that may be asking for trouble. In general, I would prefer to keep
that to AR.