Our company in Germany is looking to use an Internet payment/approval system supplied by their bank. Part of the process involves creating a DTAUS export file from Baan.

How do I create an export file in the format specified by the bank. I have attached a file which gives an example of how the file should look. There is also a document explaining the format but this is too big to attach, if it would be of any help I can email the file (500k zipped) direct.

I've looked at session tfcmg5104m000 but I'm unsure if; a) this is the correct session to use and b) if I can generate a file in the desired format.

Any help will be greatly appreciated.

Thanks

PJ

Hello,

tfcmg5104m000 is for the opposite way, from bank to baan.

You have to install a payment method in tfcmg0140m000 with tfcmg1260s000 where the report is in the dta-format.

greetings, Juli

Hi PJ,

As Juli says, you'll have to customise the report format of tfcmg1260s000 to suit the needs of the bank.

Hello,


Maria, that is not really correct, because for the session exit a german report layout for DTA. So first check e.g. nr. 16, and then if it doesn't fit, then you have to customise, but usually it is ok.

Bye, Juliane

Thanks for the info Juli.

:)

Thanks for your quick replies.

So you saying that the payment method is set-up in tfcmg0140m000 and the tfcmg1260s000 is the subsession that will create the output.

I am not a Finance person and I know that my finance person may not have a very good idea on how to set-up this session. Some fields are straight forward to complete. But others I'm not sure about, report groups on form 1 and then most of form 2.

Can you please give any advise on using this session.


Juli, what do you mean by first check nr16?

Thank you

PJ

Hi,

Juli is refering to report number 16 which is attached to the session. It is specifically for Germany. This will also be the report group that you use on form 1.


Form 2:

Composing Option = Invoices
Composing Limit = 99
Composing Action = Remittance
Number by = Documents (but this depends how you wnat to do it)
Use Check Master = No
If you want to allow foreign currencies then you'd set that up and depending on your business you would can set the Payment/Receipt Steps.

Hello,

the Attachement shows you the report groups I am talking of.

When you installed the payment method, don't forget to maintain also Posting Data by Bank and Payment Method.

Bye, Juli

Hello pjohns,

for the German DTA you need to insert a payment method in the cmg master data but not with session tfcmg1260s000 but with tfcmg1261s000. There is also a report available. But the question is: do you use Baan 4 or Baan 5?????

For Baan 4 you need to implement the German Localisation, in Baan ERP the session tfcmg1261m000 (I think it is m000 in ERP-sorry but I am at home now so I can't say it exactly) is available in the standard. Are you familiar with the German "Bankleitzahl"?

If you can tell me wether you use Baan 4 or ERP I can tell you more next week (when I am in the office again).

Germanicus

Hello Germanicus,

We are using Baan 4c4.

Funny you should mention tfcmg1261s000 as I saw that in the list of sessions for Payments/Reciepts and wondered if I should be using it instead of 1260s000.

If I can see tfcmg1261s000 do I still need the German localisation?

In answer to your question - Are you familiar with the German "Bankleitzahl"? The answer is not one bit, but I think I'm about to........

I'm glad Baan can output a DTA file, when I read the technical documents the bank had sent to me I was very lost!

Thanks for the help so far I look forward to your reply in the week.

Regards

PJ

Hi again pj,

so you are using Baan 4. O. K. I will have a look if you get a correct DTA when you use the Standard (no German localisation) but I don't think so because of the "Bankleitzahl".

About the "Bankleitzahl": it is something very special in Germany - each German Bank has a specific number code (known as Bankleitzahl).
Every Bank can be identified via that code (don't mix it up with the swift code!)And it is always used for cash transactions within Germany.

The Bankleitzahl is numeric and consists of 8 digits. The Bankleitzahl of the "Pay From Bank" is written in the A- record of the DTA and the Bankleitzahl of the "Pay To Bank" is needed in the C- record.

By the way: In Germany we use the shortcut "BLZ"
for Bankleitzahl. I will make a test on my machine and let you know the results.

Germanicus

Hi pjohns,

you should be able to get a correct DTA when you use session tfcmg1261s000 with the report 1 which is the "Disketten - Begleitzettel"

The "Disketten - Begleitzettel" must be delivered to the "Pay From Bank" (in Germany we use the word "Hausbank") together with the file (disk).

To get the Bankleitzahl in the DTA you need to set the BLZ from the "Pay From Bank" and of the "Pay To Bank" as address code!!!

In Baan 4 it is functionality that the addess code is written in the DTA - so you need to set the BLZ as address code. (In ERP the functionality is a bit different.) Please try it in your test environment.

One more thing: Do you plan to do foreign payments also(from Germany to other countries)?

If so you will get in trouble without the German Localisation - because there would be specifications necessary that are not covered by the standard.

Germanicus

Germanicus,

Thanks for your help.

I will now have to sit down with my Finance guy and try and get this working.

We will be sending the file to the bank by email and not diskette does the tfcmg1261s000 session care where the output file is placed?

If I have problems do you mind if I get back to you?

Regards

PJ

Hi pjohns,

session tfcmg1261s000 just creates the file. It is a different story on which way you get it to the bank ... (but e-mail should be o. k.)

If you have problems you can post a question in this forum but I can't look at it in regular time frames. If you need urgent help - you should register a case at your local Support Center (are you supported by Baan Support Ede NL?).

It is possible that my colleagues can help you - if not they can assign your issue to the German Support Center. And then there is a 95 % chance that you get me as Support Analyst. Then I can check your DTA for errors.

Germanicus