OrderID en InvoiceID

An order isn't always completed. (payment not received for instance). An invoice is only available after the order is completed. Invoice numbers should always be consecutive.  So an invoice number is not the same as an orderid. How do one go about this in nopcommerce?

Add a column InvoiceNumber. Initially insert null value for this column. When customer complete  payment, get maximum invoice  number and update the recently paid order invoice number by maximum number+1.

atyoursite wrote:

For this purpose from nopCommerce 3.9 CustomOrderNumber column has been added. You can use this field as the invoice number and follow mhsjaber steps.