Re: [SL] unique ID's

[C. D. H. <Du...@Du...>]

Our accountants just about stroked out when they discovered duplicate
invoice numbers in SQL-Ledger.  The official response on this list was
"don't let your users make duplicaes".  Which, I think was a little
poor.  Our users weren't doing it on purpose, but the Post As New
buttons duplicate invoices, quotes, POs, etc verbatim - including the
ID.  I can't imagine why anyone who wasn't cooking their books would
want duplicate invoice numbers, so I added logic to force a new invoice,
quote and PO number assignment if a duplicate existed.

Dunc

ma ga wrote:
> Dear All,
>   While working on SL I noticed that numbers are not unique in different areas like Item no., invoice no, RFQ no., .... etc.    I wonder, if this was made on purpose and why .... I am considering putting some validation to guarantee the uniqueness of these feilds .... I appreciate your feedback?
>
> Regards,
> -Mahmoud
>
>
>  
> ____________________________________________________________________________________
> The fish are biting. 
> Get more visitors on your site using Yahoo! Search Marketing.
> http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>