You’re offline. This is a read only version of the page.
45
Hi all,
It's our first time to import budget into GP. I have exported the Excel template and imported a couple lines to test out the function. When I check from various Budget Inquiry window, the amount is showing for the account. However, it does not pick up in Management Reporter even I select the budget code on the column building blocks.
I'm not sure if the issue is because of the Multi Entity Management that we are using for our GP. Since the template does not contain information about the entity and batch ID, will it be possible that it's missing the information needed? I have tried the following steps:
1) Go to budget transaction and select the account I post for budget, but it's showing an "Unposted" status at the bottom.
2) Under Budget Transaction, I have tried to add a batch ID and post but it prompts error "you do not have authorization to perform transaction posting".
3) Under Series Post, I am able to post the batch, but it's still not appearing under Management Reporter and it's still showing status "Unposted" under Budget Transaction Entry
4) Under Management Reporter, change the Provisional as "Posted and unposted activity", but it's still not showing
Is there anyone can give me advise on how to resolve this issue?
Management Reporter pulls budget amounts from the GL00200 and GL00201 tables. You can see the amounts MR should be pulling by going to Cards -> Financial -> Budget in GP. Open the budget in question with GP and confirm the Based On field is set to Fiscal Year. Select the account in question and those are the amounts MR should be pulling. If it isn't, rebuild the MR data mart:
-Close all instances of MR.
-Log into the MR server as a user that is an Administrator in MR and a sysadmin in SQL.
-Start the MR Configuration Console.
-Click on the integration under ERP Integrations.
-Click the Remove link at the top-right.
-Click Management Reporter Services at the top left.
-Stop both MR services.
-Delete the ManagementReporterDM database from SQL.
-In the Configuration Console, start the MR services.
-Click File -> Configure and deploy a new data mart integration.
-Use the 'sa' account to select the DYNAMICS database at the top and use either 'sa' or Windows Authentication to re-create the ManagementReporterDM database.
-Enable the integration and wait for the initial load to complete. It will be complete when the Status changes to "Initial integration is complete."
As far as budget transactions, you don't need to use those unless you are wanting to keep track of budget changes. Most people simply update the budget amounts as needed in the budget window I described above. If you are wanting to use budget transactions, MR will pull those if you run the report with Financial, Account, & Transaction detail. You then drill into the budget total (which comes from the GL00201) and once you get to the transaction level, it will display the transactions that make up that total. If you plan on using this feature, you must turn on Budget Transactions under Maintain History (Microsoft Dynamics GP -> Tools -> Setup -> Financial -> General Ledger).
Share
Report
All responses (
Answers (
