Tutorial 26 - Building a set of Print Templates and a Procedure

During this exercise, you will build a set of three Print Templates and the associated Report Procedure to print out your Account Chart. You will define this Report as a Query (Inspector setting for the Report Procedure and Preferences set in Transaction Data Entry) which makes this Report accessible from within the Transaction Data Entry function.

The underlying methodologies are the same as those that you already carried out as part of Tutorials 7 and 8 in which you created a single Print Template and its Procedure to print Labels. In this Tutorial you will create three separate Print Templates (Header, and two Body templates: one for Control Accounts and the other for regular GL Accounts).

Exercise 26 - 1, The Chart Header Template
All fields shown with a white background are Static Title fields. The Current Date and the Page # fields (with gray backgrounds) are System fields loaded from the Palette. The field with the text "Account Chart" has a -50% Adjustment in the Print Field Inspector. The Template's Printing setting is Always start on the new page. Segment setting is Header - Print in both cases, and Insert blank lines is set to insert 1 line After printing the fields.

Exercise 26 - 2, The Chart Body Template
This Template has a Subledger field (with italic font, left justified) which will print the Subledger Master name when the GL Account is a Control Account. The second field is the GL Number field of the AcctName table (drag from Palette's Database resources). All other fields are Dynamic fields (the Print field in the Draggable objects of the Palette) - Field data type: Prefix is GL Prefix, Subledger and Description are Text, GL Number is inherited. The Template's Printing setting is Start on the next available line. Segment setting is Body - Print on every call to template.

Exercise 26 - 3, The Chart Body w/Subledgers Template
This Template (ChartS) is the same as the ChartB Template with the exception that:
it will print Subledger detail related to the Control Account printed with the ChartB Template;
the Subledger field does not use the italic font and is right justified, it will print the Subledger number of the Subledger account;
the Description field is indented to the right and will print the name of the Subledger account;
all other Inspector settings are the same as for the ChartB Template.

Exercise 26 - 4, The Chart Report Procedure
This Procedure starts out by printing the Header (ChartH) and then steps through the AcctName table in Prefix/GL order and prints (ChartB) a print line for each Prefix/GL retrieved. When the retrieved account is a Control Account, it will include in the print line the name of the Template format (Subledger Master) and then retrieve and print all the Subledgers associated with that Control Account as per this test:

This report was produced with the following Procedure and the Print Templates which you just completed. In this exercise, you will create your own Chart Procedure according to our example. Print objects and Retrieval objects require Inspector settings. We have tagged these objects (e.g. B1 being the first ChartB Print Object) and shown the corresponding partial images of the Inspector settings immediately following this Procedure.

The Inspector settings for the Print Template Objects:


Mapping Local variables from the Procedure against the fields defined in the ChartB and ChartS Print Templates (tagged in the sample Procedure as B1, B2 and S1 to S3 for easy reference)


The Inspector settings for the Retrieval objects:

Exercise 26 - 5, Setting the Query Option
You have now completed the Chart Report. which has been marked as Selectable as a Report. To make it selectable as a Query, follow these instructions.

1. Launch the Transaction Data Entry function and select the Preferences menu item.
2. Select Queries; drag Chart above Drag queries above this line.


3. To run the Chart report during Transaction Data Entry select the Tools > Query... menu item.
This will display the Select Query panel. Please note that this panel only shows those reports as options that were activated for that purpose as part of Preferences > Queries.

Go To
  Tutorial 27 - An Opening Journal Entry