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.
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
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * leslievail@earthlink.net
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.
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?
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.
I am having this issue ...anyone ever get this resolved?
No Fix to Date
How were the budgets entered? Manually? Using the Import Wizard? an integration tool?
Frank E. Hamelly, MCP, MCITP, MCT, MVP
http://gp2themax.blogspot.com/
using the import wizard with excel
Have you tried running check links on the Budget Master tables? I would start there first.
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.
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
Thanks for the script.