Skip to Content
0
Former Member
Feb 08, 2012 at 12:21 AM

CSV2B1GRPO error?

57 Views

I am trying to import data from a CSV file that holds many rows of Goods Receipt Purchase Orders (GRPO) through B1i to create GRPOu2019s in B1.

I am getting u201CB1out or BOM/BO or BS segment missing in receiver payload (handover to B1 not possible)u201D error message in the B1i Monitoring Message Log.

Below is my code. Any ideas? I have hard coded the values for testing purposes. I suspect that the child nodes are named incorrectly therefore data isnu2019t getting passed?

<b1im_multimsg xmlns="">
			<xsl:for-each select="$msg/row[position()&gt;0]">
				<B1out xmlsns="" type="object_full">
					<Control>
						<method>Insert</method>
						<objectid>20</objectid>
						<keyname>DocEntry</keyname>
					</Control>
					<Payload>
						<PurchaseDeliveryNotes>
							<rows>
								<CardCode>V1003</CardCode>
								<U_ORCFU_TRNO>123456</U_ORCFU_TRNO>
								<U_ORCFU_TMDT>2022012</U_ORCFU_TMDT>
								<U_ORCFU_TMID>774900</U_ORCFU_TMID>
								<U_ORCFU_TRTM>1410</U_ORCFU_TRTM>
							</rows>
							<Document_Lines>
								<Document_Line>
									<rows>
										<ItemCode>&apos;A1005&apos;</ItemCode>
										<ItemDescription>&apos;Unleaded&apos;</ItemDescription>
										<PriceAfterVAT>2.66</PriceAfterVAT>
										<Quantity>20</Quantity>
										<Currency>&apos;US&apos;</Currency>
										<DiscountPercent>5</DiscountPercent>
									</rows>
								</Document_Line>
							</Document_Lines>
						</PurchaseDeliveryNotes>
					</Payload>
				</B1out>
			</xsl:for-each>
		</b1im_multimsg>