Skip to Content
0
Former Member
Sep 08, 2011 at 06:58 AM

Content Conversion issue

24 Views

Hi,

Below is the file sample:

0LBS00000000082011090707:30:13~0000000009

4GBP55.67SB300005VISTADocNO1100DistChanPaymentDays

5001QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

5002QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

4GBP55.67SB300005VISTADocNO1100DistChanPaymentDays

5001QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

1~7

Record Type:Header Record(Always = 0),Min Occurrence:1,Max Occurrence:1

Record Type:Sales Invoice Header Record (Always = 4),Min Occurrence:0,Max Occurrence:unlimited

Record Type:Sales Invoice Item Record (Always = 5) ,Min Occurrence:1(per Sales Invoice Header Record)

,Max Occurrence:999999 (per Sales Invoice Header Record)

Record Type:Trailer Record(Always = 1),Min Occurrence:1,Max Occurrence:1

In content conversion:

Record set structure:Header,1,SalesInvoiceHeader,(Star),SalesInvoiceItem,(Star),Trailer,1

Key field name:RecordType

Header.fieldSeparator ~

Header.fieldNames RecordType,SendingSystem,FileNumber,CreationDate,CreationTime,NextFileNumber

Header.keyFieldValue 0

SalesInvoiceHeader.fieldSeparator ~

SalesInvoiceHeader.fieldNames cordType,Currency,ExchangeRate,DocumentType,Customer,VistaDocNumber,PubDiv,DistChan,PaymentDays

SalesInvoiceHeader.keyFieldValue 4

SalesInvoiceItem.fieldSeparator ~

SalesInvoiceItem.fieldNames RecordType,ItemNumber,Quantity,UoM,NetPrice,GrossPrice,PubDiv,Material,BillDate,VATAmount,VATRate

SalesInvoiceItem.keyFieldValue 5

Trailer.fieldSeparator ~

Trailer.fieldNames RecordType,RecordCount

Trailer.keyFieldValue 1

ignoreRecordsetName true

The problem is only the file sample of 1 hedaer record & N item is only picked up form FTP

0LBS00000000082011090707:30:13~0000000009

4GBP55.67SB300005VISTADocNO1100DistChanPaymentDays

5001QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

5002QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

1~7

With multiple header & line item is not working

0LBS00000000082011090707:30:13~0000000009

4GBP55.67SB300005VISTADocNO1100DistChanPaymentDays

5001QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

5002QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

4GBP55.67SB300005VISTADocNO1100DistChanPaymentDays

5001QuanUoMNetPriceGrossPricePubDiv9781444724585201109071001.1

1~7

Help needed on this.

Thnkx

Edited by: kevindass on Sep 8, 2011 8:58 AM