billnr vs invoicenr in oxorder table
What is the reason for these two?
Invoicenr doesnt seem to be used anywhere. Any idea’s?
Ironically billnr is a varchar, although it is used in calculations (+1),
Greetz,
H.
Hi H.,
dunno exactly but I reckon OXBILLNR has something to do with the PDF generation.
Best
yes that is correct. Creating a PDF invoice(!) will generate an oxbillnr. Ok, i still wont use oxinvoicenr as we dont know what it is meant for. But i did add the oxbillnr to the order_overview columns. Just too bad its a varchar. It makes sorting on that field useless 
if you start with oxbillno 100000 you can sort too (unless you have 1 million orders 
)