Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2003, 11:55
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
electronic payments

Hi,

We are using a third party software for all our electronic payments to our bank.

We would like to eliminate the double entries (payment details entry into baan + into the third party software), by establishing a link between BaaN and the other software, more specifically by importing an ASCII file from Baan, containing all the relevant payment details.

What I am looking for is detailed documentation on how to create the relevant ASCII files in BaaN (in the module Electronic Bank Statements?).

Thanks.

Erik
Reply With Quote
  #2  
Old 19th August 2003, 21:43
pfsilva's Avatar
pfsilva pfsilva is offline
Member
 
Join Date: Apr 2002
Location: Portugal
Posts: 91
pfsilva is on a distinguished road
Baan: BaanIVc4 -
HI,
You dont need to use electronic bank statements to generate in Baan an ascii file that can be read by an external software.
You just have to define in the payment method that the output ís a file, and associate a combination of report and group report the format of the file you want and the kind of data you need (this data comes mainly from tfcmg403). Then you define the path where to put the file and the file name in data bank by payment method.
When you compose payments the system generates the file.
Then what you have to do is to pick up the file from that directory and read it with your external software.
Hope this will help.
Regards,
Pedro
Reply With Quote
  #3  
Old 22nd April 2005, 21:25
tnzabo's Avatar
tnzabo tnzabo is offline
Senior Member
 
Join Date: Jul 2002
Location: Butler
Posts: 189
tnzabo is on a distinguished road
Baan: BaaN IV C4 - DB: SQL Server 2005 - OS: Windows 2003 SP2
Using ACH and electronic payments

Pedro - or anyone reading ~
Have you been able to successfully use use the Payment method with an output type as file? It seems to me there maybe a lot of setup before you can actually do it. I've created a new Payment Method(ACH) and set the output type to file. I think I need to then pick one of my suppliers, for testing, and change their payment method to ACH. Then will I need to create some dummy invoices for that supplier so I can then pay them? Is that all I'll need to do? Oh - I also when into the session Maintain Data by Bank/Payment Method and put a path and file name in there so the file has somewhere to go. What else needs to happen for this file to be created. Oh - I also wonder, the file that is created - is it just a delimited file of the report that is run from the session that you put in the Sess for Payments/Reciepts fields on the Payment Method record? Could I essentially create a report with only the fields that my banks software is expecting and use that report in that field?

Thanks,
Nikki


Get Yourself a free Flat Screen Monitor, Check out this link!!http://users.zoominternet.net/~tnzabo/getit.html

Last edited by tnzabo : 9th September 2005 at 18:41.
Reply With Quote
Sponsored Links
  #4  
Old 25th April 2005, 16:26
Judy Miller Judy Miller is offline
Member
 
Join Date: Sep 2004
Posts: 78
Judy Miller is on a distinguished road
Baan: Baan IV - OS: SQL
Electronic banking documentation

I did a presentation at the Baan Users group last year on ACh payments. Attached is the presentation which includes documentation. Hope this helps.
Attached Files
File Type: ppt BWU ACH Payments 10.2004.ppt (813.5 KB, 235 views)
__________________
Judy Miller
Senior Consultant
CrossroadsRMC
Reply With Quote
  #5  
Old 25th April 2005, 16:51
tnzabo's Avatar
tnzabo tnzabo is offline
Senior Member
 
Join Date: Jul 2002
Location: Butler
Posts: 189
tnzabo is on a distinguished road
Baan: BaaN IV C4 - DB: SQL Server 2005 - OS: Windows 2003 SP2
Thanks Judy!! This looks to be lots of help! Thanks!!

Nikki


Get yourself a Free Flat Screen Monitor - Check out this Link!!!
http://users.zoominternet.net/~tnzabo/getit.html

Last edited by tnzabo : 9th September 2005 at 18:42.
Reply With Quote
  #6  
Old 25th April 2005, 19:29
tnzabo's Avatar
tnzabo tnzabo is offline
Senior Member
 
Join Date: Jul 2002
Location: Butler
Posts: 189
tnzabo is on a distinguished road
Baan: BaaN IV C4 - DB: SQL Server 2005 - OS: Windows 2003 SP2
Success!!

I've been able to successfully create the bank file!! Thank You!!

Nikki


Get yourself a Free Flat Screen Monitor - Check out this Link!!!
http://users.zoominternet.net/~tnzabo/getit.html

Last edited by tnzabo : 9th September 2005 at 18:42.
Reply With Quote
  #7  
Old 27th May 2005, 02:37
Abuibra Abuibra is offline
Senior Member
 
Join Date: Feb 2002
Posts: 223
Abuibra is on a distinguished road
Baan: Baan IV C4, BaaN Vc - DB: Oracle - OS: Windows 2000
More help needed

Hi Guys,

It is nice to here some success story; Couple of questions to Judy & tnzabo;

1. Do we have to change the report layout of the ASCII file, now which report layout do we change is it the report which belong to session tfcmg1260m000 or another. (I have attached the bank's import file which is a bit different from the baan report layout and also they require it in a standard CSV format, any suggestions, thanks)

2. Now how does the bank software pickup this file from the baan server, where is the link, is it in BaaN or when the bank software is being run?

Appreciate any quick commments on this.
Reply With Quote
  #8  
Old 27th May 2005, 02:45
Abuibra Abuibra is offline
Senior Member
 
Join Date: Feb 2002
Posts: 223
Abuibra is on a distinguished road
Baan: Baan IV C4, BaaN Vc - DB: Oracle - OS: Windows 2000
I have attached the Bank's Format file

Hi Guys,

I forgot to attach the Bank's Format file, which I have now.

Thanks
Attached Files
File Type: doc Bank Import File Layout.doc (20.5 KB, 82 views)
Reply With Quote
  #9  
Old 27th May 2005, 13:19
tnzabo's Avatar
tnzabo tnzabo is offline
Senior Member
 
Join Date: Jul 2002
Location: Butler
Posts: 189
tnzabo is on a distinguished road
Baan: BaaN IV C4 - DB: SQL Server 2005 - OS: Windows 2003 SP2
ACH Payments

Hello,

So far we haven't gone any further than getting that file created. You can use the report that Baan already has or modify to look just like what your bank is expecting just by creating a new report layout. The report on our system that is creating the file is from session tfcmg1260s000 Transfer Payments and is the report tfcmg1260f1000 ACH Formatted File. It already pretty much what our bank is looking for, just some minor adjustments. You need to setup the supplier as an ACH payment supplier and when you print their checks it will automatically create this. Look at Judy's documentation for instructions here. As far as the bank getting your file - I suppose they would a system of getting it from you or a way for you to upload it. Again, we have not gotten to that part yet.

We are also working on a reconciliation file to upload to our bank that I've modified the report that prints out our checks and it will create a record in a flat file for each check that is printed then this file will be transferred to the bank for reconciliation when our suppliers cash the checks. Pretty slick.

If you would like anymore info feel free to contact me nikki.zablocki@oberg.com

Thanks,
Nikki

Last edited by tnzabo : 27th May 2005 at 13:30. Reason: Forgot report name
Reply With Quote
Reply


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
How to easily finding advanced payments p.cole Finance, Invoicing and Integration 3 15th September 2003 15:26
"Not all payments processed" Erik Konrath Finance, Invoicing and Integration 1 15th May 2003 16:04
Electronic Bank Payments In France And Italy cstanley Finance, Invoicing and Integration 0 24th October 2002 13:12
electronic payment system mrviwat Miscellaneous 1 24th April 2002 15:44
Electronic Bank Statements tritonian Finance, Invoicing and Integration 8 20th March 2002 12:12


All times are GMT +2. The time now is 13:46.


©2001-2017 - Baanboard.com - Baanforums.com