TechKnowledge Content
Question:
I would like to print the Fee Schedule on my PA Fees List – by Project report. (Reports-Project-Billing Activity-Fee List-Project) How can I add the schedule?
Answer:
Here are the steps to add the Fee Schedule to the PA Fees List – by Project report. (Reports-Project-Billing Activity-PA Fees List - by Project).
1. |
Go into Report Writer. (Tools-Customize-Report Writer) |
2. |
Click on the Reports icon from the top menu bar. |
3. |
From the Original Reports side, highlight the PA Fees List – by Project report and choose insert. |
4. |
Then on the Modified Reports side, highlight the same report and choose the Open button. |
5. |
In the Report Definition window choose the Tables button. |
6. |
In the Report Table Relationships window, highlight the PA Project Fee Master File and choose the New button. |
7. |
Highlight the Project Fee Schedule Master and choose the OK button. |
8. |
Select the Close button |
9. |
In the Report Restrictions window choose New |
10. |
Name the restriction Dummy |
11. |
In the fields section, click on the drop down list for Report Table and choose the PA Project Fee Schedule Master . |
12. |
Click on the drop down list for Table Fields and choose Line Item Sequence . |
13. |
Choose the Add Field button. |
14. |
In the operators section, choose the = button. |
15. |
Chose the Add Field button again. |
16. |
The Restriction Expression should read |
17. |
Choose the OK button. |
18. |
Close the Report Restrictions window. |
19. |
Click on the Layout button from the Report Definition Window. |
20. |
Choose the Tools option from the top menu bar, then select Report Section Options . |
21. |
|
22. |
|
23. |
|
24. |
|
25. |
|
26. |
|
27. |
|
28. |
|
29. |
|
30. |
Choose the X from the top right corner of the Report Layout window. |
31. |
Save your changes. |
32. |
Click OK in the Report Definition window. |
33. |
From the top menu bar, choose File - Great Plains Dynamics. |
34. |
Give users access to the modified report in the Security Setup window (Setup - System - Security) within Dynamics. |
This article was TechKnowledge Document ID: 26477