Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP Budget Iss...
Microsoft Dynamics GP (Archived)

Dynamics GP Budget Issue: Budget Import from excel not recognizing existing accounts in GP

(0) ShareShare
ReportReport
Posted on by Terry Khu 60

Operating in GP 2010 with SP 2.

 

Importing excel budgets into GP using the Budget Wizard two issues arise that I can't figure out :

After running the export to compare to the import file I've noticed the following:

 

1) For some reason some select accounts, that I have verified exist and are active in GP, do not seem to upload from the excel import [ I'm using the template from prior year although accounts have changed according so I hope this crosses off the template being an issue ]

 

2) The accounts that do upload properly appear to be a mix match of inactive accounts and active accounts, thus making it hard for me to understand what the issue might be.

 

Any thoughts?

 

Thank you for your help in advance!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Dynamics GP Budget Issue: Budget Import from excel not recognizing existing accounts in GP

    Hi Terry,

    Nothing springs to mind. I would start with a check links against the Financial master tables - to rule out anything there. I would take one of the accounts that gets rejected and try and manually add it to the budget in GP. Then I would check the format of the relevant field in the XL sheet against the same field for a line that imports fine. I might then save the XL budget as a CSV file and open it - check one of the troublesome accounts and see if it looks different to one of the good ones.

    After that, I don't know. One of those issues where you would need to be looking at the system!!

    Post after you try the above.

    Ian.

  • Terry Khu Profile Picture
    Terry Khu 60 on at
    Re: Dynamics GP Budget Issue: Budget Import from excel not recognizing existing accounts in GP

    Ian,

    Thanks for the help! Getting closer but for some reason my Revenue accounts do not want to upload and I have verified them active? I also have the occasional expense account that does not want to upload as well.

    Any thoughts?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Dynamics GP Budget Issue: Budget Import from excel not recognizing existing accounts in GP

    Hi Terry,

    Try exporting a blank budget - and copy in the values from your existing budget spreadsheet...and then reimporting. Do you still get the same errors?

    Ian.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans