Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Integration Manager journal import from user folder

Posted on by
Hello,
I hope somebody can help with this issue.
Currently our users create Journal files that are stored in their home drive. So everybody's files are separate. Integration manager just points to the H drive that is unique to the user.
We want to move the location that the files are retrieved from from the H drive to a shared folder.
I can get the files to be created in a folder in the shared drive, with the users name as the folder, ie. j://GP//joeshmo & j://gp//moshmo instead of just h:
Is there a way that Integration Manager can be configured to look at j://gp//username (this is different for every user)? Is it possible to put a variable in to the Integration Manager configuration.
Just trying to get ahead of some planned work in the next few months.
 
Thanks,
Matt
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Integration Manager journal import from user folder
    Check this video about Excel copy / past for GL JE .
     
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Integration Manager journal import from user folder
    Hi Matt,
    the suggestion Lisa made is valid when you try to use different IM.mdb files for each users.. but I don't think that the purpose of your question.. 
     
    I'd rather wonder what version of GP are you on ? Since GP 2018, you can use Excel to copy / paste GL JE transaction directly into GP.. no need to use IM or other kind of integration anymore. 
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    Integration Manager journal import from user folder
    By default, the location of the IMD/MDB file is set for each user/workstation.  This can be difficult to manage.

    You can change the behavior to be by workstation (so you don't have to configure it each time there is a new user on a workstation) with a switch for each of the two Integration Manager INI files.  Here is a link to the Learning topic:

    Set the location of the .imd or .mdb file - Dynamics GP | Microsoft Learn

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans