I am attempting to add budget data from GP into a budget column but when I run the report, I only get a handful of the actual budget values. I get some rows with correct values and other rows are blank. I've tried recreating and started a whole new row and column setup and I still get the same think. Some values display, other don't.
Anyone else seen this?
Did you go into Great Plains and run Checklinks>>Financial>>Budget Master. This resolved the issue for me in the past
Are you using the Legacy provider or the data mart? If using the legacy provider the data pulls directly from the GL00201 table on your GP company database. Many times the data will not pull if the YEAR1 column is not filled out.
If using the data mart the data would be in the Fact table with a scenarioid that would relate to the scenario table. The scenario table should show your budget id from GP.
If you don't see the data in those two tables then it won't pull in MR. If data is missing for the GL00201 table, like the YEAR1 value, the data mart may not load properly.
@SUSAN CONROD: Where is Checklinks? Is that in the Data Mart or in GP. I don't have the DM I believe.
SOS, Check Links is in GP under Microsoft Dynamics GP>>Maintenance>>Check Links. Run Check Links on the Budget Master in the Financial series.
Thank you Frank and Susan.
I'm having this same problem. I see the records in GL00201 and have ran Check Links on Budget Master but still have two accounts that will not display budget or expense. Any thoughts?
Have you checked the GL00201 to make sure the YEAR1 column is filled out? So you don't even get balances from the GL Transactions on the account either? If that's the case then the issue wouldn't just be budget related.
Are you using the Data Mart integration or the Legacy provider?
I posted 2 Budget one is in USD and 2nd is in SAR, in management reporter the Budget posted in USD working fine keeping Currency display and Currency filter blank, but when I select budget entry posted in SAR no data visible in management reporter I tested each and every currency options in Currency display and Currency filter, but no benefit. Please help me to fix it. Thank you very much.
When you say you posted 2 budgets in USD and SAR... was that in the same company ? or 2 different companies ?
If you want MR pickup your budgets in a consolidated report from different companies, your budget ID must be identical in both companies...
Now if you're only missing 2 accoutns in SAR currency, maybe it's because they're missing from the raw definition in MR 2012 ? have you tried to run the 'missing account' wizard in MR ?
I am having this problem and its infuriating.
The column definition is correct and i can select PLAN15 our budget for the year. This budget is in GP and enquiries can be made against it. It is in is GL00201.
however when i generate the report i only get the budget for one account. All other lines return 0. There are no restrictions in the column definition.
Oh and we dont use data mart
did you rebuild MR console and tried.