G/L Entry Table Entry Number Jumped

fazlehasan

Hi,

Our G/L Entry table Entry No. suddenly jumped from 9 Million to 1000 Million
when an user posted a Credit Memo with only 2 lines.
We are not able to see any reason.
We are using NAV 5.0 SP1, sql server 2012.
Can you please suggest how this can happen?

Thanks
FH

ara3n

is there a modification in the database related to this?

fazlehasan

There are customizations in related objects...but it's been working allright for a while until suddenly this jump happened,
there are occassional jumps but not so big jump - some jumps are becuase of the cleaning process, which deletes 0 valued entries.

Thanks

ara3n

well it looks like you need somebody to look at the customization.

vaprog

fazlehasan wrote:

there are occassional jumps but not so big jump - some jumps are becuase of the cleaning process, which deletes 0 valued entries.

:shock: [-X You are not supposed to alter entries in such a way. There's a good chance this is even illegal if NAV is used for the company's bookkeeping.
And then, there's a good chance you're breaking some logic somewhere by creating inconsistencies. If you don't want to have these 0 valued entries, you really should see to it that they don't get posted in the first place.

Now concerning the jump. Most likely cause is a bug in application logic. Further possibilities that come to mind is faulty hardware, such as bad memory, faulty network connections, bad disk subsystem (controller or drive), faulty mainboard. And then, of course, someone with a developer license messing with the data in the table directly, or someone altering the SQL table, if applicable.

ara3n

I wouldn't call it illegal.
There are a couple of countries that require the entry no to be sequential, but even in those scenarios a background job can re sequence the entries.

There are addons that allow you to actually use different ranges such as LS Retail.

fazlehasan

No regular cleaning process as such...only a stand alone report which can clean 0 valued G/L entries related to Customers,
which is not attached to any user menu. So nobody is deleting G/L entries!
There are small jumps all over the G/L entries, so we assumed that there may be some cleaning process doing it, but on
farther investigation we did not find one, we were not overly worried until this time when the jump is so big.
Thanks for your responses.