Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 282 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Lanham User Security Setup
couberpu
Member Posts: 317
Hi,
I need help on using Lanham User Security Setup.
1. Customer has multiple sales persons doing bsiness from defferent territory.
2. Each salesperson has his/her own "SM Territory Code" and was updated to sales order, but not on sales lines.
3. We had a form to show sales lines and it is using lanham user security setup program to do the security filter.
So here is the question: How to make the filter first filter the sales order on "SM Territory Code" then only show the lines for a salesperson?
I use both S36 and S37 table in SetSecurity function and first SetFieldFilters on "Sales Header" then SETRANGE("Sales Line"."Document No.","Sales Header"."No.") and then SetFieldFilter on "Sales Lines" with no luck!
Thanks,
CouberPu
I need help on using Lanham User Security Setup.
1. Customer has multiple sales persons doing bsiness from defferent territory.
2. Each salesperson has his/her own "SM Territory Code" and was updated to sales order, but not on sales lines.
3. We had a form to show sales lines and it is using lanham user security setup program to do the security filter.
So here is the question: How to make the filter first filter the sales order on "SM Territory Code" then only show the lines for a salesperson?
I use both S36 and S37 table in SetSecurity function and first SetFieldFilters on "Sales Header" then SETRANGE("Sales Line"."Document No.","Sales Header"."No.") and then SetFieldFilter on "Sales Lines" with no luck!
Thanks,
CouberPu
0
Comments
I screwed up!
I need to do the setrange beforecaling the form.