You’re offline. This is a read only version of the page.
205
Our Budgets by period show $0 for some accounts, but the totals show the correct balance for the year. 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.
Any suggestions on to fix, other than re-doing the budget for all our combined accounts?
Thanks
*This post is locked for comments
I received this advice and it worked for me...
Re: GP 10.0 period budget amount display zero
Replied to by Muhammad Amir
I had the same issue and found this SQL Script that fixes the YEAR1 value for all budgets and all years.
update GL00201
SET YEAR1=b.YEAR1
FROM GL00201 a
INNER JOIN SY40100 b
ON (a.PERIODDT>=b.PERIODDT and a.PERIODDT<=b.PERDENDT)
and b.PERIODID>0 and b.SERIES=0
So next time you have this issue, you can run this script against the company database and this will fix it.
Thanks
Amir
Did you ever find a solution? I am experiencing the same problem, although I don't believe it has anything to do with using the Professional Tools Library.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (