Dear Lubos
on the 6th of June, 2021 - right after invoice number 3199 (auto-generated), the next invoice generated shows 3218 as the invoice number.
It has somehow jumped 19 numbers and generated invoice number 3218, I am on the server version.
Please advise.
Prem
Have you tried searching for any of the invoices from 3200 to 3217 in the Sales Invoices tab?
Yes, I even sorted them and checked, its missing
There must be invoice with reference number 3217. There is no other explanation.
Can you check form default? Maybe your form default for sales invoice has 3217 in reference field.
You also need to search for “3217” and possibly “217.” This could be in an alpha-numeric number you entered a long time ago. When assigning automatic reference numbers, Manager ignores alphabetic characters and only looks at number strings contained anywhere in prior reference numbers. It also ignores punctuation marks. So, if you had a reference “RA3/217-A,” Manager would assign the next automatic reference as 3218.
@lubos I have practically checked everywhere, is there a way a user can tamper with the reference if its set ‘auto’ in the form defaults?
Because the users have the ability to create a sales invoice only, no edit or update options allowed to them.
Please advise
Prem
How about what @Tut wrote? Reference numbers 3/217, 32-17 or 3.217 would all count as 3217.
No, it has not been defined as such in the system.
Since we are invoicing sales using the manager app directly, we do not fiddle with the reference, it has been set ‘Automatic’ under the ‘Form Defaults’ for All sales invoices & Credit Notes.
There is a separate billing operator assigned. Her task is limited only to ‘create’ sales invoices, the operator is NOT allowed to update or delete any sales invoices once created. Therefore there is no way this can be edited.
sort by reference number and look for outliers.
The outlier only needed to be there when the first out of series number was generated. Or to word it another way, deleting incorrectly entered data can also leave a gap if a new automatic number is generated while the erroneous data was there.
While I haven’t tried this myself, I believe restricted users can still uncheck “Auto” in Reference and enter any reference number they wish to.
Kindly correct me if this is not the case.
That is true, as long as they have permission to Create or Edit the transaction type.