Open Forum

Expand all | Collapse all

Comdata reconcile integration

  • 1.  Comdata reconcile integration

    Posted 20 days ago
    Is anyone familiar with the Comdata vendor epayables integration? Our Finance department has reached out to Comdata and opted to utilize their "service". They are at a point of preparing and testing the Reconcile (AC28 file) import/integration. Wondering what might be the best way to do this. We use eOne SmartConnect rather then GP integration manager so we could try creating a map but I'm curious if setting up the Electronic Reconcile in GP might be better for the user.

    Thank you

    Renee Boucher
    Data System Services
    Sterling Heights MI
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Comdata reconcile integration

    Posted 19 days ago
    We've been working with Comdata for about 2 years.  We don't do anything currently with the AC28 file, but we do make use of the PS21 file.  We also use SmartConnect and have a map that writes the data from each PS21 file to a custom table in our GP database.  From there we've got a script to back-fill the comment field on each payment made through Comdate with the virtual card number.  We've also got some reconciliation scripts to confirm that comdata payments from GP have been sent to them, confirm that virtual card numbers exist on comdata payments in GP, and to check the GP payment amounts against the virtual card payment total.

    Feel free to contact me directly if you want any more details.

    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role