Last invoice number

[dodonet]

Hello,
we need to change the last number of invoices to have the same from splynx to accounting software; I see also in the splynx db with Adminer without success.

Can you help me to achieve that ?

Thank you.

[Mazapura]

What is the format of the invoice number?
And what is the format of the invoice number to be made?

[dodonet]

Hello,

the imvoice number format is:

{year}{partner_id|2}{next|6}

I need to change the last invoice number to start for example to 1.

[Mazapura]

example, so?

1 - {year}{partner_id|2}{next|6}
2 - {next|6}
3 - {next}

ps: but save yourself from duplicate numbers

[dodonet]

Where do I find that table ?

[Mazapura]

@dodonet

Where do I find that table ?

it’s my virtual test SPLynx

[dodonet]

OK Mazapura,
thank you for your reply but I don’t understand how can I set the “next” field to a number of my choice; how can I set that the next invoice will be for example number 10 ?

[Mazapura]

this is next from “zero” or “last number invoices”

replaced to “{year}{month}{day}-{next}”

[dodonet]

OK,

the last number in “next” is editable ?

[Mazapura]

When creating an invoice, change it number manually 1 time, and then “next”