Solved

Microsoft Dynamics GP--Migrating Excel-Based Budgets

Posted on 2013-12-03
2
505 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
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Dynamics CRM and GP 2 49
ms dynamics CRM 2011 1 66
CRM email synchronization 8 79
Moving Cash Receipts from One Checkbook ID to Another 2 51
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

815 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now