Integration of Sage 50 with RBC - file routing record or header or file qualifier

SOLVED

Does anybody here use EFT with RBC?  RBC is asking us to enter a "file routing record" also called "header" or "file qualifier".  I called Sage but support said Sage does not need such information.  All that was needed are the Originator No., Institution No. for Returns and Account No. for Returns.  I have entered those information but our file upload fails.  The reason for the failure is "incorrect file routing record."

Has anybody banking with RBC had this problem in setting up EFT integration between RBC and Sage 50?

I'm hoping somebody can share their experience when they integrated Sage 50 with RBC.

Any information will help.

Thank you.

  • 0
    verified answer

    Hi  ,

    Thanks for reaching out. RBC might require a different file qualifier header format than what is typically provided by Sage 50. If an RBC Express agent is requesting an NL$$ in the file qualifier header instead of the standard PROD80 $$, this change may be necessary to support certain characters (e.g., French characters).

    Sage 50 typically uses the header format $$AAPDSTD0152PROD80$$ for the New Royal Bank format, and it does not include NL$$ by default, which is not required for English-only characters.

    To address this:

    1. Check RBC Requirements: Verify with RBC if a specific header format including NL$$ is required for your file upload. The format change may be necessary if you are dealing with characters beyond the standard English set.

    2. Adjust File Format: If RBC confirms the need for the NL$$ format, you may need to manually adjust the file format to " $$AAPDSTD0152[PROD[80$$ " as suggested.

    3. Review Sage Documentation: For further guidance, you can refer to this Sage Knowledgebase article and RBC PDF for more details on the correct EFT setup with RBC.

    4. Contact Sage Support: If manual adjustments are complex or you encounter further issues, reaching out to Sage Support with specific details about the error messages could help resolve the matter effectively.

    Hope this helps! Please let us know if you need more assistance.

    Warm Regards,
    Erzsi

    If this helps please mark it as verified :)

  • 0 in reply to Erzsi_I

    Thank you!  I'll do as you suggested.