I'm a Developer and quite to to using Dynamics NAV. At the moment I'm trying to set up a query which uses the sum of a field on the Item Ledger Entry table, linked to the Item Table (via. Item Number), and the Location Table via. Location Code. The Item table is Linked the Location table using the data item link 'Location Filter=Location.Code'. Once this query is ran, I get the following error: "The following SQL error was unexpected: Invalid column name 'Location Filter'. Statement(s) could not be prepared." My theory is that (in a query) Flow Filters can't be linked to normal fields in a query (or at least can't be used as a Data Item Link). Is my theory correct and if (or not so) is there a solution to this problem?
NOTE: All 3 Data Items are Necessary in my Query to achieve the results I desire.