INTRODUCTION
This article describes how to use Report Writer to print all seven aging periods on the RM Aged Trial Balance report in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0.
MORE INFORMATION
By default, only the first four aging periods appear on the RM Aged Trial Balance report when you print the report. To print all seven periods on the RM Detail Aged Trial Balance report or the RM Quick Detail Aged Trial Balance report, you must modify the report by using Report Writer. To do this, follow these steps.
Step 1: Back up and then open the report
1. |
Back up the Reports.dic file if you have any modified Microsoft Dynamics GP reports. To locate the Reports.dic file, follow these steps:
|
Step 2: Open the report
1. |
On the Tools menu, point to Customize , and then click Report Writer . |
2. |
Use the appropriate step: • In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP in the Product list, and then click OK . |
3. |
Click Reports . |
4. |
In the Original Reports area, click RM Quick Detail Aged Trial Balance , and then click Insert . |
5. |
In the Modified Reports area, click RM Quick Detail Aged Trial Balance , and then click Open . |
Step 3: Create a calculated field
1. |
Click Layout . |
2. |
In the Toolbox window, click Legends in the resource list, and then click Legend 5 . |
3. |
Drag Legend 5 to the H1 area. |
4. |
In the Toolbox window, click Calculated Fields in the resource list, and then click Bucket 5 . |
5. |
Drag Bucket 5 to the H2 area. |
6. |
In the Toolbox window, click Apply Bucket 5 , and then drag Apply Bucket 5 to the report body. |
7. |
Double-click each field that you added in the report, click Hide When Empty in the Visibility list, and then click OK . |
8. |
In the Toolbox window, click Total Bucket Five in the resource list, and then drag Total Bucket Five to the F1 section and the RF section of the report. |
9. |
Double-click Total Bucket Five in the F1 section of the report, click Sum in the Display Type list, and then click OK . |
10. |
Double-click Total Bucket Five in the RF section of the report, click Sum in the Display Type list, and then click OK . |
11. |
Repeat step 2-10 to add the following fields: • The Legend 7 field. |
12. |
In the Toolbox window, click Calculated Fields in the resource list, and then click New . |
13. |
In the Name field, type Legend 5 . In the Result Type list, click String . In the Expression Type area, click Calculated . |
14. |
In the Resources list, click RW Legends . In the Field list, click Legend , and then click Add . When you are prompted, type 5 for the array index, and then click OK . |
15. |
Click OK , and then drag the Legend 5 calculated field to the RF section and to the F1 section of the report. |
16. |
In the RF section and in the F1section , double-click Legend 5 . In the Display Type list, click Data . |
17. |
Repeat step 12 through step 16 for the Legend 6 calculated field and for the Legend 7 calculated field. |
Step 4: Save the modified report
1. |
Close the report. Click Save when you are prompted to save your changes. |
2. |
In the Report Definition window, click OK . |
3. |
Use one of the following steps: • In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP on the File menu. |
Step 5: Grant access to the modified report
Method 1: By using Advanced Security
1. |
On the Tools menu, point to Setup , point to System , and then click Advanced Security . Type the system password if you are prompted. |
2. |
Click View , and then click by Alternate, Modified and Custom . |
3. |
Use the appropriate step: • In Microsoft Dynamics GP 9.0, expand Microsoft Dynamics GP . |
4. |
Expand the following nodes: • Reports |
5. |
Use the appropriate step: • In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP (Modified) . |
6. |
Click Apply , and then click OK . |
Method 2: By using Microsoft Dynamics GP security
1. |
On the Tools menu, point to Setup , point to System , and then click Security . |
2. |
In the User ID list, click the user ID of the user who will access the report. |
3. |
In the Type list, click Reports . |
4. |
In the Series list, click Sales . |
5. |
In the Access List box, double-click RM Quick Detail Aged Trial Balance or RM Detail Aged Trial Balance , and then click OK . |
Step 6: Print the report
Print the report. All seven aging periods should be displayed in the report.
Note The legends only print successfully in the report if the report is printed in Microsoft Dynamics GP. The legends do not print successfully in the report if the report is printed in Report Writer.
DISCLAIMER
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.
THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.
-------------------------------------------------------------------