I was assisting a customer that has budgets in GP for all their locations. I confirmed that I could see them in GP and that the budget vs actual inquiry showed information in both columns -actual and budget for a variety of accounts.
We setup the columns in MR for actual budget (and picked the correct budget) and ran the report. For some reason, it ignores certain budget accounts on certain locations. In one location the revenue budget amount does not come in, but the expense budgets do. Yet in another location everything is fine. This is all ine one database, not using trees, so not very complex. No matter what we tried, it does not display revenue budgets for vertain locations even though they do show fine in GP.
First we thought it was just an on-screen display problem, but when we export to Excel, the data is still missing. This company is tryng to close and they cannot get a complete report.
By the way, I did go to Tool > Update Financial Cache and it ran through very quickly, but did not change anything. I am at a loss.
*This post is locked for comments