Hi!

We wish to interface our parallel running HR package with BaaN for Finance. One of the solution being reviwed is to create a non-finalized batch externally using Exchange Schemes.

Wish to know what are the relevant tables which need to be updated and in what
formats to load transactions in tfgld102 of Type Journal and Invoice.

Reference in mind is the BaaN functionality of Posting Integration Transaction in Finance which does the same job.

Rgds,

Himanshu

Have you had a look at the Import Journal Voucher Sessions yet?

Hi!

We have never used this functionality here and I am also not much informed abt the same.

Could you give some help in this regard. But yes on first view this does seem to be the solution I am looking for...

Problem would be in case of importing invoices as this would also involve account payable tables..

What about the Transaction orignin "External Package" in Integration Logistique Finance. But I am not sure if that works for supplier invoices.
But for that perhaps you can use EDI-Functionality.
Bye, Juli

I have zeroed down on following options:-

Interface Options

Option 1 : Regular Exchange Schemes With Job Functinality

Option 2 : Import Journal Vouchers Functionality

Option 3 : Update BaaN session with source from file

Option 4 : Electronic Data Interchange


Comments Plz..

Rgds,

Himanshu

For suppliers invoices :
-Exchange to tfacp100 Received Purchase Invoices.

For journal vouchers:
-Option 2, Import Journal Vouchers Functionality


My opinion.

himanshu,

FORMAT FOR IMPORTED ASCII FILES

when u run the EXCHANGE SCHEMES for import journal voucher functionality there are 3 tables which are updated viz., tfgld213 tfgld 214 and tfgld215 which will record your batch, document header and document lines resepectively .

The first position of each record must contain a record type identifier of B,H or L respectively to indicate the record type. The fields of each record are delimited with the '|' character.

At least one each of record types B, H and L must be present for a successful import.

For payroll purposes, the batch would probably equate to one pay period or check run.

We have been using this functionality effectively.

any other info, on this pl. revert back

sajitEXCHANGE SCHEMES

Originally posted by alejandro
For suppliers invoices :
-Exchange to tfacp100 Received Purchase Invoices.


I don't think that exchange to tfacp100 would help, because there is no booking functionality with this table. From this table you have to copy the invoice each single in the manual booking session.

Regards, Juli

Hi Sajit!

Could you plz mai me at srivastavah@dabur.com or give me your id.

Since you are using the interface with payroll you might be of gr8 help to me...

Presently i am trying to develope an update session which takes up values from a TEXT file and generates Invoice/JV . The tables that i feel are involved :

(1) Get the first free document number based on the transaction type fromthe table tfgld017(
2) Get a new batch number from the table tfgld014
3) Insert the record in the 'Batch number' table tfgld100 and tfgld101
(4) Insert the record in the Documents table tfgld018
(5) Insert the record into tfacp200
(6) Get the supplier control account from table tfacp005 (
7)Use all this information to populate all the fields if the tabletfgld102.()
(8) Update the field 'Invoice Balance' in tccom021 (
(9) Update the table tfgld017 table with the last used number(10) Update the table tfgld014 with the last used batch number.


Comments Plz....


Rgds,

Himanshu

Hello,

You were talking about integration of the HR package with Baan. Where did the Supplier control accounts come in? We have integrated an external HR package with Baan using the journal import functionality and it works pretty well.

Individual employees can be maintained as dimensions and the entries can be trigerred to fall into the proper dimensions.

regards
Sudarshan

Hi!

we need control accounts for following:

Employee bank/cash payment
One time third party payments (Eg Fuel)
Third party regular payments ( Landlord rent)

JV doesn't allow paymet processing.


Himanshu

Hi all!


thanx for your valuable comment during thiiis development phase ..

attached is the proposed set-up .. comments plz..


Rgds,

Himanshu

P.S. : plz ignore company specific irrelevant info.

attachment

Hi

Do you need to issue cheques to the employee accounts using Baan Cheque master?

If you don't then I would suggest that you don't use the ACP module for salary processing. You can create a control account for each component of your salary. Then, in all these accounts you could activate the dimension for employee where you have the name of the individual employees. Then using the JV import procedure you can import the payroll details from the HR product.
Then for making the payment you can use the maintain transactions session and process Bank payments with the payment type set to "Journal" or You can possibily import these details as well.


In this process, you can see the consolidated salary details in the ledger accounts and the individual employee-wise details through the dimension views.

Regarding the One time payment and the recurring payments to external parties these could generally be done through Baan.

This is my opinon.

Warm regards
Sudarshan