Invoice number and payments transaction number are out of synch

avdistribution's picture

For some reason, the sequence of invoice numbers skipped one, so now invoices don't match payments transaction numbers. For example: invoice 10162 has a transaction number of 10161. The problem is when I download transactions at Paypal, I have to correct the invoice number.
If I reset the reference number in payments/settings will that correct this? I did reset it before and the change didn't take.


Hello,

lowate's picture

I cannot clearly understand...
by invoice number you mean 'Order number' of transaction and by transaction number 'Reference number' of a transaction?

Yes, payments transaction#

avdistribution's picture

Yes, payments transaction# and order# don't match. Paypal uses the term "invoice" for a transaction and uses the "transaction" number not the "order" number, so order#10162 shows an "invoice" number of 10161 at Paypal. .

http://a-vdistribution.com

reset the order number sequence

andree's picture

Hello,
you can reset the orders sequence number to match the transactions sequence.
System --> Settings --> Database Numbering

br,
Andree