Notifications
Announcements
No record found.
The budget i.d. is showing up in Frx - i changed the column layout with the 2012 budget and when i generate the report in Frx the budget is only showing up with zeros.
*This post is locked for comments
Probably could use more details but here is a start:
Make sure your column layout period and year don't point to a year <> 2012 to see the budget.
Make sure the correct company is being used in the company setup, column, tree, etc.
Make sure the budget id is the exact id from GP. Use the drop down in the column layout.
Make sure you set up the budget id for FY2012.
Try building the gl index.
All else fails, delete the *.g32 files in the sysdata folder.
Good luck.
MV
Thanks for the response.
I tried what you said and no luck.
I have two companies - each with their own budgets and then an organizational combined budget. All 3 id's are showing up in GP and Frx. In the past i would enter the Organizational Budget in the column setup and the correct accounts would pull for each company's p&l. Now, I am only getting zeros. However, when I put one of the company's budget in the column layout, instead of the Org one, I get numbers in the budget column but the revenue numbers are showing as negative. The second company's budget inserted in the column layout gave me zeros once again. I am so confused by all of this - can you shed any light?
Anna, can you view the Budget data in GP? If so, then there may be something awry with the Budget ID. It's been a few years back so I don't remember all the details but I remember running into a similar scenario where the Budget ID in the Budget Master table (GL00200) and the Budget Detail table (GL00201) didn't match. If the Budget data doesn't appear in GP, I'd look at those two tables to see what's in there.
Hi Anna -
You have 2 companies, each with their own budget, and a combined budget id. What are you using for the labels of the budget id's? What company holds the combined budget? What company is your FRx catalog pointing to? The catalog always points to one company unless you combine it with company records from a tree and the columns in the column layout are isolated to tree units that point to different companies. I sense there is still is an issue with matching up the companies and the budget ids. Maybe a description of your report and how you are structuring it will help.
Try building a company tree and create 4 columns in a column layout. FIrst column is DESC, columns 2-4 are GL columns that represent each budget id. Then make sure to isolate each column to the tree unit that matches up with the budget id of that column. Use the existing row.
The revenue numbers are entered as negatives in the budget id. You will need to add a "C" in the row format on each revenue line to reverse the sign
Mike
Please verify no table GL00201 if for that particular budget the year1 column is equals to 0,
if so, then use the following script that fixes all your budgets where the year1 column is 0.
update p set p.year1 = a.year1 from GL00201 p join GL00200 a on a.budgetID = p.budgetid where p.year1 = 0
Make sure you backup your database first.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
