Adding Check Number on RM Historical Aged Trial Balance

TechKnowledge Content


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

2. Click
Relationshipsand 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.

6. Click
OKon the various windows until you are back to the main
Report Writerwindow.

7. Click the
Reportsbutton and insert the
RM Detail Historical Aged Trial Balancereport and
open it.

8. In the
Report Definitionwindow, click

9. Highlight the
RM HATB Applied TEMPand click

10. Select the
RM Key Fileand click
OK. Close the
Table Relationshipswindow.

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.

Note: In
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

Article ID: 865107 - Last Review: 18 Nov 2015 - Revision: 1