web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Amount is coming up as...
Microsoft Dynamics GP (Archived)

Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

(0) ShareShare
ReportReport
Posted on by Community Member

In GP 2015 when I go to Cards, Budget, select the budget, and Open Using Dynamics GP and search an account number, the amount displays as 0.00 for each period and the total. I don't know what I'm doing wrong. In the excel document in Cards, I have the account number, description, 12 periods, and then a total column. How do I get GP to read that total column and the column for each period?

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

    Have you completed the process by importing this budget into GP?  If so, I have seen instances where if I imported from an xls file it would work as opposed to an xlsx file.

  • Community Member Profile Picture
    Community Member on at
    RE: Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

    It won't let me import it as an .xls file. When I try and do import from excel, the only file option it gives me is .xlsx and it won't allow me to change it.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

    Did you build this spreadsheet using GP and then populate it? Have you tried using a different computer?

  • tjr2jtr2 Profile Picture
    tjr2jtr2 117 on at
    RE: Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

    Richard is right - if you export the prior year's budget from GP, you'll be able to use that excel file to put your numbers into and reimport this into a new budget id.

  • Jacob52 Profile Picture
    Jacob52 5 on at
    RE: Amount is coming up as 0.00 when I try and see Account info from Budget in Cards

    If so, I have seen instances where if I imported from an xls file it would work as opposed to an xlsx file. www.myfirstpremiercard.com

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans