Archive for September 17, 2011

Indicator to specify single page or multi page customer statements

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!

September 17, 2011 · veeyeskay · 2 Comments
Tags: , , , , , , , , ,  · Posted in: Accounts Receivables, Dynamics, Great Plains, Reporting Total Views: 1,327

Using substring() with Text Fields – David

Back from my vacation, several posts grabbed my interest as a developer. This post from David is one of them.

David explains how to resolve an issue that was found in Sivakumar’s SDT (Support Debugging Tool) based solution. In a nutshell, the issue was with Text type fields and dexterity function substring().

Read it here; Quick Tip: Using substring() with a text field datatype.

VAIDY

Read More:
Using substring() with Text Fields – David

September 17, 2011 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 257