SYMPTOMS
When you print the PA Revenue Recognition Edit List in Microsoft Dynamics GP, you receive the following error messages.
Error message 1
Total Revenues Earned is incorrect
Error message 2
Total Recognized Project Revenues is incorrect
CAUSE
This problem occurs because a cost category ID is listed two times in the budget for the project for which you are receiving the error messages.
RESOLUTION
To resolve this problem, follow these steps.
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.
1. |
Determine whether the cost category ID is listed two times in the budget for the project. To do this, follow these steps:
|
||||||
2. |
If a cost category ID is listed two times in the budget, run the following statement in SQL Query Analyzer or in SQL Server Management Studio. To do this, follow these steps:
|
||||||
3. |
Delete the corrupted record from the table. To do this, run the following statement against the company database. Delete * from PA01301 where DEX_ROW_ID = <Number> Note The |