MIS Systems Thread, FMS & RBS BACS Payments in Technical; Our Finance department have started to set up BACS payments but have hit a brick wall that the LEA say ...
14th September 2010, 11:25 AM #1
FMS & RBS BACS Payments
Our Finance department have started to set up BACS payments but have hit a brick wall that the LEA say they can do nothing about. Although we are also contacting Capita and RBS again I wondered if there was anyone out there who can help?
The issue they are having is that RBS claim that the file created by FMS that is sent to them is not in the correct format (the LEA says it works fine for Lloyds and the Co-Op). The finance department believe that it is because FMS isn't separating certain data entries with a comma.
Has anyone else encountered this before? I find it difficult to believe that we are the only school in the country trying to make BACS payments to RBS through FMS!
14th September 2010, 01:08 PM #2
I think your LA needs have a word with Ian Romeo-Smith (IRS) about this, someone posted about this on SupportNet, I believe the problem is:
I believe no2 is resolved now, however no1 is still outstanding.
1. Bankline will only accept a file with a 'txt' extension, which FMS does not do. This means the filename needs editing before importing it.
2. FMS adds a carriage return after the trailer line in the file. This results in an extra, blank, line at the end of the file. Bankline does not expect any data after the trailer line, so rejects the file.
Last thing IRS said on SupportNet was:
I have sent an example file to Royal Bank of Scotland (Nat West is a bank within the Royal Bank of Scotland Group), and await their reply
So it's being looked at, at least.
Thanks to matt40k from:
36Degrees (14th September 2010)
14th September 2010, 01:39 PM #3
Thanks Matt. From what I can see now I've had a chance to speak to them properly is that RBS need a comma delimited file and the one produced is tab delimited in some places and not delimited at all in others e.g. the bank's sort code has lots of other numbers after it (acct number, date, etc) in one long value.
23rd May 2011, 03:11 PM #4
Did you get anywhere with this? Having the issue ourselves now.
23rd May 2011, 04:17 PM #5
Do contact your support unit - I'm pretty sure all banks accept our formats now. If all else fails drop me a note and I'll get an expert onto it for you.
24th May 2011, 02:08 PM #6
Sorted it out myself yesterday afternoon, only by playing though. The tick box within FMS that we were told not to untick actually has to be unticked.
28th November 2011, 12:56 PM #7
- Rep Power
Do you remember what you did to sort this?
28th November 2011, 01:40 PM #8
- Rep Power
Any chance you can get an expert onto this for us?
Thanks a lot,
28th November 2011, 01:51 PM #9
@ccamel - do drop me an email and I'll get someone onto it. Phil.Neal@Capita.Co.UK
By russdev in forum General Chat
Last Post: 31st December 2009, 09:20 PM
By DarkSithBob in forum MIS Systems
Last Post: 18th September 2009, 01:37 AM
By cookie_monster in forum General Chat
Last Post: 8th September 2009, 11:27 PM
By Chuckster in forum MIS Systems
Last Post: 28th July 2009, 03:33 PM
By mortstar in forum MIS Systems
Last Post: 2nd October 2008, 09:59 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)