Dynamics Community Forum Thread Details

cannot be found in the related table

From POSTMAN POST OPERATION:

<Soap:Envelope xmlns:Soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:microsoft-dynamics-schemas/page/serviceorder">
    <Soap:Body>
        <Create xmlns="urn:microsoft-dynamics-schemas/page/serviceorder">
            <serviceOrder>
                <Hour_Reading>0</Hour_Reading>
                <Work_Status_Code>IN PROCESS</Work_Status_Code>
                <Service_Person>EMP000176</Service_Person>
                <Status>Open</Status>
                <Mobile_No_for_SMS>980000000</Mobile_No_for_SMS>
                <Mobile_No_GSC_Recharge>980000000</Mobile_No_GSC_Recharge>
                <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>

Note: This is in Microsoft Nav 2013 r2 and I do have ONSITE in the Job Type Master. However, I’m still getting the above error when trying to post through the POSTMAN API. Also, multiple job selections will get assigned ONSITE only after posting.

Categories:

Dynamics 365 Field Service

Quick Links