When you generate a report in Microsoft Management Reporter that includes Dynamics GP budget information, you receive the following error message:
The operation could not be completed due to a problem in the data provider framework.
This error is caused by a blank budget ID in Microsoft Dynamics GP.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
To resolve this error message, follow these steps:
- Open SQL Server Management Studio and log in with the sa credentials.
- Run the following query against your GP company database:
Select * from GL00200
- Check the BudgetID column for any blank IDs.
- If there are blank IDs, you can run the following query against the GP company database to remove them:
Delete from GL00200 where budgetid = ' '
文章識別碼：2739480 - 最後檢閱時間：2012年7月30日 - 修訂： 1
Microsoft Management Reporter 2012, Microsoft Dynamics GP 2010