Open Forum

Expand all | Collapse all

Replicating a Budget ID

Jump to Best Answer
  • 1.  Replicating a Budget ID

    Posted 11 days ago
    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
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Replicating a Budget ID
    Best Answer

    TOP CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Replicating a Budget ID

    Posted 10 days ago

    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
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Replicating a Budget ID

    GPUG ALL STAR
    Posted 8 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Replicating a Budget ID

    Posted 3 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Replicating a Budget ID

    GPUG ALL STAR
    Posted 2 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: Replicating a Budget ID

    Posted 2 days ago
    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
    ------------------------------

    Conference-GPUG_200x200


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