Hitting from Postman API to nav 2013 r2 service order

need help, recently I have been working on a service order where I'm facing 500 error when trying to hit through postman to nav 2013 r2.
Note: Service order contains select job types with mapping fields based on general job category and job type. The error you can see also has the same content in JOB TYPE MASTER
Body of postman Api:
<Soap:Envelope xmlns:Soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:microsoft-dynamics-schemas/page/serviceorder">
unsafe:Soap:Body
<Create xmlns="urn:microsoft-dynamics-schemas/page/serviceorder">
<serviceOrder>
<!-- <VIN>******</VIN> -->
<Kilometrage>900753</Kilometrage>
<Hour_Reading>0</Hour_Reading>
<Work_Status_Code>IN PROCESS</Work_Status_Code>
<Service_Person>EMP000xyz</Service_Person>
<Status>Open</Status>
<Select_Jobs>
<Select_Job_Types>
<General_Job_Category>REPAIRS JOB</General_Job_Category>
<Job_Type>ACCIDENTAL REPAIR</Job_Type>
</Select_Job_Types>
</Select_Jobs>
</serviceOrder>
</Create>
</Soap:Body>
</Soap:Envelope>
Error: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<s:Fault>
<faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">a:Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideValidateTableRelationException</faultcode>
<faultstring xml:lang="en-US">The field Job Type of table Multiple Job Selections contains a value (ACCIDENTAL REPAIR) that cannot be found in the related table (Job Type Master).</faultstring>
<detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">The field Job Type of table Multiple Job Selections contains a value (ACCIDENTAL REPAIR) that cannot be found in the related table (Job Type Master).</string>
</detail>
</s:Fault>
</s:Body>
</s:Envelope>
Answers
-
System is saying
The field Job Type of table Multiple Job Selections contains a value (ACCIDENTAL REPAIR) that cannot be found in the related tableDo we have this ACCIDENTAL REPAIR in the table Multiple Job Selections
Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
Yes, I do have Accidental Repair in the Job Type Master table. However, for multiple job selections, Accidental Repair will only be available when the user posts.
0 -
Can you debug this to make sure, seems while execution it's not falling in place, something is happening in the middle.
Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/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
- 321 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