Importing Journal Vouchers using DTW

[Former Member]

Hellow to all,

I want to import one Journal Voucher with few transactions. each transaction having few lines.

How can i link the filles:JournalEntries_Lines,JournalEntries,JournalVouchers

enyone????

[sap_beginner_ahmed]

hello > i want to import journal voucher and i apply all above steps . voucher imported successfully but only last line in entry line exel imported

[Former Member · Accepted solution]

Hello,

You need 3 files, from the DTW templates,

Hierarchy:

One Voucher can contain more JE and One Je can have more lines....

1. JournalVouchers.xlt Only recordkey goes here. (running number from 1)

2. JournalEntries.xlt You can group the journal entries within the journal voucher by Recordkey colum, into the LineNum Field you can define the individual JE-s

3. JournalEntries_Lines.xlt You should use the same recordkey and linenum values to define the lines for one JE.

So examples

importing 2 JournalVouchers

RecordKey
RecordKey
1
2

1st Voucher has 2 JE-s and the 2nd has only one

RecordKey	LineNum	DueDate	TaxDate	VatDate
RecordKey	LineNum	DueDate	TaxDate	VatDate
1	0	2009.10.01	2009.10.01	2009.10.01
1	1	2009.10.02	2009.10.02	2009.10.02
2	0	2009.10.03	2009.10.03	2009.10.03

1st Voucher 1 st JE lines, 1st Voucher 2nd Je lines, 2nd Voucher 1 Je lines

RecordKey	LineNum	AccountCode	Credit	Debit
RecordKey	LineNum	AccountCode	Credit	Debit
1	0	4910000	100	
1	0	3841000		100
1	1	4910000	100	
1	1	3842000		100
2	0	4910000	100	
2	0	3843000		100

Regards,

J.

[Former Member]

Hi

below is JournalEntries record

RecordKey	JdtNum	AutoVAT	DueDate	Indicator	Memo	ProjectCode	Reference	Reference2	ReferenceDate	Series	StampTax	StornoDate	TaxDate	TransactionCode	UseAutoStorno	VatDate
RecordKey	JdtNum	AutoVAT	DueDate	Indicator	Memo	ProjectCode	Reference	Reference2	ReferenceDate	Series	StampTax	StornoDate	TaxDate	TransactionCode	UseAutoStorno	VatDate
1		tNO	20050104				1	2	20050104	23	tNO	20050104	20050104		tNO	20050104
2		tNO	20050104				1	2	20050104	23	tNO	20050104	20050104		tNO	20050104
3		tNO	20050104				1	2	20050104	23	tNO	20050104	20050104		tNO	20050104

below is JournalEntries_lines record

RecordKey	LineNum	AccountCode	AdditionalReference	BaseSum	ContraAccount	CostingCode	Credit	Debit	DueDate	FCCredit	FCCurrency	FCDebit	GrossValue	LineMemo	ProjectCode	Reference1	Reference2	ReferenceDate1	ReferenceDate2	ShortName	SystemBaseAmount	SystemVatAmount	TaxDate	TaxGroup	VatAmount	VatDate	VatLine
RecordKey	LineNum	AccountCode	AdditionalReference	BaseSum	ContraAccount	CostingCode	Credit	Debit	DueDate	FCCredit	FCCurrency	FCDebit	GrossValue	LineMemo	ProjectCode	Reference1	Reference2	ReferenceDate1	ReferenceDate2	ShortName	SystemBaseAmount	SystemVatAmount	TaxDate	TaxGroup	VatAmount	VatDate	VatLine
1	0	_SYS00000000050		100	_SYS00000000050		100	0	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO
1	1	_SYS00000000050		100	_SYS00000000050		0	100	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO
2	0	_SYS00000000050		100	_SYS00000000050		100	0	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO
2	1	_SYS00000000050		100	_SYS00000000050		0	100	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO
3	0	_SYS00000000050		100	_SYS00000000050		100	0	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO
3	1	_SYS00000000050		100	_SYS00000000050		0	100	20050104	0		0				1	2	20050104	20050104	_SYS00000000050			20050104		10	20050104	tNO

Basic thing u want to link is RecordKey of JournalEntries with RecordKey JournalEntries_lines.

Please also refer Sample data

Thanks

Kevin

[former_member186095]

Hi,

There is sample of the templates (the files) in the DTW installation folder. you can use it as reference.

Anyway, you have posted message to wrong forum. This is SDK or technical. Your question refers the SAP B1 addon standard. Post to correct forum

Rgds,