baantl
10th July 2008, 17:09
Hi all master,
Does anyone know how to use Imported Journal Files in LN? what is the step and which table are related? will highly appreciate for all master.
:p
Kaibou
10th July 2008, 19:46
Hello,
just have a look at solution 224291 (for FP3). Basically it is an import exchange scheme for importing financial transactions. Quite frankly, I do not use that anymore since direct import via Exchange looks more comfortable to me.
Kai
baantl
11th July 2008, 03:49
Hello Kai
is that using exchange to import into table tfgld213 then use "Post Imported Journal Transaction :tfgld2215m000" to Post it?
Kaibou
11th July 2008, 09:21
Hello Baantl,
yes that is exactly this file...
Regards - Kai
baantl
11th July 2008, 09:48
Hello Kai
i find out it have 3 tables, that is tfgld213, tfgld214, tfgld215. But how we make it as 1 csv file and import into 3 tables? how does we write any script at the exchange scheme? can exchange scheme can use for 1 csv file and import into more then one table? if exchange scheme can done it, mind to teach how to use it.
will high appreciate too all.
Kaibou
11th July 2008, 15:53
Hello baantl,
you can import via a single csv file into many tables - no matter you use the LN standard file or any self created Exchange Scheme. You do not even need to create any scripts all you have to define is which file field goes into what table. I cannot make a full description on how to use Exchange but can give you the tables that need to be filled.
tfgld100, tfgld101, tfgld018, tfgld102 and tfgld014. You will read yourself into Exchange manual or have a half day training to get started.
Regards - Kai