LN Rejecting InventoryAdjustmentBOD –BOD Extension LineNumber Issue is Killing My Sanity!

mararongsya

Hello,

I spent the entire weekend staying up all night trying to resolve this issue. Please help me.

Objective:

I am trying to extend InventoryAdjustmentBOD to insert inbound data into the CDF field and reflect it in LN.

For reference, I am using Enterprise Connector to convert a CSV file into CustomBOD, then mapping it from sync.customBOD to process.AdjustmentBOD to insert the data into LN.

Issue:

The following error occurs (confirmed in ACK) even though the LineNumber value is present:

T<span style="background-color:#ff6600;">he <span class="hljs-type">Line field <span class="hljs-keyword">is required <span class="hljs-keyword">in Adjustment <span class="hljs-keyword">Order Lines. Cannot <span class="hljs-keyword">create a <span class="hljs-built_in">new <span class="hljs-type">record <span class="hljs-keyword">in whinh521 <span class="hljs-keyword">with <span class="hljs-keyword">order

Due to this, data insertion into LN is not functioning correctly, and my lifespan is decreasing as well.

Please, I need your help.

Steps I Have Taken:

1. Extending InventoryAdjustmentAdjustmentBOD in LN

|* Use this hook to process the data from the UserArea node of an inbound BOD.

property.node1 = getNamedProperty("ln.cdf_bpco")
if property.node1 <> 0 then
if property.name1(1;11) = "ln.cdf_bpco" then
bpco = getPropertyValue(property.node1)
endif

property.node2 = getNextProperty(property.node1)
if property.node2 <> 0 and property.name2(1;11) = "ln.cdf_cono" then
cono = getPropertyValue(property.node2)
endif
endif

getTableIdentifiers.InventoryAdjustmentLine(header.xml)
iad.order = getIdentifierValueFromIdentifierStructure(header.xml, "whinh521", "orno")
iad.pono= lval(getIdentifierValueFromIdentifierStructure(header.xml, "whinh521", "pono"))

| iad.order = "IV0000995"
| iad.pono = 1

select whinh521.cdf_bpco, whinh521.cdf_cono
from whinh521 for update
where whinh521._index1 = {:iad.order, :iad.pono}
| as set with 1 rows
selectdo
ret = dal.change.object("whinh521")
dal.set.field("whinh521.cdf_bpco", bpco)
dal.set.field("whinh521.cdf_cono", cono)
ret = dal.save.object("whinh521")
if ret <> 0 then
dal.set.error.message(sprintf$("@Cannot update the CDF fields %s", iad.order))
return(DALHOOKERROR)
endif
selectempty
ret = dal.new.object("whinh521")
dal.set.field("whinh521.cdf_bpco", bpco)
dal.set.field("whinh521.cdf_cono", cono)
ret = dal.save.object("whinh521")
if ret <> 0 then
dal.set.error.message(sprintf$("@Cannot create a new record in whinh521 with order %s", iad.order))
return(DALHOOKERROR)
endif
endselect

---

2. OS -> ION -> Connect -> Mapping (XSLT Transformation)

Below is my XSLT file that converts the incoming data into the expected BOD format:

<xsl:stylesheet version="2.0" xmlns="">schema.infor.com/.../2"
xmlns:expath-zip="">http://expath.org/ns/zip" xmlns:fn="">www.w3.org/.../xpath-functions"
xmlns:dns="">schema.infor.com/.../2" xmlns:saxon="">http://saxon.sf.net/"
xmlns:expath-file="">http://expath.org/ns/file"
xmlns:xsi="">www.w3.org/.../XMLSchema-instance"
xmlns:xsl="">www.w3.org/.../Transform" xmlns:exslt-random="">http://exslt.org/random"
xmlns:exslt-common="">http://exslt.org/common" xmlns:exslt-math="">http://exslt.org/math"
xmlns:xs="">www.w3.org/.../XMLSchema"
xmlns:math="">www.w3.org/.../math"
xmlns:map="">www.w3.org/.../map"
xmlns:infor="">http://infor.com/infor-custom"
exclude-result-prefixes="xs xsl fn expath-file expath-zip exslt-common exslt-math exslt-random map math saxon xsi">
<xsl:output method="xml" encoding="UTF-8" indent="no" byte-order-mark="no" />
<xsl:strip-space elements="*" />
<xsl:template match="/">
<xsl:if test="/*:SyncIBCT_IAD_S">
<xsl:element name="ProcessInventoryAdjustment">
<xsl:namespace name="xs" select="'">www.w3.org/.../XMLSchema'" />
<xsl:if
test="/*:SyncIBCT_IAD_S/@languageCode"&gt;
<xsl:attribute name="languageCode">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/@languageCode)" />
</xsl:attribute>
</xsl:if>
<xsl:if
test="/*:SyncIBCT_IAD_S/@releaseID"&gt;
<xsl:attribute name="releaseID">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/@releaseID)" />
</xsl:attribute>
</xsl:if>
<xsl:if
test="/*:SyncIBCT_IAD_S/@systemEnvironmentCode"&gt;
<xsl:attribute name="systemEnvironmentCode">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/@systemEnvironmentCode)" />
</xsl:attribute>
</xsl:if>
<xsl:if
test="/*:SyncIBCT_IAD_S/@versionID"&gt;
<xsl:attribute name="versionID">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/@versionID)" />
</xsl:attribute>
</xsl:if>
<xsl:copy-of
select="/*:SyncIBCT_IAD_S/*:ApplicationArea" copy-namespaces="no" />
<xsl:if
test="/*:SyncIBCT_IAD_S/*:DataArea">
<xsl:element name="DataArea">
<xsl:element name="Process">
<xsl:element name="AccountingEntityID">
<xsl:if
test="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:AccountingEntity">
<xsl:attribute name="accountingEntity">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:AccountingEntity)" />
</xsl:attribute>
</xsl:if>
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:AccountingEntity)" />
</xsl:element>
<xsl:element
name="LocationID">
<xsl:if test="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:EntityLocation">
<xsl:attribute name="location">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:EntityLocation)" />
</xsl:attribute>
</xsl:if>
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:EntityLocation)" />
</xsl:element>
<xsl:element
name="ActionCriteria">
<xsl:element name="ActionExpression">
<xsl:attribute name="actionCode">
<xsl:value-of
select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:ActionCode)" />
</xsl:attribute>
</xsl:element>
</xsl:element>
</xsl:element>
<xsl:element
name="InventoryAdjustment">
<xsl:element name="InventoryAdjustmentHeader">
<xsl:element name="DocumentID">
<xsl:element name="ID">
<xsl:if
test="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:AccountingEntity">
<xsl:attribute name="accountingEntity">
<xsl:value-of
select="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:AccountingEntity/text()" />
</xsl:attribute>
</xsl:if>
<xsl:if
test="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:EntityLocation">
<xsl:attribute name="location">
<xsl:value-of
select="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:EntityLocation/text()" />
</xsl:attribute>
</xsl:if>
</xsl:element>
</xsl:element>
<xsl:element
name="LastModificationPerson">
<xsl:element name="IDs">
<xsl:for-each
select="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:LastPersonName">
<xsl:element name="ID">
<xsl:value-of
select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:element>
</xsl:element>
<!-- Multiple InventoryAdjustmentLine based on IBCT_IAD_S count -->
<xsl:for-each
select="/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S">
<xsl:element name="InventoryAdjustmentLine">
<xsl:element name="LineNumber">
<xsl:value-of
select="infor:cast-to-normalizedstring(*:LineNumber)" />
</xsl:element>



<!-- <xsl:element name="LineNumber">-->
<!-- <xsl:value-of select="xs:integer(normalize-space(*:LineNumber))"/>-->
<!--</xsl:element>-->

<!--<xsl:element name="LineNumber">-->
<!-- <xsl:value-of select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:LineNumber)"/>-->
<!--</xsl:element>-->
<!--<xsl:element name="LineNumber">-->
<!-- <xsl:value-of select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:LineNumber)"/>-->
<!--</xsl:element>-->
xsl:element name="DocumentReference">
<xsl:element name="LineNumber">
<xsl:value-of select="infor:cast-to-normalizedstring(/*:SyncIBCT_IAD_S/*:DataArea/*:IBCT_IAD_S/*:LineNumber)"/>
</xsl:element>


<xsl:element
name="DocumentReference">
<xsl:element name="DocumentID">
<xsl:element name="ID">
<xsl:value-of
select="infor:cast-to-normalizedstring(*:DocumentReference)" />
</xsl:element>
</xsl:element>
</xsl:element>
<xsl:element
name="WarehouseLocation">
<xsl:for-each select="*:WarehousID">
<xsl:element name="ID">
<xsl:value-of
select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>
</xsl:element>
<xsl:element
name="Item">
<xsl:element name="ItemID">
<xsl:element name="ID">
<xsl:value-of
select="infor:cast-to-normalizedstring(*:ItemID)" />
</xsl:element>
</xsl:element>
<xsl:element
name="SerializedLot">
<xsl:element name="Lot">
<xsl:element name="LotIDs">
<xsl:for-each select="*:LotID">
<xsl:element name="ID">
<xsl:value-of
select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>
</xsl:element>
<xsl:if
test="*:VarianceQuantity">
<xsl:element name="Quantity">
<xsl:attribute name="unitCode">
<xsl:value-of
select="infor:cast-to-normalizedstring(*:Unit)" />
</xsl:attribute>
<xsl:value-of
select="infor:cast-to-normalizedstring(*:VarianceQuantity)" />
</xsl:element>
</xsl:if>
</xsl:element>
</xsl:element>
</xsl:element>
<xsl:if
test="*:VarianceQuantity">
<xsl:element name="Quantity">
<xsl:attribute name="unitCode">
<xsl:value-of
select="infor:cast-to-normalizedstring(*:Unit)" />
</xsl:attribute>
<xsl:value-of
select="infor:cast-to-normalizedstring(*:VarianceQuantity)" />
</xsl:element>
</xsl:if>
<xsl:element
name="Facility">
<xsl:element name="IDs">
<xsl:for-each select="*:WarehousLocation">
<xsl:element name="ID">
<xsl:attribute name="sequenceName">
<xsl:value-of
select="infor:cast-to-normalizedstring(string(ancestor::node()[1]/*:FacilitySequenceName))" />
</xsl:attribute>
<xsl:value-of
select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:element>
<xsl:for-each
select="*:ReasonCode">
<xsl:element name="ReasonCode">
<xsl:value-of select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>

<xsl:for-each
select="*:AdjustmentDateTime">
<xsl:element name="TransactionDateTime">
<xsl:value-of select="infor:cast-to-normalizedstring(.)" />
</xsl:element>
</xsl:for-each>


<xsl:element name="UserArea">
<!-- LastPersonName ?? ?? ?? -->
<xsl:if test="*:LastPersonName">
<xsl:element name="Property">
<xsl:element name="NameValue">
<xsl:attribute name="name">ln.cdf_bpco</xsl:attribute>
<xsl:attribute name="type">StringType</xsl:attribute>
<xsl:value-of select="*:LastPersonName"/>
</xsl:element>
</xsl:element>
</xsl:if>

<!-- DocumentReference ?? ?? ?? -->
<xsl:if test="*:DocumentReference">
<xsl:element name="Property">
<xsl:element name="NameValue">
<xsl:attribute name="name">ln.cdf_cono</xsl:attribute>
<xsl:attribute name="type">StringType</xsl:attribute>
<xsl:value-of select="*:DocumentReference"/>
</xsl:element>
</xsl:element>
</xsl:if>
</xsl:element>








</xsl:element>

</xsl:for-each>
</xsl:element>
</xsl:element>

</xsl:if>
</xsl:element>
</xsl:if>
</xsl:template>

<xsl:function name="infor:cast-to-integer">
<xsl:param name="input" />
<xsl:variable name="normalized" select="normalize-space($input)" />
<xsl:choose>
<xsl:when test="$normalized castable as xs:integer">
<xsl:value-of select="xs:integer($normalized)" />
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="'0'" />
</xsl:otherwise>
</xsl:choose>
</xsl:function>
<xsl:function name="infor:cast-to-normalizedstring">
<xsl:param name="input" />
<xsl:value-of
select="fn:translate(fn:string($input),'&#xa;&#xd;&#x9;', '&#x20;&#x20;&#x20;')" />
</xsl:function>
</xsl:stylesheet>

---

Transformed Output:

The transformed BOD output appears as follows:

<?xml version="1.0" encoding="UTF-8"?>

<ProcessInventoryAdjustment

    xmlns="">schema.infor.com/.../2"

    xmlns:xs="">www.w3.org/.../XMLSchema" releaseID="9.2">

    <ApplicationArea

        xmlns="">

        <Sender>

            <LogicalID>infor.file.fcp-ib-hpio</LogicalID>

            <ComponentID>External</ComponentID>

            <ConfirmationCode>OnError</ConfirmationCode>

        </Sender>

        <CreationDateTime>2025-03-09T01:26:22.795Z</CreationDateTime>

        <BODID>infor.file.fcp-ib-hpio:1741483582795:a54bdb61-8056-42ed-ad16-1d66bd6df197</BODID>

    </ApplicationArea>

    <DataArea>

        <Process>

            <AccountingEntityID accountingEntity="1105">1105</AccountingEntityID>

            <LocationID location="S_1105">S_1105</LocationID>

            <ActionCriteria>

                <ActionExpression actionCode="Add"/>

            </ActionCriteria>

        </Process>

        <InventoryAdjustment>

            <InventoryAdjustmentHeader>

                <DocumentID>

                    <ID accountingEntity="1105" location="S_1105"/>

                </DocumentID>

                <LastModificationPerson>

                    <IDs>

                        <ID>test2</ID>

                    </IDs>

                </LastModificationPerson>

            </InventoryAdjustmentHeader>

            <InventoryAdjustmentLine>

                <LineNumber>100</LineNumber>

                                    

                                    

                                    

                        

                        

                        

                                    

                                    

                                    

xsl:element name="DocumentReference"&gt;

                            

                <LineNumber>100</LineNumber>

                <DocumentReference>

                    <DocumentID>

                        <ID>test</ID>

                    </DocumentID>

                </DocumentReference>

                <WarehouseLocation>

                    <ID>W_W012</ID>

                </WarehouseLocation>

                <Item>

                    <ItemID>

                        <ID>PRO01KR2204_C</ID>

                    </ItemID>

                    <SerializedLot>

                        <Lot>

                            <LotIDs>

                                <ID>5154</ID>

                            </LotIDs>

                            <Quantity unitCode="EA">10</Quantity>

                        </Lot>

                    </SerializedLot>

                </Item>

                <Quantity unitCode="EA">10</Quantity>

                <Facility>

                    <IDs>

                        <ID sequenceName="Location">00000000</ID>

                    </IDs>

                </Facility>

                <ReasonCode>R07</ReasonCode>

                <TransactionDateTime>2025-01-01T23:53:35.277Z</TransactionDateTime>

                <UserArea>

                    <Property>

                        <NameValue name="ln.cdf_bpco" type="StringType">test2</NameValue>

                    </Property>

                    <Property>

                        <NameValue name="ln.cdf_cono" type="StringType">test</NameValue>

                    </Property>

                </UserArea>

            </InventoryAdjustmentLine>

        </InventoryAdjustment>

    </DataArea>

</ProcessInventoryAdjustment>

---

Request for Assistance:

Even though the LineNumber is clearly present in the transformed XML, LN still throws an error saying the Line field is required.

• Could this be an issue with how the LineNumber is being mapped?
• Is there a specific structure required by LN that I might be missing?
• What debugging steps would you recommend?

I would greatly appreciate any guidance!

0712131256598360.doc

Kiran Kolluri

You can test the generated output bod with tlbct3232m000 session and debug to check.

0904080826502268.xls