- 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
set [Statement Amount] = -0.00000000000106 ,Difference = -0.00000000000106
where [Bank Account No_] = 'MYBANK'
and [Statement Line No_] = '20000'
No comments:
Post a Comment