Reservation Entry Table Entry no. exceeded

SaravananA
SaravananA Member Posts: 27
edited 2009-08-28 in NAV/Navision Classic Client
HI all,

Our reservation entry no exceeds the integer value range(ie. -2147483647
to +2147483647). So, we are not able to process any thing line Purchase order, Transfer order, Sales order etc. Any solution for this kindly help us.

With regards,
Saravanan

Comments

  • kine
    kine Member Posts: 12,562
    Hmmm... interesting...

    I see two ways: changing from Integer to BigInteger datatype with all side effects (like need to change all variables working with this field)
    or making some batch which will "compress" the entries to begin from number 1 (move all existing entries to beginning, renumbering all possible relations to this no. if any). I think there is no much table relations to Entry No. on Reservation entry in the system...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    is there some customized code where you set maybe a wrong "Entry No."? Or is there no customized code?
    How many reservations do you have? Are there some old reservation, that are not needed?

    So, if there is no source, you had 2 option. As i can see, Kamil has discribed both :-)
    There are 3 Table Realtions to this table:

    337 Reservation Entry (the table self)
    99000849 Action Message Entry
    99008533 BizTalk Reservation Entry
    Do you make it right, it works too!

Categories