Hi there, I know that I’m at risk of asking the same question, already asked in this forum, but I was not able to find it [:I]. Is there a possibility to use flowfields in Security Filters in Navision 3.01 SQL? I want to restrict access to a salesheader and line, giving tabledata permission with a security filter on a type field. This type field exists in the header and is repeated in the line as a flowfield. Applying a security filter I only see ‘Sales:’ and no fieldcaption and value.
No, the security filter flow fields are only supported in a 3.60 hotfix (can’t remember which one, sorry) and in 3.70.
Thank’s for your reply. So I have to search for another approach [:)]. There are 3 departments using the sales tables; - Financials for Sales & Resource invoices, - Customer Services for Salesorders and Salesinvoices - Order Desk for Deposits and Dislocations Our internal auditor didn’t agree with the permissions model so far, that gave everyone permission to alter all documents. Maybe it’s possible to add code to the sales line triggers to check the userrole and the conditions?