B1if: How to update Child Tables

[former_member568514]

I am trying to update the Min-Max fields on the Item Warehouse table OITW with B1if. In the B1 object. I have these settings

However, it will only update the first warehouse and not the selected warehouse. If I add the warehouse in the transform like this

Instead of WhsCode I used WarehouseCode with the no change. It still updates the first record.

I also added WarehouseCode to the ItemWarehouseInfo sub-section and it errors saying that it can't update this field.

Thanks

[HuanYang]

Hello Duane,

I do the test and it's OK.

Paste the code for your reference

	<xsl:template name="transform">
		<QueryParams>
			<ItemCode>A006</ItemCode>
		</QueryParams>
		<Items>
			<row>
				<ItemCode>A006</ItemCode>
			</row>
		</Items>
		<ItemWarehouseInfo>
			<row>
				<MinimalStock>15.000000</MinimalStock>
				<MaximalStock>100.000000</MaximalStock>
				<WarehouseCode>01</WarehouseCode>
			</row>
			<row>
				<MinimalStock>25.000000</MinimalStock>
				<MaximalStock>200.000000</MaximalStock>
				<WarehouseCode>02</WarehouseCode>
			</row>
		</ItemWarehouseInfo>
	</xsl:template>

thanks & best regards

Huan Yang

[ANKIT_CHAUHAN]

Hi Duane Shoebridge,

Kindly refer to SAP Note 1328706 for the same and make the necessary corrections. Probably, you will have to provide the correct "LineNum" value.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[former_member568514]

I didn't think to search the DTW area just the B1if. I read the note and looked in the B1if template and there isn't a LineNum value. The only key is <WarehouseCode> and that didn't work.