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
>
>
|
