Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Import Budget from Excel - the figures are not imported

Posted on by Microsoft Employee

I export the Budget to Excel and fill the excel with my figure and save the excel file.  Then select Import Budget from Excel, but the figures are not imported to Dynamics NAV.  What is the problem?  Please help.

*This post is locked for comments

  • Suggested answer
    O-See Profile Picture
    O-See 35 on at
    RE: Import Budget from Excel - the figures are not imported

    There is a bug in CU0, which may be causing this.

    To fix this, edit report 81, and set Temporary property for DataItem "Budget Buffer" to No.

    This is fixed in CU1, I think.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import Budget from Excel - the figures are not imported

    I am having the same issue - did you ever manage to get this to work?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import Budget from Excel - the figures are not imported

    Hi John,

    I'm not using Rapid Start to import Budget.  I use Export Budget, then fill the figures and save the excel worksheet.  On budget Screen, use Import Budget.  But the figures are not showing in NAV and no error message was report.  

    Thank

    Tunji

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import Budget from Excel - the figures are not imported

    Are you using Rapid Start to import?  If so you will need to select Apply Data, on the Functions button of the Edit - Config. Package Card. After you have imported your Excel doc.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Import Budget from Excel - the figures are not imported

    Hello,

    From your request it is not clear how do you import the figures and if you are getting any errors. Try following these steps:

    Create Budgets: msdn.microsoft.com/.../hh931428(v=nav.90).aspx

    Import/Export Budgets: msdn.microsoft.com/.../hh928285(v=nav.90).aspx

    Some Tips&Tricks: dynamicsnavfinancials.com/.../tips-and-tricks-for-a-flawless-budget-load-in-nav

  • Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: Import Budget from Excel - the figures are not imported

    Can you attached excel sheet and NAV Budget Screen just get an idea what is wrong?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import Budget from Excel - the figures are not imported

    Hi Indika,

    Thanks for the suggested solution.  I followed all these steps too, the same way you suggested but when I went back to the budget in the system, the figures are not uploaded.  I think probably there is something I need to do again.  I have done these several but same result - figures are not uploaded.

    Regards

    Tunji

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: Import Budget from Excel - the figures are not imported

    Hi
    Are you getting any error while uploading the Budge? if not try below methods and see anythign you have done wrong, you can do it on below order
    1. Create Budget From NAV
    2. Go To Action and Export then assume you are trying import 2016 budget
    Start Date = 01/01/2016
    No of Periods = 12
    Period Length = 1M
    Export it.
    This will create 12 Month Budget for 2016 Dates when you are in excel you can update the figures for the budget and save and close it after that go to NAV and go to edit new budget and import from excel you can have option of Replace or Add it will work fine.
    Thanks
    Indika

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans