Wednesday, September 10, 2014

Implicit conversion from data type datetime to decimal is not allowed.Use the CONVERT function to run this query.

Hi,

When you apply the date filter in chart of account page you have got the following error


























Solution

Remove the flowfield from page: "Add.-Currency Balance at Date"

 it is work now. This was the stndard bug in NAV 2013 base build may be it is solved in new build.

Posted by at

5 comments:

  1. UnknownMay 10, 2016 at 7:56 PM

    Thank you for your advice above, but how do you "Remove the flowfield from page: "Add.-Currency Balance at Date"

    ReplyDelete
  2. UnknownMay 10, 2016 at 8:02 PM

    Further to my comment above, I don't have the "Add-Currency Balance at Date" column selected. I have added it and removed it but I still get the same error

    ReplyDelete
  3. Nilesh GajjarJune 12, 2016 at 10:26 PM

    Delete this field from page designer in developer environment.

    ReplyDelete
  4. SEOSeptember 7, 2020 at 1:43 PM

    I read that Post and got it fine and informative. for more info

    ReplyDelete
  5. AnonymousDecember 2, 2020 at 10:59 PM

    Hi, Thanks for this solution. It worked with the user who had this error. But now, another user sees this error message (It was working well for him before deleting this field). Any leads? Thanks in advance.

    ReplyDelete

Subscribe to: Post Comments (Atom)