Monday, May 14, 2018

Dynamics NAV - Bank Reconciliation - The application is not correct, totals do not match

Even though the totals look correct, you get this error and cannot post the bank rec.


  • The new NAV does not recognize further than 2 decimal places for fields explicitly defined as decimals, which causes the verification calculation to miss the small fractional amounts
  • To resolve this issue, the following steps must be taken
    • Add a Bank Statement entry of type "Difference"
    • Update the value to be the difference in the rounding required
    • NAV will not allow you to enter values past the 2 decimal places, but we can put the fractional values in via sql to allow it to calculate correctly
   update [CRONUS$Bank Acc_ Reconciliation Line]
set [Statement Amount] = -0.00000000000106 ,Difference = -0.00000000000106
  where [Bank Account No_] = 'MYBANK'
   and [Statement Line No_] = '20000'

No comments:

Post a Comment