I would like to import entries which are required to enter every month for payroll.

These entries should be added into tfgld102 and their respective tables.

Is anyone had done similer task.

Baan Version Baan4c
Database tbase6.1



Shrikant

Hi,
Yes I've done this already for a few times.
You should import a file to tables tfgld213, tfgld214 and tfgld215 and then run session tfgld2215m000.
If you need I can send u an example of a type of exchange scheme that is performing this. As u may know the fields in the file and the type of complexity on the exchnage sheme depends on the type of information and the format of file you can generate from the software that is processing wages.
Regards,
Pedro F.Silva

Dear Shrikant,

Would you like to look into the possibility of using AFS? AFS is an instruction set provided by Baan so that you can remotely control BaanERP sessions from within or outside BaanERP itself. This is a very safe way for customisation as all the logic involved in the process you would want to customise are executed too. There is a separate forum in this board for AFS (http://www.baanboard.com/baanboard/forumdisplay.php?s=&forumid=59) where you can get many help from different people experienced in AFS

Rgds,
Paul

I am able to create text file as required by tfgld102. ( i.e. Non Finalised transaction) . But I am doubtful about how the document number is generated and how the effects will be
posted to other relative tables.

Correct me if I am wrong, I was only thinking to import the table tfgld102.


Thanks

Shrikant

There is an import journal voucher session which is already created in Baan. As Pedro mentioned this works of tables tfgld213, 214, 215. An exchange scheme is used to populate these tables and the sessions will create the tfgld102 entries for you.

You cannot just import data into tfgld102 as there are other tables eg. tfgld018, tfgld100, tfgld101 which need to be populated to create a finance batch. As you say to generate document numbers will require some programming.

Yep - Baan released JVIMPORT, a sample exchange scheme with documentation that does this that you can use at least to start with. Then run the standard Import Journal Transactions (tfgld2215m000) to create the gld entries from the import tables.

Check solution # 155541 on the Baan support site.

Hi Shrikant,
Please let me know your email where I can send the examples you asked me for.
Thx.
Pedro