Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
7%
1500 - 2000 GB
13%
> 2000 GB
23%
Total votes: 69

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th February 2019, 17:14
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 144
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
BACS payment file in UK
Baan: Other/Unknown

Is there anyone in the UK using BACS file output from baanIV to upload payments that would be willing to provide some feedback or sample files? We just started this and NatWest is rejecting the file we are trying to upload which is standard baan output.
You can contact me through PM if you don't want to provide info here directly.
__________________
Gary
Reply With Quote
  #2  
Old 22nd February 2019, 21:08
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 193
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
I ended up replacing most logic in the report script with my own code in Baan4 and LN since the standard version wasn't exactly what we needed.

Biggest issue that we encountered for HSBC was that the record lengths needed to be variable for the header (80) and standard/contra lines (100) so used a custom device and 3gl program to post process the file to remove invalid characters for BACS and to write the line with a fixed length based on line type. The same script can handle archiving created files and movement to a different location on the server.

Another issue was that we could only post on a BACS working day. We created a calendar for BACS with the valid days identified as working days. The report script read this calendar and posted on the next valid working day.

We also replaced the separate fields in the standard BACS report with a single field for each line with the separate fields concatenated in the report script. Made it easier to format based on the requirements.


Another option is to create the file using seq* statements in the report script with the location and name that you need and ignore the layout fields completely. This way, you can manage the record length from within the report script (fixed strings at 80 and 100 characters) and optionally send the file to a client or FTP location. You still need a BACS device and script to remove the file (probably empty) that's created by default from the report to allow for reposting if needed.
Reply With Quote
  #3  
Old 22nd February 2019, 21:18
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 144
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
Thanks for the reply
We found the same issue with the std report being 100 characters long for each layout. We modified the layouts by removing the 20 character filler field Infor added to each.

Strange thing now is that even though Natwest keeps rejecting the file, we are in the process of changing over to HSBC and they accepted a test file no problem.
Guess we shall see once we switch over for real.
__________________
Gary
Reply With Quote
Sponsored Links
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 11:35
Return value -2 on seq.open mmtmalone Tools Development 2 8th January 2014 22:03
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 09:22
CMG - payment file in csv format pjohns Finance, Invoicing and Integration 2 7th November 2003 10:36


All times are GMT +2. The time now is 10:58.


©2001-2018 - Baanboard.com - Baanforums.com