cancel
Showing results for 
Search instead for 
Did you mean: 

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????

0 Kudos
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
View Entire Topic
Former Member
0 Kudos

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.