Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

PA History Receivings Report does not order by project number in Microsoft Dynamics GP


View products that this article applies to.

Symptom

The PA History Receivings Report is not sorting by Project Number in Microsoft Dynamics GP even though you have selected by Project Number in the Sort list in the History Report Options window.

↑ Back to the top


Cause

This is a documented bug with the software in Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010.  

↑ Back to the top


Resolution

Use Report Writer to manually add a new sort using the PA PO Receipt Line History table and the PA Project Number field.  To do this follow these steps:

1. Open the report in Report Writer. To do this, follow these steps: 

a. Click Tools, point to Customize, and then click Report Writer.

b. In the Product list, click Project Accounting.

c. On the Toolbar, click Reports.

d. In the Original Reports list, click PA History Receivings, and then click Insert.

e. In the Modified Reports list, click PA History Receivings, and then click Open.

f. In the Report Definition window, click Sort.

2. In the Sorting Definition window, select PA PO Receipt Line History table, select PA Project Number field and click Insert. Click Ok.

3. Click Ok on Report Definition window.

4. Save your changes, and then exit Report Writer. To do this, follow these steps:

a. Click File, and then click Microsoft Dynamics GP.

b. When you are prompted to save the changes to the layout, click Save.

c. When you are prompted to save the changes to the report, click Save.

5. Grant security to the report. To do this, follow these steps. 

a. Point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to System, and then click Alternate/Modified Forms and Reports.

b. In the ID box, type theAlternate/Modified User ID that is associated with the User ID who will print this modified report.

c. In the Product list, click Project Accounting.

d. In the Type list, click Reports.

e. Click on the plus sign next to the Project folder.

f. Click on the plus sign next to the PA History Receivings.

g. Click on the radio button next to Project Accounting (Modified).

h. Click Save.

6. To print the PA History Receivings report, you can go to the History Report Options window . On the Reports menu, point to Project, point to History, and then click Receivings.

↑ Back to the top


Keywords: kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 2678985
Revision : 1
Created on : 1/7/2017
Published on : 5/18/2012
Exists online : False
Views : 188