Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Importing Bank Transfe...
Microsoft Dynamics GP (Archived)

Importing Bank Transfers into Dynamics GP Bank Transfer Screens

(0) ShareShare
ReportReport
Posted on by GPHouston 4

Has anyone figured out how to import Bank Transfers into GP?  I have over 350 checkbooks that transfer money to and from each checkbook... currently we enter those manually and thankfully there are not a lot of daily, but that could change... I want to be able to download the information from our bank and use some kind of a tool or ??? to import the transactions into GP and have them post as they enter... which the screen only does transactional posting so that may be the problem.  

*This post is locked for comments

  • 26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: Importing Bank Transfers into Dynamics GP Bank Transfer Screens

    Jen

    You are absolutely right. I was naive to think IM had this as a standard type.

    Thanks for correcting me.

    Best

  • Suggested answer
    ShawnMD Profile Picture
    ShawnMD 1,456 User Group Leader on at
    RE: Importing Bank Transfers into Dynamics GP Bank Transfer Screens

    Mail merge macro is the only option that comes to mind (except for 3rd party - as @Jen mentioned).  Here is a link to a blog by Redbeard that might help - I can't find the article by Leslie but maybe she will respond :) redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: Importing Bank Transfers into Dynamics GP Bank Transfer Screens

    Hi Ven,

    I don't believe Bank Transfers is a destination in IM. Bank Reconcile and Bank Transactions are, but not tranfers from what I recall. Admittedly I haven't used IM for a while as most clients I've dealt with use SmartConnect.

    The original poster may be able to use IM though by doing Bank Transactions - increase and decrease adjustments. It's not ideal, as it's 2 transactions for a transfer and you'd have to use a clearing account as an intermediary if you went that route.

    Jen

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: Importing Bank Transfers into Dynamics GP Bank Transfer Screens

    GPHouston - If your GP license comes with Integration Manager, there is a standard integration you can use to meet this requirement.

    Best Regards

    Ven

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: Importing Bank Transfers into Dynamics GP Bank Transfer Screens

    Unfortunately Bank Transfers are one of the few things that isn't available via eConnect as an import node. One thing you may want to consider depending on the complexity of your banking needs, is considering purchasing an ISV module like Nolan's Advanced Bank Rec which reconciles against the GL which opens up the possibilities to importing via regular journal entries instead of Bank Transfers.

    I realize this answer won't help with your literal question but it might open up an avenue to explore given the number of checkbooks you have.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,312 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,025 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans