+ Post New Thread
Results 1 to 9 of 9
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 ...
  1. #1
    36Degrees's Avatar
    Join Date
    Jan 2010
    Location
    Nottingham
    Posts
    1,065
    Thank Post
    165
    Thanked 153 Times in 124 Posts
    Rep Power
    52

    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!

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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:

    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.
    I believe no2 is resolved now, however no1 is still outstanding.

    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.

  3. Thanks to matt40k from:

    36Degrees (14th September 2010)

  4. #3
    36Degrees's Avatar
    Join Date
    Jan 2010
    Location
    Nottingham
    Posts
    1,065
    Thank Post
    165
    Thanked 153 Times in 124 Posts
    Rep Power
    52
    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.

  5. #4

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    Did you get anywhere with this? Having the issue ourselves now.

  6. #5

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,358
    Thank Post
    36
    Thanked 363 Times in 248 Posts
    Rep Power
    81
    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.

  7. #6

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,250
    Thank Post
    404
    Thanked 630 Times in 575 Posts
    Rep Power
    185
    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.

    :-)

  8. #7

    Join Date
    Mar 2008
    Location
    Cornwall
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Edu-IT,

    Do you remember what you did to sort this?

    Thanks,
    Tim

  9. #8

    Join Date
    Mar 2008
    Location
    Cornwall
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Phil,

    Any chance you can get an expert onto this for us?

    Thanks a lot,
    Tim

  10. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,358
    Thank Post
    36
    Thanked 363 Times in 248 Posts
    Rep Power
    81
    @ccamel - do drop me an email and I'll get someone onto it. Phil.Neal@Capita.Co.UK

SHARE:
+ Post New Thread

Similar Threads

  1. Abbey - Problem with BACS
    By russdev in forum General Chat
    Replies: 4
    Last Post: 31st December 2009, 08:20 PM
  2. backup of SIMS,FMS SQL & Docstorage
    By DarkSithBob in forum MIS Systems
    Replies: 2
    Last Post: 18th September 2009, 12:37 AM
  3. RBS-NatWest slash overdraft fees
    By cookie_monster in forum General Chat
    Replies: 9
    Last Post: 8th September 2009, 10:27 PM
  4. SIMS.Net & FMS Firewall Settings
    By Chuckster in forum MIS Systems
    Replies: 1
    Last Post: 28th July 2009, 02:33 PM
  5. Terminal Servers & FMS Client
    By mortstar in forum MIS Systems
    Replies: 2
    Last Post: 2nd October 2008, 08:59 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •