Error messages when you print the "PA Revenue Recognition Edit List" in Microsoft Dynamics GP: "Total Revenues Earned is incorrect" and "Total Recognized Project Revenues is incorrect"

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:

a.

On the Cards menu, point to Project , and then click Project .

b.

In the Project Maintenance window, select the project, and then click Budget .

c.

In the Budget Maintenance window, determine whether a cost category ID is listed two times in the budget. The duplicate cost category IDs in the Budget Maintenance window have a sequence number of 0 in the Seq column. If a cost category ID has a sequence number of 0, a duplicate record exists for this project cost category combination in the PA Budget Master table (PA01301).

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:

a.

Click Start , point to All Programs , point to Microsoft SQL Server , and then click SQL Query Analyzer . If you are using SQL Server 2005, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .

b.

Run the following select statement against the company database. select PALineItemSeq, * from PA01301 where PAPROJNUMBER='<Project_number>' and PACOSTCATID='<Cost_category_ID>' Notes The

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×