Hitting from Postman API to nav 2013 r2 service order

Anurag_0089

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>

RockWithNAV

System is saying

The field Job Type of table Multiple Job Selections contains a value (ACCIDENTAL REPAIR) that cannot be found in the related table

Do we have this ACCIDENTAL REPAIR in the table Multiple Job Selections

Anurag_0089

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.

RockWithNAV

Can you debug this to make sure, seems while execution it's not falling in place, something is happening in the middle.