Options

Error- Inserting new operation

subbu_Bsubbu_B Member Posts: 5
:? When trying to insert a operation in the production order routing lines an error is thrown

Error- Overflow under type conversion of Decimal to Integer.
Value: 5,940,000,000

When I went through the code the error is when calculating the Ending time.

Why this should happen

Thanks in advance

Comments

  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Try using BigInteger. It will fit.

    Integer is max 2147483647

    Usualy this happens with calculation of duration if the duration is to long.

    You can also use DateTime. This is a decimal field under water.

    Regards,

    Mark
  • Options
    subbu_Bsubbu_B Member Posts: 5
    Dear Mark,

    Error is flased when calculating Ending time for which the data type is time

    and am unable to change the data type to Date time

    Regards
    Subbu
  • Options
    kinekine Member Posts: 12,562
    Please, sometime it is problem because mixed time measure units (hours vs. seconds etc...), check, if all times are in same units...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.