Account schedule Row No Filter wrong result
BHT
Member Posts: 56
Hi All,
I found each time I filter the account schedule line in row no. column it result wrong list.
For example, the row no from 0 to 500. The filter is 340..420.
The list result line number 0, 2, 3, 4, 20, 30, 40 ... 300, 400...
Seem all characters in filter criteria 340 and 420 listed in the result list.
Is there any idea to overcome this matter?
I just want to have line list betwee 340 till 420.
Thanks
BHT
I found each time I filter the account schedule line in row no. column it result wrong list.
For example, the row no from 0 to 500. The filter is 340..420.
The list result line number 0, 2, 3, 4, 20, 30, 40 ... 300, 400...
Seem all characters in filter criteria 340 and 420 listed in the result list.
Is there any idea to overcome this matter?
I just want to have line list betwee 340 till 420.
Thanks
BHT
Regards,
BHT
BHT
0
Comments
-
1) Row No. is of type Code. You need to use numbers like "0001, 0002" etc. to have correct sorting if you are on MS SQL.
2) It means all used codes must have same length...0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
