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
-
OOPS! :oops:
I screwed up!
I need to do the setrange beforecaling the form.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions