Once done with the configuration in the Financial Report window, click on the Generate Report button to open the Print Designer.
Listed below is the hierarchal structure of the available data to build the reports. Under the Elements/ Options area you will find:
- First Grouping
- Second Grouping
- Third Grouping
- Totals For First Grouping
- Totals For Second Grouping
- Totals For Third Grouping
- String Mapping
The preview area to the right is where the Report Template is designed according to the selections made under the Elements/ Options area.
For more detailed information on working with the Print Designer, please refer to the Print Designer Manual.
1. Header & Footer
The Header and Footer show the same info regarding the report's print date and time, the date range of the lines to be included, the dates used in some search filters like the Invoice Manager (Search Criteria grouping), and the totals. The only difference is that the Header appears at the top of the document and the Footer at the bottom. Therefore it depends on the desired layout whether information should be displayed at the top or bottom of the template.
Images stored in the label_images folder as well as the company logo in the server set-up are only available in the Header and in the First Grouping.
The following example shows some values from the Header Section: the Print Date And Time, the Filter Lines From Date / To Date (if Financial Lines in Range has been set to a certain time range ); and some values from the Footer section: the Sell Total (Booked Only), the Sell Total (Used) and the Sell Total (Invoiced).
A Financial Report can be launched from many different places in farmerswife, fed by search results from other modules such as the Advanced Project Search and Invoice Manager.
The various date options under the Search Criteria grouping allow displaying the date ranges that were used for filtering the Projects, Invoices, Bookings, etc.
The following example shows a report run on all invoices created during the month of April.
In the print templates these search dates are selected under Search Criteria > Invoice Manager > Created After & Before.
The "Input Collection" phase, within "Search Criteria", decides which Projects/ MOs/ Invoices are fed into the filtering process. The "Financial Lines In Range" filter then filters after that.
Typically both would be set to the same value (and by default they are set to the same value). But the "Financial Lines In Range" setting can be changed without re-collecting input, and in that case they will differ. One scenario to exemplify this is if you want to report on all Projects that had anything to do with "Avid 1" in 2013, but without filtering those Projects at all. In that case you would collect input based on 2013, but then clear the "Filter Lines In Range" setting.
2. Group By (1), (2) & (3)
Once a financial report is generated, the Print Designer will offer information based on the groupings selected for the template. Most groupings only display the Description (Name) and the Totals trees. Others have more information available. See some of the examples below.
Project/ Media Order/ Unref. Invoice
The example below shows info populated from a Project
Price Agreement Name
The example below displays a report grouping by Price Agreement Name. The option Price Agreement or "No Price Agreement" has been selected, instead of Details, so the lines (coming from grouping Object) that do not belong to any Price Agreement are listed under No Price Agreement. A String Compare Operator has been added to this option to rename the "(No Price Agreement)" to "Extras".
The Rows section contains information from each line in a Booking, Media Order, Work Order, Extra, etc.
The following example displays a report showing all the jobs booked on a group of suites within a specific month. The template was generated grouping by 1.Project and 2.Name From Source, and it displays the Project description (taken from the Project section), the Source description next to Job label (taken from the Name From Source section), and below is the detailed info of the involved suites such as the Object Class, Activity, Object, Quantity, Date and Time In/Out (taken from the Rows section).
- Object Note: Refers to the note entered in Server when creating the Object.
- Object Time Report Note: Displays the note entered in at Object level in the Time Report window.
- Time Report Note: Displays the note entered in the Time Report.
- Note: Displays the note for the Project Material/Service/Expense, Booking Object, Work Order, Budget Detail, etc.
- Note From Source: Displays the note from the Booking, from the Media Order and from Virtual Bookings.
* To display the Time options (such as Time In/Out, Time In, Time Out), the General Setting "Mix Days" has to be set to No.
4. Totals For Group By (1), (2) & (3)
These show the same information as Group by (1), Group by (2) and Group by (3) in the same way as explained above for Header and Footer, and are located below the Rows section.
The second Footer section allows you to create footnotes at the bottom of the page and that will be repeated in all pages. This is specially useful for adding company information, such as company name, address, etc.
6. String Mapping
Use this feature to replace or exchange characters or words in the report template. The String Mapping applies to the whole document. For further details refer to the Print Designer Manual.
Since version 4.10, each dynamic Element (meaning not fixed text) has the option to create String Operators, such as String Mapping, Math Operations, etc. These will only apply to the Element where it has been created. For more detailed information, please refer to the Print Designer Manual.