G/L Entry Table Entry Number Jumped

fazlehasan
fazlehasan Member Posts: 70
edited 2014-04-22 in NAV/Navision Classic Client
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    is there a modification in the database related to this?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • fazlehasan
    fazlehasan Member Posts: 70
    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
    ara3n Member Posts: 9,258
    well it looks like you need somebody to look at the customization.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • vaprog
    vaprog Member Posts: 1,163
    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
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • fazlehasan
    fazlehasan Member Posts: 70
    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.

Categories