invoice_numbering_by_biller

18 views
Skip to first unread message

Ap.Muthu

unread,
Oct 16, 2013, 11:58:52 AM10/16/13
to Justin James Kelly, SI Group
When and why was the invoice_numbering_by_biller feature removed?
invoice_numbering_by_biller can provide each biller with their own sequence
of document numbering.

making the node represent the module (invoice) and hard coding it
making the sub_node represent the index_group
making the sub_node_2 represent the biller_id if invoice_numbering_by_biller
was set (not anymore).

Field names seem to be very generic like it was pulled out of some other
context.

making field sizes 255 render it unusable in fulltext indexes.

This table si_index, however, keeps us from re-computing the max invoice
number each time.

- Ap.Muthu

Justin Kelly

unread,
Oct 16, 2013, 9:09:20 PM10/16/13
to SI Group
think it was only removed as wasnt fully tested and working 

if you can make it work 100% then add it back in


Ap.Muthu

unread,
Oct 17, 2013, 8:53:15 PM10/17/13
to simplei...@googlegroups.com
There is little to keep it from working fully. We just need to enable it in my new /include/class/index.php and alter the /include/class/invoice.php besides the functions that insert/update/select invoices in sql_queries.php / functions.php if any. Everywhere else, the absolute value of invoices.id is used and hence it does not matter.

Also the Unique Key:
  KEY `UniqDIB` (`index_id`, `preference_id`, `biller_id`, `domain_id`),
for the invoices table will take care of the various *id values needed other than invoices.id

Justin Kelly

unread,
Oct 23, 2013, 10:42:49 PM10/23/13
to simplei...@googlegroups.com
thanks ap 

my preference is that you create a branch - make it all work - and i'll pull it into SI master once 2013.1 is out

cheers

justin


--
You received this message because you are subscribed to the Google Groups "Simple Invoices" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simpleinvoice...@googlegroups.com.
To post to this group, send email to simplei...@googlegroups.com.
Visit this group at http://groups.google.com/group/simpleinvoices.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all
Reply to author
Forward
0 new messages