Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Budget entry for new fiscal year updates other years

Posted on by Microsoft Employee

Hi all - 

My question pertains to GP 2013 but I think it works the same way in other versions too. It seems like when an existing budget is selected (Cards>Financial>Budget) and the new fiscal year is selected to enter budget amounts, it updates the prior years with that new year's budget amounts. I would think the same budget ID could be used and for each fiscal year have unique budget amounts. Otherwise having to always create new budget IDs for every new year would be very cumbersome. 

Please let me know if I'm missing anything. 

Thank you all!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Budget entry for new fiscal year updates other years

    that helps Bill. Thanks.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Budget entry for new fiscal year updates other years

    Diop, it has more to do with how the data is stored in the system rather than the how it is distributed out over the periods.

    The budget is made unique by the Budget ID and not by the Year.  The Year is a field in the Budget ID.

    The other reason for a budget per year is that then you can display on a single report more than one budget per row of data.

    Anyway - that should be enough.  You understand why, hope this helps a bit.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Budget entry for new fiscal year updates other years

    Hi Mahmoud - I perfectly understand and agree with your solution, and I'll use it.  I was just trying to understand the logic behind a new budget id for each new year, but maybe I'm over-thinking it. What I would just love to see is to just use the same budget ID, select the year to maintain and the gl codes (or use the export/import feature) without affecting any other year. And on financial reports, just select the same budget ID and the year to report on. This would avoid creating a new budget ID for each year. But unfortunately it doesn't work that way and I accept :-)

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Budget entry for new fiscal year updates other years

    I didn't say that it is not possible :)

    I was just proposing a method of creating a budget on the fly by considering a specific year's budget. In Dynamics GP; as I remember it was GP 10, a new feature was introduced to create a budget either for a specific fiscal year, or a date range.

    If you pick the date range option, you can select the range you want across multiple fiscal years. Here is an article which shows the details on Creating Budgets That Span Multiple Periods

    If you use the excel wizard and pick a date range across multiple fiscal years, the exported excel sheet will include your selective accounts for the budget in separate sheets, each for one year.

    Let us know if you do have any further inquiries,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Budget entry for new fiscal year updates other years

    Thanks Mahmoud -

    I'm trying to understand the logic behind the reason why a single budget cannot be used for different fiscal years. Is it because of the possibility to enter a budget for a date range that crosses through more than one year and if GP worked the way I originally thought (ie. if it allowed the same budget ID to be used different fiscal years rather than creating one for each year), it would have different budget amounts for the same period and THAT is impossible.

    Thank you all again!

    Oumar

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Budget entry for new fiscal year updates other years

    Hello,

    You may use the Budget wizard for Excel to create a new budget based on an existing budget

    2821.Untitled.png

    Let us know if you have any further inquiries,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Budget entry for new fiscal year updates other years

    Hi Babu - thanks for the answer! that's what I suspected. Because it's for NFP with dozens of programs and a budget for each program, they have many budgets for a single year. I will use the import feature.

    Oumar

  • Verified answer
    RE: Budget entry for new fiscal year updates other years

    Hi,

    You need to use new budget ID for each year.  You can export your existing budget into excel and import it back with new number onto a new budget ID.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans