Dynamics Community Forum Thread Details

Hi there,

I'm hoping someone can help me.

I have a transform XSLT that takes the standard AX picklist and transforms it into a format that the external warehouse can use.

Everything is in the transformed document and it looks great if viewed in a browser but if you look at it with Notepad you can see that there is an extra line feed after the Item long code that the receiving warehouse cannot cope with.

If I look at the document log in the System Administration -> Periodic -> Services and AIf -> history and view the XML, the standard AX document does not appear to have this extra line feed.

If I save the document from here and open it with Notepad it doesn't have the extra line feed. If I take the transform off the outbound port it doesn't have the extra line feed so I can only conclude the XSLT is incorrect in some way.

The item longcode is an extra field that is loaded in a parm method (parmPT_longcode) on the AXwmsOrderTrans and effectively returns

ItemId_ConfigId_InventColorID_inventsizeId_inventLocationId

It's pretty hard to cut and paste in this tiny response box but the transform document was originally created with altova software and looks like below.

Any suggestions would be greatfully appreciated as I'm not sure what to try next.

Thanks

Paulina

<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform" xmlns:ns0="schemas.microsoft.com/.../PickingList" xmlns:ns1="schemas.microsoft.com/.../Message" xmlns:xs="www.w3.org/.../XMLSchema" exclude-result-prefixes="ns0 ns1 xs">

<xsl:output method="xml" encoding="UTF-8" indent="yes"/>

<xsl:template match="/">

<xsl:attribute name="xsi:noNamespaceSchemaLocation" namespace="www.w3.org/.../xsl:attribute>

<xsl:for-each select="ns1:Envelope">

<xsl:variable name="WMSPickingRoute" select="ns1:Body/ns1:MessageParts/ns0:PickingList/ns0:WMSPickingRoute"/>

<xsl:variable name="WMSOrderTrans" select="$WMSPickingRoute/ns0:WMSOrderTrans"/>

<ORDER>

<ORDER_NUMBER><xsl:value-of select="string($WMSPickingRoute/ns0:PickingRouteID)"/></ORDER_NUMBER>

<REQUESTED_SHIPPING_DATE> <xsl:value-of select="string($WMSPickingRoute/ns0:DlvDate)"/></REQUESTED_SHIPPING_DATE>

<EXTERNAL_ORDER_ID><xsl:value-of select="string($WMSPickingRoute/ns0:TransRefId)"/></EXTERNAL_ORDER_ID>

<PO_NUMBER><xsl:value-of select="string($WMSPickingRoute/ns0:PT_CustomerRef)"/></PO_NUMBER>

<ORDER_DATE><xsl:value-of select="string($WMSPickingRoute/ns0:ActivationDateTime)"/></ORDER_DATE>

<FREIGHT_TERMS>X</FREIGHT_TERMS>

<CARRIER_ACCOUNT_NUMBER>X</CARRIER_ACCOUNT_NUMBER>

<STATE_PROVINCE><xsl:value-of select="string($WMSPickingRoute/ns0:PT_DlvState)"/></STATE_PROVINCE>

<POSTAL_CODE><xsl:value-of select="string($WMSPickingRoute/ns0:PT_DlvZipCode)"/></POSTAL_CODE>

</DESTINATION>

<xsl:for-each select="$WMSOrderTrans">

<ITEMS>

<ITEM>

<INVENT_TRANS_ID><xsl:value-of select="string(ns0:InventTransId)"/> </INVENT_TRANS_ID>

<ITEM_NUMBER> < xsl:value-of select="string(ns0:PT_Longcode)"/></ITEM_NUMBER>

<UNIT_PRICE>0.00</UNIT_PRICE>

<TAXES>

<TAX>

</TAX>

</TAXES>

<DUTY>

</DUTY>

</DUTIES>

<ITEM_TOTALS>

<SUB_TOTAL>0.00</SUB_TOTAL>

<TAX_TOTAL>0.00</TAX_TOTAL>

<DUTIES_TOTAL>0.00</DUTIES_TOTAL>

<GRAND_TOTAL>0.00</GRAND_TOTAL>

</ITEM_TOTALS>

</ITEM>

</ITEMS>

</xsl:for-each>

<ORDER_TOTALS>

<SUB_TOTAL>0.00</SUB_TOTAL>

<TAX_TOTAL>0.00</TAX_TOTAL>

<DUTIES_TOTAL>0.00</DUTIES_TOTAL>

<GRAND_TOTAL>0.00</GRAND_TOTAL>

</ORDER_TOTALS>

</ORDER>

</xsl:for-each>

</ORDERS>

</xsl:template>

</xsl:stylesheet>

Community site session details

XML Outbound document transform extra line feed

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Leaderboard > Microsoft Dynamics AX (Archived)

Featured topics

Product updates