Tax Invoice Number format in Sri Lanka

Uncategorized
1

Hi Lubos
Very urgent
The new Sri Lankan law requires a certain way of tax invoice number format.i;e it should be YYMMM_ANYID_sequence number.
In this, the sequence number changes with every invoice
The month changes every month as JAN,FEB,MAR and so on
The year changes every year as 26,27,28 and so on
The ANYID need not change
Secondly, the Tin number has to be entered in a certain place in the invoice
So with Claude AI I managed to get the required format done,but when the new month arised and invoiced all the previous invoices changed to the new month
Now the Claude AI says it has to be done by the developers or to give the information from the developers what can be done
For your prusal I can send privately the invoice HTML done by Claude
Please advice me

2

Hi, @AMM

Manager does not provide an automatic reset of invoice numbers each month. To achieve the format YYMMM_ANYID_sequence, you need to add one custom field to your invoices to store the sequence number manually.

  • YY (year) and MMM (month) can be taken directly from the Invoice Date.

  • ANYID is a static text you define yourself.

  • sequence number must be entered manually in the custom field for each invoice.

With this setup, your custom theme can combine the Invoice Date (year and month), the static ANYID, and the manual sequence number to generate the required invoice number format.

3

Manually entering the sequence number is not wise for an application like Manager .
The invoice sequence number is playing correctly only the month is making trouble now and the year also may
The Year Month and ANYID are prefixes for the sequence number
I beg your pardon the sequence is not needed to change every month,It can continue until life time

4

If you don’t need the sequence to reset every month, you can simply use the Invoice Reference field for the sequence number. In this case, the numbering will increase automatically. The consequence is that you must avoid creating back‑dated invoices, because doing so will break the sequence of your tax invoice numbers.

To fix your custom theme, you can instruct your AI assistant that the invoice number should be constructed as follows:

  • YY (year) and MMM (month) are taken directly from the Invoice Date.
  • ANYID is a static text you define yourself.
  • sequence number is taken from the Invoice Reference field.

This way, the AI assistant will generate invoice numbers in the required format by combining the date, your static identifier, and the automatically incrementing reference number.

5

Thank you for your concern and point. I will try that as well. Let Lubos also put his

6

Thank You Mabaega Problem sorted out