Invoice number not in sequence

Hello -

 

       I have an issue with the invoice numbers in iMIS that maybe someone can help me undertand it better.  The invoice numbers are not in sequential order.  For example, it starts out nicely at 9028 through 9041 and then it jumps to 9043, 9044, 9045,.... skips 9050,9051, continues at 9053, .....  I'm on iMIS version 15.0, my service provider couldn't figure out why either.  If you can please respond to lan.mai@swacha.org.

Thank you in advance for your help.

 

Lan

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Hi Lan. Sounds like you have

Hi Lan.

Sounds like you have a customisation/external web application that is requesting invoice numbers and then does not use them. This could be for a number of reasons to wit serious auditing is required. One is that a user requests a service/product and drops out at invoicing stage so the invoice is not created. Once satisfied that the numbers are dropped for valid reasons you can ignore them.

Nominaly invoices are generated in iMIS by the invoice engine from either converting orders to invoice level or printing an invoice in a meeting order.

Being on 15.1.1 with success I suggest you consider upgrading to pick up the fixes to many issues. Perhaps this is an unknown one on your version?

Please put the answer you end up with on here so we can all share the result.

Thanks,

Greg.

Hi Greg -       Thank

Hi Greg -

      Thank you very much for the explanation.  I asked our Service Provider and they don't have an answer for it.  However, they have submitted the question to ASI.  I'll keep you all updated if there are any developments.

Best Regards,

Lan

Invoice number high jump

Invoice numbers can also jump suddenly if  the AR/Cash “Sales transactions” and “Credit memos” options have been used, followed by dbrepair and its rebuild counters option.  The problem with this is that it’s effectively a free-form data entry system for AR, and any invoice number you key in will be created in the system and, if larger than the last invoice number value in the Counter table, this will be incremented to match if dbrepair is also later run and the rebuild counters option used. Subsequent invoice numbers will then increase from this higher value. To avoid this, only use the Sales Order processing module (or the Events module, as appropriate).