Open Forum

Expand all | Collapse all

Replicating a Budget ID

Jump to Best Answer
  • 1.  Replicating a Budget ID

    Posted Nov 04, 2019 12:44 PM
    Is there an easy and efficient way to duplicate a Budget ID, so that changes and modifications do not impact the original version?  For example, if I have Budget ID 'Budget 2020", how can I create "Budget 2020 version 2" to make changes, but also to be able to compare Actuals vs Budget #1 vs Budget #2 in MR using different column definitions.  Thoughts?​​

    ------------------------------
    Chris Pang
    Financial Planning and Analysis Manager
    GEE Group, Inc.
    Jacksonville FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Replicating a Budget ID
    Best Answer

    TOP CONTRIBUTOR
    Posted Nov 04, 2019 12:50 PM
    You can use the import/export functionality in Budgets to quickly create a new budget from an existing export.

    ------------------------------
    Matthew Arp
    Business Systems Developer
    Hunton Group
    Houston TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Replicating a Budget ID

    Posted Nov 04, 2019 01:39 PM

    Thanks Matthew for the suggestion.  I'm more or less following these steps, I presume?

    https://www.fmtconsultants.com/the-best-way-to-easily-update-your-budget-in-microsoft-dynamics-gp-step-by-step-instructions/ 



    ------------------------------
    Chris Pang
    Financial Planning and Analysis Manager
    GEE Group, Inc.
    Jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Replicating a Budget ID

    GPUG ALL STAR
    Posted Nov 07, 2019 10:59 AM
    Correct Chris!
    In my previous company that was exactly how the budget manager would do it.. For every new FY she would create an annual forecast budget, and then revise it quarterly by using the annual or previous quarter and updating the numbers. So you'd end up with 4-5 budgets in GP like Budget-2019, Budget-2019-Q1, etc..

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Replicating a Budget ID

    Posted Nov 12, 2019 01:12 PM
    Thanks @Matthew Arp and @Beat Bucher!

    Was such a painful way ​​of mass modifiying a budget, particularly when revenue changed, COGS, Commissions and Employee taxes also had to change...  but never the less, it did work.

    ------------------------------
    Chris Pang
    Financial Planning and Analysis Manager
    GEE Group, Inc.
    Jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Replicating a Budget ID

    GPUG ALL STAR
    Posted Nov 12, 2019 02:00 PM
    Hey Chris,
    Your question actually triggered a blog post from @Jen Kuntz today:-)
    https://jenkuntz.ca/2019/11/how-to-copy-budgets/

    That's how the community helps each others. ​

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Replicating a Budget ID

    Posted Nov 12, 2019 03:04 PM
    That's awsome!  Thanks @Jen Kuntz for breaking it down and simplifying the steps for us.​

    ------------------------------
    Chris Pang
    Financial Planning and Analysis Manager
    GEE Group, Inc.
    Jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


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