Skip to Content
0
Former Member
May 29, 2014 at 10:19 AM

DTW-purchase order with multiple lines fails

362 Views

Good morning All,

here is my issue , i created a dtw template for purchase orders, the import works fine and is loaded into the database , when i did basic checks on the import i noticed that none of the POs that have multiple lines were imported properly , no matter how many lines are in my template , i get one line per PO in SBO , did anyone encounter the same issue ?

here is a sample of the template :

OPOR :

RecordKey DocNum DocType DocDate DocDueDate CardCode NumAtCard DocCurrency DocRate Comments DiscountPercent FederalTaxID RecordKey DocNum DocType DocDate DocDueDate CardCode NumAtCard DocCur DocRate Comments DiscountPercent LicTradNum 1 1 dDocument_Items 20140220 20140220 S0319 37 MXN 0

POR1 :

recordkey ParentKey LineNum ItemCode ItemDescription Quantity Currency WarehouseCode AccountCode ProjectCode TaxCode WTLiable DeferredTax MeasureUnit Linetotal recordkey DocNum LineNum ItemCode Dscription Quantity Currency WhsCode AcctCode Project TaxCode WtLiable DeferrTax unitMsr Linetotal 1 1 0 CON(NOI) 3 MXN 1 615250 897 V16_R tNO tNO 409.5 1 1 1 CON(NOI) 3 MXN 1 615250 897 V16_R tNO tNO 409.5 1 1 2 CON(NOI) 20 MXN 1 615250 897 V16_R tNO tNO 1862.2 1 1 3 CON(NOI) 20 MXN 1 615250 897 V16_R tNO tNO 1482.6

i use SAP BUSINESS ONE V8.8 PL 19

thank you in advance for your help.

Best Regards,

M