Jose Lopez
8th March 2012, 22:01
Hi all,

does some one knows if there a way to import a journal Voucher from excel spreadsheet to Baan IV
what I am trying to do is to save time and avoiding finger error posting a large journal entry manually using a kind of automatic process importing it to Baan from excel

thanks

Hitesh Shah
9th March 2012, 15:56
I believe the tables involved are tfgld213/4/5 . If you /some exchange & excel expert can populate these data in these table , u can use import journal data for this purpose.

EdHubbard
9th March 2012, 16:28
That's right. (Or you can get them into gld213 etc by a custom session for example)
When they are in tfgld213 etc you run tfgld2215m000 "Import Journal Voucher Batches by ID Number" to take them into tfgld100/101/102 as non-finalised batches.

I think you need to give them a transaction type with a fixed sequence (that is, tfgld011.iseq = yes).

I created a new transaction type to distinguish them and to achieve the fixed sequence.

Jose Lopez
10th March 2012, 00:58
Thanks a Lot

your answer are very helpfully

I'll let you know the final result once I try this