Item numbering

Lea_Dodds

Does anyone know of an way to add item numbering to invoices and quotations - without getting into a lot of customisation? Manual numbering would be OK, but automatic numbering (and renumbering after insertions) would earn the Oscar.

John_Tegelaar

How about making the LineNumber field visible?

John

Lea_Dodds

The problem with using the line number is that any line gaps, insertions or deletions (and we tend to have lots of them) will create havoc with the sequence.
Surely this is a common problem - I am hoping to find an off-the-peg solution.

John_Tegelaar

OK, if you want consecutive numbering without too much hassle, I would simply add a Number field to the Sales Line table and put a button on the form which calls a function which loops through all Sales Lines for the quotation/invoice. The function would populate your own number field with a sequential number each time the function is called.

Doing this fully automatic is possible, but would require quite a bit of development work to cope with all situations and variations.

John