Opensourcepos: unique invoice number
Got error when input "sales by invoice" said "Please enter an unique invoice number"
?
sanubari97
All 4 comments
This is caused by a problem with your data or a configuration issue. If you cannot figure it out for yourself and need some free support or sympathy please provide the requested environment information and some details about how you are configured related to invoices
SteveIreland
on 14 Oct 2017
Probably your invoice counter is not setup correctly or you changed it yourself? It tries to complete an invoice with number that is already in the db
jekkos
on 14 Oct 2017
this is my config,
I deleted some invoice sales from the "takings", is that the cause ? then how do I fix it ?
sanubari97
on 16 Oct 2017
Yes, the {CO} token assigns an invoice number representing the current count of records in the ospos_sales table. Since you deleted some records that throws the count off.
If you want a quick fix then change the invoice format to {ISEQ} and set the last used invoice number to the last one that was actually assigned as the invoice.
I believe this is documented in the Wiki.
SteveIreland
on 16 Oct 2017
Related issues
esbyrt
路
5Comments
asakpke
路
4Comments
AbanoubMakram
路
4Comments
tekkeur
路
4Comments
objecttothis
路
4Comments
Most helpful comment
Yes, the {CO} token assigns an invoice number representing the current count of records in the
ospos_salestable. Since you deleted some records that throws the count off.If you want a quick fix then change the invoice format to
{ISEQ}and set the last used invoice number to the last one that was actually assigned as the invoice.I believe this is documented in the Wiki.