HomeGuidesAPI ReferenceAnnouncements
HomeGuidesAPI ReferenceChangelogDeveloper Q&A
HomeGuidesAPI ReferenceAnnouncementsLog In
Developer Q&A

Developer Q&A

Ask a Question
Back to all

amtWithTax error

7 years ago by Olivia

Error received: Cannot insert the value NULL into column 'amtWhTax', table 'StageJLLMcDonalds.dbo.WorkOrderCostObject'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Payload:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
SOAP-ENV:Header
<m:CorrigoNetOptions xmlns:m="http://corrigo.com/integration/">
<m:ImposeConcurrencyId>false</m:ImposeConcurrencyId>
<m:UpdateLastModified>true</m:UpdateLastModified>
<m:CanDeleteMissingEntity>true</m:CanDeleteMissingEntity>
</m:CorrigoNetOptions>
</SOAP-ENV:Header>
SOAP-ENV:Body
<m:Execute xmlns:m="http://corrigo.com/integration/">
<m:commandRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="m:WoCreateCommand">

<m:WorkOrder>
<m:TypeCategory>Basic</m:TypeCategory>
<m:SubType>
<m:Id>1</m:Id>
</m:SubType>
<m:WorkZone>
<m:Id>2</m:Id>
</m:WorkZone>
<m:Contact>
<m:Id>2</m:Id>
</m:Contact>

				<m:Priority>
					<m:Id>3</m:Id>
				</m:Priority>
				<m:TimeZone>4</m:TimeZone>
				<m:Items>
					<m:WoItem>
						<m:Asset>
							<m:Id>6107</m:Id>
						</m:Asset>
					<m:Task>
							<m:Id>22080</m:Id>
						</m:Task>
						<m:Comment>This is a Test AC WO </m:Comment>
					</m:WoItem>
				</m:Items>
			</m:WorkOrder>
			<!--Compute Schedule will populate Priority, Speciality, Due By Date, NTE, and Expense Account-->
			<m:ComputeSchedule>false</m:ComputeSchedule>
			<!--ComputeAssignment will populate the "Assigned-To" field based on Speciality or Property assignment -->
			<m:ComputeAssignment>false</m:ComputeAssignment>
		</m:commandRequest>
	</m:Execute>
</SOAP-ENV:Body>

</SOAP-ENV:Envelope>