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

3 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

Subscribe to: Post Comments (Atom)