Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 7th November 2003, 08:59
pjohns's Avatar
pjohns pjohns is offline
Join Date: Aug 2001
Location: Surrey - UK
Posts: 554
pjohns is on a distinguished road
Baan: IVc4 SP31 with HiDox - DB: Oracle - OS: RHEL 5.8
CMG - payment file in csv format

We are looking at sending payment instructions to our bank in the form of CSV files using a format as defined by the bank.

We currently make payment file through the CMG module, which outputs to the German dtaus file format.

I have looked at the report types associated with tfcmg1260s000 but cannot see one which outputs to a csv format.

What are my options in successfully outputting a csv file for payment instructions.

If I cannot use the CMG module then my only other option is to create an Exchange scheme to export the data but I am unsure as to what Baan tables I will get the information from.

Any pointers will be much appreciated.


Reply With Quote
Old 7th November 2003, 09:08
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
You will have to write a custom report. In the reportscript, you will have to open a file (probably in a before.field or in before.program), and write the details to it manually (in the detail.x section). Lastly, close the file (footer section).
Reply With Quote
Old 7th November 2003, 10:36
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
report name may be different

As u also know, there are number of reports attached to session tfcmg1260s000. Though the report names may not have CSV format specifically,it could be possible that other country report layout may be in CSV format . So if u can check/test or else view those layouts at least, it's possible u get CSV format.

Or else as Nico said, add / modify a report which creates the file the way bank asks for.
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple date formats & currency formats by user. kphipps Tools Administration & Installation 6 9th November 2005 14:19
Exchange import of csv file Dwallace Tools Development 5 27th January 2004 10:33
ACH electronic payment format available for BaanERP 5.0b Han Brinkman Finance, Invoicing and Integration 0 9th October 2002 12:23
Importing Via Exchange with a CSV file Abuibra Tools Development 6 1st October 2002 17:52
Payment file from Baan to Bank..... pjohns Finance, Invoicing and Integration 13 6th February 2002 19:38

All times are GMT +2. The time now is 18:55.

©2001-2018 - -