on 05-29-2006 10:38 AM
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
Hi Thibault Romieu
You don't need to put vat. But by looking at your import doc i see you have no Credit values. I think the values in the costing code are your credit values. Correct??? Wrong column. Debit and credit must sum up the right values. Also, are you using segmented accounts, if yes then the account code is wrong. If no then the account code is correct.
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.