The following steps can be used to add the check number on the Receivables Management Historical Aged Trial Balance for applied checks.
1. In Report Writer, click the
Tablesbutton. Highlight the
RM_HATB_Applied_TEMPtable and click
3. For the Secondary Table field, select the
RM Key File.
4. For the Secondary Table Key, select
5. Select the following fields in the Primary Table column, in this order:
Apply From Document Type, Apply From Document Number.
OKon the various windows until you are back to the main
7. Click the
Reportsbutton and insert the
RM Detail Historical Aged Trial Balancereport and
8. In the
Report Definitionwindow, click
9. Highlight the
RM HATB Applied TEMPand click
10. Select the
RM Key Fileand click
OK. Close the
11. Click the
Layoutbutton and drag the field
Check Numberfrom the
RM Key File into the
Body section of the report. You may have to make room for it by removing other fields.
12. Save the report, and go back into Dynamics. Then grant users security to the report under
Setup - System - Security.
Reports - Sales - Trial Balance, choose the
Historical Aged Trial Balance. Modify the report option by marking to
exclude Multicurrency information. If this modification is needed on the multicurrency report, insert the MC RM Detail Historical Aged Trial Balance in step 7 and do not modify the report option to exclude multicurrency information.
This article was TechKnowledge Document ID:5170