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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Budget planning upload not accepting $0 values

(0) ShareShare
ReportReport
Posted on by 205

Hi all,

Budget planning is not always accepting a zero value when loading budget plan via the Excel Add-in.  

We put the budget plans and various budget managers updated their plans. Since some of the budget managers had approved their plans, I had to create the plan again so that I could edit. When I did this, it did not pull in any of the financial dimensions that had zero budget amounts. We were unaware that this would happen so I had to copy in about 500 lines into the Excel Add in. For all those lines, I had to enter a dollar amount, publish them and then go through and enter zero so they could be updated with appropriate budget amounts at a later time. If I left the budget amount at zero, it would not publish. I currently plan to not disperse budget plans to our Budget Managers and I will be doing all updates. While this is not a loss of revenue or ability to bill, it's costing us a lot of my time and college money. It's a very cumbersome and inefficient process.

Anyone have any suggestions here?

baseline-not-accepting-zero-values.12_2C00_2_2C00_21.jpg

I have the same question (0)
  • Ian Waring Profile Picture
    442 on at

    I know it’s a pain but even when loading budgets via data management, any item with a zero value is rejected. We have an extra step to remove all those lines in the load spreadsheet before import.

    We’vr not found a way around this yet in 3 years of loading budgets.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 635 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 595 Super User 2026 Season 1

#3
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 557

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans