Adding Check Number on RM Historical Aged Trial Balance

FYI:

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
Open.


2. Click
Relationshipsand click
New.


3. For the Secondary Table field, select the
RM Key File.


4. For the Secondary Table Key, select
Key1.


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
Tables.


9. Highlight the
RM HATB Applied TEMPand click
New.


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