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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10.0 period budget ...
Microsoft Dynamics GP (Archived)

GP 10.0 period budget amount display zero

(0) ShareShare
ReportReport
Posted on by Mani Mostofa 215

I have a customer using GP 10 with multiple companies, one of the company's period budget amount show zero, but the total for the year amount shows correctly and it print in FRx correctly, If any body has an idea how to fix this problem? Thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Mani,

    I don't think I understand the question. Many questions come to mind when I try to figure it out.

    Does each company have a separate company database, or are you running multiple companies out of a single database?

    I am assuming the company's period budget amount should not equal zero. When you export the budget to Excel, does the period total show up correctly?

    Where are you looking to find the period total and the total for the year?

    Kind regards,

    Leslie

  • Mani Mostofa Profile Picture
    Mani Mostofa 215 on at

    Thank you for the reply, they are running multiple companies in single database. the problem is with one company, when you go into inquiry, financial, budget summary, you will see budget by period display zero, but the total amount at the bottom shows total for the all periods. I will appreciat your help.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Mani,

    Since they are runniing multiple companies in a single database, what window are you looking at in order to see the 'one company' problem? Is the company itself out of balance? Have you reconciled financial?

  • Matt Leibham Profile Picture
    Matt Leibham 205 on at

    I have the same problem- I go to Financial- Budget - open the Budget year, enter the account number.  There is an amount in the Total that is the correct amount for the year, but all period amounts are $0.  We upgraded to GP2010 and this is still an issue, however, both FRX and Management Reporter no longer pick up these amounts, so our reports are all incorrect.  

    I believe this is happening when we combine one general ledger account into another through the Professional Tools Library.  The budget amount for the combined accounts only shows up in the Total and does not show up by period.  So for all the accounts we have combined or merged, the budget by period is $0 and our reports in FRX and Management are incorrect.

  • Toolio Profile Picture
    Toolio 40 on at

    I am having this issue ...anyone ever get this resolved?

  • Matt Leibham Profile Picture
    Matt Leibham 205 on at

    No Fix to Date

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    How were the budgets entered?  Manually?  Using the Import Wizard?  an integration tool?

  • Matt Leibham Profile Picture
    Matt Leibham 205 on at

    using the import wizard with excel

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Have you tried running check links on the Budget Master tables?  I would start there first.

  • Matt Leibham Profile Picture
    Matt Leibham 205 on at

    Did CheckLinks and Reconcile- that didn't work.  Looked at Table GL00201.  The accounts that are having this problem have their Year1 column changed (assuming during the account merges process) to 1900 when it should be 2012 and Period is changed to 1900-05-01 when it should be 2012-05-01 or whatever the correct year-period should be.  With the help of a consultant, we manually fixed our "problems" in SQL yesterday.  But, if we continue to use Professional Services Tools Library and do account merges (which we have to continue to do), I am sure this problem will continue and fixing manually or through a script in SQL everytime seems foolish.  Any ideas are appreciated.  

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans