Open Forum

Expand all | Collapse all

Budget

  • 1.  Budget

    Posted 5 days ago
    ​​Hi there, I am new to Budget and am curious if it wrecks anything if I delete old budgets?  It is a very messy screen as we have decades of budgets in this window.  Do they need to be saved year after year?

    ------------------------------
    Carryn Berk
    Saskatchewan Blue Cross

    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Budget

    Posted 5 days ago
    Hi Carryn,

    It won't hurt anything, but I would make sure that no one else is utilizing the data before deleting. You never know who might be looking at historical budgets.


    ------------------------------
    George Kuntz, MSc
    Support Analyst
    Si Systems
    Calgary
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Budget

    Posted 5 days ago
    Thank you so much!​

    ------------------------------
    Carryn Berk
    Saskatchewan Blue Cross
    Martensville SK
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Budget

    Posted 5 days ago
    You are most welcome.

    ------------------------------
    George Kuntz, MSc
    Support Analyst
    Si Systems
    Calgary
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Budget

    SILVER CONTRIBUTOR
    Posted 5 days ago
    Hi @Carryn Berk,

    What I'm about to say is probably implied/inherently included in @George Kuntz, MSc, but better safe than sorry.... specifically I'd take a realistic look at how far back your company does budget to actual comparisons - SSRS, SmartList, Management Reporter, Prospero, Jet Reports, etc.  Most of these tools will pull from the budget tables to do budget to actual/variance reporting.

    So if you delete the budgets, you might consider doing it on some kind of rolling schedule so you can make sure you have enough historic budgets for the historic/comparative data reporting.   I'd also recommend exporting the budgets or archiving them somewhere (can be external to GP) "just in case."

    Thanks,

    Samantha ​​​

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Budget

    GPUG ALL STAR
    Posted 5 days ago

    Carryn,

    Exporting the budgets out through GP using the budget Excel exporter can be a very slow and painful process.

    here is a link to a script you can use to export all of your historical budgets in a matter of seconds.
    Ask your IT or financial analyst to help you run or install these SQL views.

    https://www.gpug.com/viewdocument/fast-budget-export?CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=librarydocuments


    Feel free to ping me directly if you need assistance.

    Zubin



    ------------------------------
    Zubin Gidwani
    Founder
    Dynamic Budgets
    San Francisco-Bay Area CA
    ------------------------------

    Conference-GPUG_200x200


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