Open Forum

Expand all | Collapse all

ADP import to Recurring General Journal

  • 1.  ADP import to Recurring General Journal

    GOLD CONTRIBUTOR
    Posted Dec 03, 2019 12:59 PM
    I thought I saw something recently about importing ADP data into Navision, but I can't remember where it was or exactly what it was as at the time I wasn't focused on that. I don't remember if this was at Summit, a webinar, one of these discussions, or some other google search. Does anyone recall what I may have seen? Looking for a mind reader here :)

    Or does anyone do this already? Ultimately, I'm looking to export a CSV file from ADP and import it into General Journal. I imagine I could probably use rapid start, but that seems intimidating to rapid start into the General Journal Lines. Any suggestions on using rapid start or any other tool?

    ------------------------------
    Joshua McGee
    Information Systems Manager
    Cover-Pools, Inc
    West Valley City UT
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: ADP import to Recurring General Journal

    TOP CONTRIBUTOR
    Posted Dec 04, 2019 09:22 AM
    H Joshua,
    ADP has something that will link with NAV.  We are not yet a partner with them which I believe you must be to re-sell the product they have created. We have seen a demo and can probably give you an idea of what it will do but I don't think we are currently selling it. I have sent this post over to your account manager to get in touch with you. I will be interested to see other replies here from anyone that has already implemented!​

    ------------------------------
    Crystal Tollison
    Consultant
    ArcherPoint Inc.
    Lawrenceville GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: ADP import to Recurring General Journal

    GOLD CONTRIBUTOR
    Posted Dec 05, 2019 09:51 AM
    Thanks Crystal. I did hear from Joe. He is looking into whether this is available for Nav 2013 (I should've mentioned that's our version in my original post).

    ------------------------------
    Joshua McGee
    Information Systems Manager
    Cover-Pools, Inc
    West Valley City UT
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: ADP import to Recurring General Journal

    Posted Dec 06, 2019 05:06 PM
    Joshua,

    If you're looking for a simple export from ADP and import into NAV Gen Jnl, then I would suggest copy and paste.  You're right, Rapidstart can be a little intimidating and it's almost easier just to copy and paste into a journal entry.  I know someone who does this for their Concur output file. The only suggest I would have is to have ADP export into Excel as opposed to CSV.

    ------------------------------
    Jimmy Yu
    Enterprise Architect
    Step Energy Services Inc
    AB
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: ADP import to Recurring General Journal

    GOLD CONTRIBUTOR
    Posted Dec 09, 2019 10:15 AM
    Edited by Joshua McGee Dec 09, 2019 10:15 AM
    Jimmy, your solution works perfectly! I don't know why I didn't think to try that. I guess I assumed that you couldn't paste into a general journal.

    THANK YOU!

    ------------------------------
    Joshua McGee
    Information Systems Manager
    Cover-Pools, Inc
    West Valley City UT
    ------------------------------

    Academy - Online Interactive Learning from Experts


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