Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2013 budget upload with formulas

Posted on by Microsoft Employee

We have a client that has been using the same budget upload template for 8 years.  It appears that GP2013 is not allowing amounts to upload that are a formula?  They swear they've been doing this for years.  

Was there something changed in 2013?

*This post is locked for comments

  • Mike Bufano Profile Picture
    Mike Bufano 1,480 on at
    RE: GP 2013 budget upload with formulas

    Running GP 2013 SP2.  Just created an Excel  template and then populated with the formula =100+200  (for a period total of $300.00.

    Copied this formula across all periods for the same GL account.

    After I imported it, Period 1 only shows 100.00.  

    Thinks this is a bug.  Changed the Period ID from "Period 1 - 2014" to Period 1.  But got the same result.

  • Marvin Burnett Profile Picture
    Marvin Burnett 165 on at
    RE: GP 2013 budget upload with formulas

    Is there an error message being returned.  I just had a budget / excel import error yesterday and it turned out to be the period names in the excel spreadsheet. Changed them to Period 1, Period 2, etc... and all was good again.

  • Warren R. Pease Profile Picture
    Warren R. Pease 730 on at
    RE: GP 2013 budget upload with formulas

    I have had the same issue.   Only way that I found a way around it was to do a select and paste as values.  

    Warren

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans