Custom Payables History report showing check information and vouchers it pays

Question:

How do I create a custom report that shows the check number, date, vendor, vouchers the check paid, the amount applied, the transaction description, and the total check amount.

Answer:

Follow these steps in Report Writer:

1. Create a new report and select Purchasing as the series.

2. As the main file, select the PM Key Master file, and use PM_Key_MSTR_Key1.

3. Choose Tables, then choose New. Link the PM Apply to History file and the PM Vendor Master file to the PM Key Master.

4. Still in the Report Table Relationships window, highlight the PM Apply to History file and choose New. Link the PM Paid Transaction History file.

5. In the Report Definition window, mark Text Report and Best Text Fit and unmark all other printing options.

6. Choose Restrictions and create three restrictions:

a. PM_Key_MSTR.Document Type = 6 AND PM_Key_MSTR.Document Status = 3

b. PM_Paid_Transaction_HIST.Voucher Number =PM_Paid_Transaction_HIST.Voucher Number

c. PM_Paid_Transaction_HIST.Current Trx Amount = 0.00000

7. Choose Layout, then from the Tools menu, choose Report Section Options. Create a new additional header and an additional footer. For each one, select the Control Number field (from the PM Keys Master file) in the Field list. This will be the check number.

8. In the RH section, put the information you want to appear at the top of the report.

9. In H1, place the Apply from Document Number and the Document Date from the PM Apply to History file. These fields are the check number and date. Also drag on the Vendor Name field from the Vendor Master file.

10. In B, place the Applied to Voucher Number and Applied Amount from the PM Apply to History file and the Transaction Description field from the PM Paid Transaction History file.

11. In F1, type on a label 'Check Amount:' and place the Applied Amount field, again, by it. Double-click the Applied Amount field and change the field type Sum.

12. Save the report and print it from Report Writer or print it in Dynamics under Custom Reports (Reports - Customized).



This article was TechKnowledge Document ID: 750