On 16 Feb 2010, at 05:58, Bob Miller wrote: > ... > For my installations, when sorting by invoice number, my numbers go > like > this: > > 1 > 10 > 100 > 101 > 102 > 103 > 104 > 105 > 106 > 107 > 108 > 109 > 11 > 110 > 111 > > and so on. Is there a way to make it so invoices 11-99 comes *before* > 100??
I appreciate this may be unhelpful to you at the present time, but this can avoid this by setting the default to "000000" (or is it "000001"?) in defaults when you install LedgerSMB. This causes invoice numbers to be created respecting the leading zeros. Stroller. ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
