Problem while importing 1

[pratap01]

Hello,
I am trying to import to transaction journal entry through a CSV file. It is giving me a error " Invalid fields. not in file".
Can anyone let me know what could be the problem

Thanks

 

[BigLouie]

Are you importing through VI or GL Exchange?

 

[pratap01]

Heloo BigLouie
Thanks for a prompt response

Yes i am importing through VI. i could send the screen shots of the import template that i am using

Thanks
Pratap

 

[Blorf]

Or print the job using the VI module to a text file and post the text file. Also a few samples of the records in your csv file.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[pratap01]

Import Job Definition
CC_DEPOSIT CC_DEPOSIT Import
TO IMPORT CREDIT CARD DEPOSIT TRANSACT

Configuration CompiledVIWI
Name:
Table GL_TransactionJournal
Name:
Import C:\Documents and Settings\olga\Desktop\merchdeposit.csv
File T DELIMITE Delim,
ter:
Import Fil N

Data Items
DatFie
Seq Column Nam TypTyp OperColMask Default Va

0001 SourceJournal STRSTD ASSN1.0Start: 1 LMB
0002 BatchNo STRSTD ASSN10.Start: 1 L01143
0003 EntryNo STRSTD ASSN2.0Start: 1 L
0004 PostingDate STRDAT REPL8.0M/D/Y
0005 DocRefer STRSTD REPL9.0Start: 1 L
0006 AcceptOutofBalance STRY/N ASSN8.0Start: 1 LN
0007 JournalDeleted STRY/N ASSN9.0Start: 1 LN
0008 JournalComment STRSTD RTIM11.Start: 1 L
0009 BankCode STRSTD ASSN10.Start: 1 LM
0010 CreditAmount NUMSTD REPL6.0###,###,##
0011 PostingComment STRSTD REPL9.0Start: 1 L
0012 AccountKey STRSTD REPL10.Start: 1 L
0013 OffsetAccountKey STRSTD ASSN4.0Start: 1 L1020-00-00-00-000
0014 Offset STRSTD ASSN5.0Start: 1 LD
0015 TransactionType STRSTD ASSN6.0Start: 1 LD
0016 JournalType STRSTD ASSN7.0Start: 1 LF
0017 Date STRDAT REPL8.0M/D/Y

The records from the csv file

CC No Posted Date Doc Reference Serial Number Description Credit amount CR/DR Line Postdate comment Account No
3 1/30/2006 4242903 0 VISA / MC 365 CR 1/30/2006 CC 3 1100-00-00-00-000
3 1/30/2006 4242903 0 VISA / MC 270 CR 1/30/2006 CC 3 1100-00-00-00-000
1 1/30/2006 4244024 0 VISA / MC 235 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244024 0 VISA / MC 10 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244037 0 VISA / MC 1,411.65 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244037 0 VISA / MC 869.05 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244040 0 VISA / MC 643.25 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244040 0 VISA / MC 308.85 CR 1/30/2006 CC 1 1100-00-00-00-000
1 1/30/2006 4244053 0 VISA / MC 60 CR 1/30/2006 CC 1 1100-00-00-00-000

 

[Blorf]

1020-00-00-00-000

Change to 0000-00-00-000 is first thing I see.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[pratap01]

if change 1020-00-00-00-000 to 0000-00-00-000 it gives error " not in file". of course because there is not account by that number

The earlier error message that i used get is as follows

RecNo: 0000000005 Invalid Fields. is not on file
H.sourcejournal pass MB
H.entryno pass 000579
H.batchno pass 01143
h.postingdate pass 20060130
h.acceptoutofbalance pass N
h.journaldeleted pass N
h.journalcomment pass cc importing
h.bankcode pass M
h.offsetaccountkey pass 1020-00-00-00-000
h.offset pass D
h.transactiontype pass D
h.journaltype pass F
l.docrefer pass cc 1
l.creditamount pass 10
l.postingcomment pass cc 1
l.accountkey pass 1100-00-00-00-000
l.date pass 20060130

 

[pratap01]

Please will someone be able to help me with this problem

 

[BigLouie]

In 4.XX there is now an account key which is totally different from the account number. If this is a new install where you manually created the accounts the account number and key will be totally different. My advise is to manually enter in the data in the GL then using ODBC pull the data into Excel, both header and detail and look at how the data is formatted. that should give you a good idea of how your file should look.