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
|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.|
|Tutorial 27 - An Opening Journal Entry|