Howdy, Stranger!
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
- 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
- 304 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 2013R2 Page open Error
Witches
Member Posts: 4
Hello,
We created two tables Haeder and Lines with complecated primary key on Header "No.,VAT Posting Type,VAT Invoice Type" (for Lines added "LineNo"). "VAT Posting Type" datatype is option and have two value "Purchase,Sale". We created 2 sets of page for Purchase and Sales separately. For Sales pages (List and Document for Header table) we set SourceTableView properti to "SORTING(No.,VAT Posting Type,VAT Invoice Type) ORDER(Ascending) WHERE(Status=FILTER(Open),VAT Posting Type=CONST(Sale))". For Purchase pages the same exept last value is "Purchase". Purchase pages works fine, but when we press "New" action in list page for Sale we have this error
But it only if there isn't any record with "VAT Posting Type"="VAT Posting Type"::Sale.
We try to set value "VAT Posting Type" to "Sale" OnInit and OnNew and OnOpen triggers for Document page and it's doesn't work. And frankly we doesn't have any ideas.
Does anybody have the same problem or know how it can be fixed?
Thanks in advance!
We created two tables Haeder and Lines with complecated primary key on Header "No.,VAT Posting Type,VAT Invoice Type" (for Lines added "LineNo"). "VAT Posting Type" datatype is option and have two value "Purchase,Sale". We created 2 sets of page for Purchase and Sales separately. For Sales pages (List and Document for Header table) we set SourceTableView properti to "SORTING(No.,VAT Posting Type,VAT Invoice Type) ORDER(Ascending) WHERE(Status=FILTER(Open),VAT Posting Type=CONST(Sale))". For Purchase pages the same exept last value is "Purchase". Purchase pages works fine, but when we press "New" action in list page for Sale we have this error
But it only if there isn't any record with "VAT Posting Type"="VAT Posting Type"::Sale.
We try to set value "VAT Posting Type" to "Sale" OnInit and OnNew and OnOpen triggers for Document page and it's doesn't work. And frankly we doesn't have any ideas.
Does anybody have the same problem or know how it can be fixed?
Thanks in advance!
0