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 0POR1 :
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.6i use SAP BUSINESS ONE V8.8 PL 19
thank you in advance for your help.
Best Regards,
M