Dynamics Community Forum Thread Details

Configuration AIF on AX 2012 R3

Dear All,

Could someone help me with the issue when I create a sales order from an XML file via AIF set up on AX 2012 R3.

1. I created service with schema as below.

<?xml version="1.0" encoding="utf-16" ?>

- <xs:schema xmlns:tns="schemas.microsoft.com/.../SalesOrder" xmlns:st="schemas.microsoft.com/.../sharedtypes" elementFormDefault="qualified" targetNamespace="schemas.microsoft.com/.../SalesOrder" xmlns:xs="www.w3.org/.../XMLSchema">

<xs:import schemaLocation="SharedTypes.xsd" namespace="schemas.microsoft.com/.../sharedtypes" />

<xs:element name="SalesOrder" type="tns:AxdSalesOrder" />

- <xs:complexType name="AxdSalesOrder">

- <xs:sequence>

<xs:element minOccurs="0" maxOccurs="unbounded" name="SalesTable" type="tns:AxdEntity_SalesTable" />

</xs:sequence>

</xs:complexType>

- <xs:complexType name="AxdEntity_SalesTable">

- <xs:sequence>

<xs:element minOccurs="0" name="DefaultDimension" nillable="true" type="st:AxdType_DimensionAttributeValueSet" />

<xs:element minOccurs="1" name="PurchOrderFormNum" type="st:AxdExtType_CustPurchaseOrder" />

<xs:element minOccurs="1" name="ReceiptDateRequested" type="st:AxdExtType_SalesReceiptDateRequested" />

<xs:element minOccurs="0" maxOccurs="unbounded" name="SalesLine" type="tns:AxdEntity_SalesLine" />

<xs:element minOccurs="0" maxOccurs="unbounded" name="MarkupTransHeader" type="tns:AxdEntity_MarkupTransHeader" />

</xs:sequence>

<xs:attribute fixed="entity" name="class" use="required" />

<xs:attribute name="action" type="st:AxdEnum_AxdEntityAction" />

</xs:complexType>

- <xs:complexType name="AxdEntity_SalesLine">

- <xs:sequence>

<xs:element minOccurs="0" name="DefaultDimension" nillable="true" type="st:AxdType_DimensionAttributeValueSet" />

<xs:element minOccurs="1" name="SalesQty" type="st:AxdExtType_SalesOrderedQty" />

<xs:element minOccurs="1" name="SalesUnit" type="st:AxdUnion_AxdExtType_SalesUnit_AxdType_ExtCodeValue" />

<xs:element minOccurs="0" maxOccurs="unbounded" name="MarkupTransLine" type="tns:AxdEntity_MarkupTransLine" />

</xs:sequence>

<xs:attribute fixed="entity" name="class" use="required" />

<xs:attribute name="action" type="st:AxdEnum_AxdEntityAction" />

</xs:complexType>

- <xs:complexType name="AxdEntity_MarkupTransLine">

- <xs:sequence>

<xs:element minOccurs="1" name="MarkupCode" type="st:AxdUnion_AxdExtType_MarkupCode_AxdType_ExtCodeValue" />

</xs:sequence>

<xs:attribute fixed="entity" name="class" use="required" />

<xs:attribute name="action" type="st:AxdEnum_AxdEntityAction" />

</xs:complexType>

- <xs:complexType name="AxdEntity_MarkupTransHeader">

- <xs:sequence>

<xs:element minOccurs="1" name="MarkupCode" type="st:AxdUnion_AxdExtType_MarkupCode_AxdType_ExtCodeValue" />

</xs:sequence>

<xs:attribute fixed="entity" name="class" use="required" />

<xs:attribute name="action" type="st:AxdEnum_AxdEntityAction" />

</xs:complexType>

</xs:schema>

2. I created XML file with the info

<?xml version="1.0" encoding="utf-8" ?>
<Envelope xmlns="">schemas.microsoft.com/.../Message">
<Header>
<MessageId>{5603D03A-4380-404D-9F27-738BE0FEA13E}</MessageId>
<Action>schemas.microsoft.com/.../Action>
</Header>
<Body>
<MessageParts>
<SalesOrder xmlns="">schemas.microsoft.com/.../SalesOrder">
<SalesTable class="entity">
<CustAccount>HCM-00481</CustAccount>
<PurchOrderFormNum>LuisTestPO</PurchOrderFormNum>
<DeliveryDate>04-15-2021</DeliveryDate>
<ReceiptDateRequested>04-15-2021</ReceiptDateRequested>
<SalesLine class="entity">
<ItemId>P00916</ItemId>
<SalesQty>18</SalesQty>
<SalesUnit>Pcs</SalesUnit>
</SalesLine>
</SalesTable>
</SalesOrder>
</MessageParts>
</Body>
</Envelope>

3. I added 4 jobs on the batch with the condition complete task 1 to do task2... task 3, task 4 the same

=> the batch job runs well, however, the sales order didn't create, the system always shows the message in the exception 'Invalid message schema. Could someone have a look for me?

Thank and regards,

Luis

schemas.microsoft.com/.../Message">

{5603D03A-4380-404D-9F27-738BE0FEA13E} schemas.microsoft.com/.../Action>

schemas.microsoft.com/.../SalesOrder"> HCM-00481 LuisTestPO 04-15-2021 04-15-2021 P00916 18 Pcs

If AX doesn't give you descriptive error messages, I warmly suggest to use some online tool to check your XML message against the schema. However just by looking at it, we can immediately see that you have problems.

Your schema says that SalesTable section in the file should have following elements:

DefaultDimension (optional)
PurchOrderFormNum (mandatory)
ReceiptDateRequested (mandatory)

And your message has following elements:

CustAccount
PurchOrderFormNum
DeliveryDate
ReceiptDateRequested

Also in SalesLine you try to import ItemId but your schema doesn't have it.

To me it looks that your schema has some issue because it doesn't have information such as customer account or item id, which are mandatory information when you create sales orders in AX.

Quick Links