Electronic Funds Transfer for Payables and Payroll via Sage50 Canadian Edition

I have signed up to utilize the Electronic Funds Transfer processing that is now embedded with Sage50 Canadian edition (including signing up with SAGE and getting the necessary file transfer protocols and security tokens required to file transfer to our bank).

I have now done three file transfers (two for payables and one for payroll).

The SAGE 50 software generates a sequential file name and file creation number.

As mentioned I had done two AP file transfers, and the system generated a uniquely named file and file number for each (APDI0001 and APDI0002) and one Payroll file named PRDI0001.

I am dealing with the Royal Bank, and the bank blocked the payroll file because the file creation number was not unique (it was 0001 as was the same file creation number of the first payable file transfer I did a week ago).

How do I remedy this?  Is there something I have to toggle or turn on so the file creation number is unique regardless if generated by Payables or Payroll?

Jeff

  • 0

    Hi Jeff:

    Is it possible you sent the wrong file? The files are names are generated sequentially and with different prefixes. hope this helps!

  • 0

    This is a guess, based on working with other software feeding into the RBC system.  I think you are dealing with 2 different things here:  (1) the file name (APDI0001, PRDI0001) versus (2) the 'file creation number' embedded in the file.  It is (2) that RBC does not allow to repeat within a certain number of transmissions.  RBC does not care at all about (1), these names are just for your convenience so you can tell which one to upload.  You can check the file creation number before uploading by viewing the file with a text editor.  The first line will be in the format 000001AHRDS##########YOURCOMPANYNAME      ####2019###AAA1.  The file creation # is the four digits between your company name and the year (2019 in the example).  I'm guessing that the file creation numbers in APDI0001 and PRDI0001 are probably the same.

    If this is the case, I would see if there is a way to set a different starting file creation # for the payroll files from the AP files, essentially running two different 'cheque sequences'.  For example if you start payroll files at # 1000, then there should be no overlap as it will be a good long time before the AP system gets anywhere near 1000.