Solved

Microsoft Dynamics GP--Migrating Excel-Based Budgets

Posted on 2013-12-03
2
515 Views
Last Modified: 2013-12-04
Hello:

I have worked on many projects on moving Microsoft Dynamics GP and its apps from one server to another.  But, the one item that I have never thought about is how to "move" Excel-Based Budgeting.

Sure, I can copy the Excel spreadsheets from one file share to another.  But, how do you get the GP company databases to "know" and to "communicate" with the budgets in that new file share?

TBSupport
0
Comment
Question by:TBSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 39695066
If you are using out-of-the-box functionality, there is no active communication going on between Excel budget files and GP; and GP does not have any reason to know where the files are.

Excel-Based Budgeting simply allows you to import Dynamics GP Budgets from Excel or export them out to Excel. At every step you have to specify where the Excel file is, no link is stored to it. Once the import is done, all the data is in GP, nothing in the Excel file is used by GP past the import (or export).

I often import budgets from Excel for clients and the Excel files are never even stored on their network, I have them locally on my network, copy them temporarily to the terminal server where I am importing them, then delete them when the import is done.

Hope that helps.
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39695260
Thank you, Victoria!

TBSupport
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question