NAV 2009 vs NAV2013R2 - FLowfield and Flowfielter

tWism

Hello all,

i'm facing an error with NAV2013 when trying to reproduce the same funcionality that i have in 2009.

In the table 5612 - FA Depreciation Book in NAV2009, i have a custom field, which is a Flowfield with this calculation formula:
Exist("FA Depreciation Book" WHERE (FA No.=FIELD(FA No.),Depreciation Book Code=FIELD(Depreciation Book Code),FA Posting Date Filter=FIELD(FA Posting Date Filter),Book Value=CONST(0)))

The problem is with the use of the Flowfilter "FA Posting Date Filter".

In NAV2013 the table compiles with no error, but when the function calcfields its called, whenever i run the table or some C/AL code that uses the calcfield funcion, i have this error:

https://www.dropbox.com/s/dmduiwjczo9mjuh/SQL_error_flowfilter.jpg

Anyone have sugestions?

Thank you!

kine

You are trying to calf flow field from another flow field? Because it looks like yes. Because why else you will set filter on flowfilter of the target table... Because big changes in the flow field technology in the NAV 2013, I will expect that this will not work as before. Do not forget that now NAV support the autocalcfields command, that it is using subqueries to calf the flowfields etc.