Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error importing journal entries with DTW

Hello,

I have errors when I try to import Journal Entries with DTW.

My Excel files are like this :

oJournalEntries :
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
262			        20051005		FA04662262				             20051103

						
oJournalEntries_Lines:
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
262		        401000045					                     0.00	        444.07						HA Ipaq													
262		        608700000					                     23.50	0.00						HA Ipaq										D4			
262		        607000000					                     347.80	0.00						HA Ipaq										D4			
262		        445660000					                     72.77	0.00						HA Ipaq					

I can't find where is my error, DTW gives some errors, but they are not very comprehensible.

Do I have to put the VAT line?

Are the BP and account codes in the same column (AccountCode)?

Thanks for your answer.

Thibault

Not what you were looking for? View more on this topic or Ask a question