Error message "The expresion Code cannot be type-conver

fmhigue
Member Posts: 290
Error message "The expresion Code cannot be type-converted to a Option Value"
This is the code I got:
SalesHeader.GET("Tax Area Code");
IF SalesHeader."Tax Area Code" = '0000000000' THEN
BEGIN
This is the code I got:
SalesHeader.GET("Tax Area Code");
IF SalesHeader."Tax Area Code" = '0000000000' THEN
BEGIN
0
Comments
-
The key of the Salesheader table is ("Document Type", "No.");
So there should be something likeSalesHeader.GET(SalesHeader."Document Type"::Invoice, "Tax Code")
0 -
Just to elaborate: The cause of the error is that you are passing the value '0000000000' into the first field of the primary key. The first field of the primary key of the sales header table is the Document Type field, which is an option type field. Navision can't resolve the code type value '0000000000' into the option field, which internally is represented by an integer value, and will consequently throw the error that you are experiencing.
Other than that, listen to Mark, he knows what he is talking about0
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