Indicator to specify single page or multi page customer statements

| 09/17/2011 | 2 Comments

Recently, I was assisting a forum user, who had requested an option to provide a visual indicator in the footer of the customer statement report, which indicates if the statement has a single page or multiple pages.

After a little thought I had come up with this idea and replied back to the forum user who found this helpful. So I decided to share it with the community, so that it benefits all who meet up such a requirement anytime.

Steps to achieve the requirement:

1. Open the RM Statement on Blank Paper in Report Writer mode.

2. Add the Document Number field to the footer and make it invisible and set the Display Type of the Document Number in the footer as shown below (to show count value).

img1

Then create a calculated field as shown below and display it on the footer. The F2_FREQ Document Number field can be pulled from the list of Report Fields (by selecting Report Fields in the Resources drop down.

img2

By standard the customer statement on blank paper prints only 26 records in the body section on a single page. See the section properties for the additional footer called "footer" and it will indicate that "Records per Report Body = 26". :) We can make use of this logic to achieve your requirement and I have tested this and it works fine (whether you print statement for a single customer (or) multiple customers at once).

Hope this helps the community…

Until next post!

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Tags: , , , , , , , , ,

Category: Accounts Receivables, Dynamics, Great Plains, Reporting

About the Author ()