Search HansaManuals.com HansaManuals Home >> Standard ERP >> Report Generator >> Creating a New Report Previous Next Entire Chapter in Printable Form Search This text refers to program version 8.5 Creating a Report Generator Report - Printing Information from Matrices - Matrix Rows of Different Types This page describes dealing with matrix rows of different types in the output of Report Generator reports.--- Some matrices (for example, the Invoice matrix) can contain rows of different Types. For example, if an Invoice is a Credit Note, there will be a row containing the phrase "Credit of Invoice" and the Invoice Number of the Invoice being credited. If an Invoice is a Down Payment Invoice, there will be a row containing the phrase "Down Payment" and the Order Number of the Order for which the deposit is required. If an Invoice has been connected to a Prepayment, there will be a row containing the Prepayment Number and the Prepayment Amount. There may also be rows containing a Header, one or more Subtotals and/or Hidden rows. These are all rows of different Types. For example, a standard Invoice row is a Type 1 row, the Credit Note row is a Type 3 row, the Down Payment row is a Type 5 row, and the Prepayment row is a Type 6 row. You can find a full list at the end of this page. When you add a matrix to a report, four new sections will be added to the 'Layout' card, as described here. In our example Customer List report, the Invoice Item Header, Invoice Item Footer, Invoice Item Before and Invoice Item After sections were added to the 'Layout' card. When you add fields to these sections, they will print information from every Invoice row, irrespective of Type. In some cases, the fields that we placed in these sections will be sufficient to print information from each row Type. In the example report illustrated below, the first Invoice is a Down Payment Invoice and the second Invoice is a full Invoice that has had the Down Payment Amount deducted. Each Invoice therefore contains a Type 5 row, and the information from these rows is shown in the report in an acceptable manner: The Prepayment Amount also appears in the Sum column, which is misleading because it is a partial payment against the Invoice, not a contributor to the Invoice total. So, in this example, the fields in the four Invoice Item sections do not print information from rows of Type 6 in a satisfactory manner. To avoid this problem, we can add a new section for Type 6 rows only. To do this, follow these steps:
Invoices 1 Standard In most cases you can use the Spec field to print any editable text that may appear in the row (e.g. Down Payment comment, Subtotal comment, etc). Row Types 9, 10 and 17 are also used in Quotations and Sales Orders and Types 9 and 17 in Project Budgets. Type 6 is also used in Purchase Invoices (use the PrepayNr field to print the Prepayment Number and the PrepayAmount field to print the Prepayment Amount). Receipts 1 Standard Payments 1 Standard Please follow the links below for more details about:
Go back to:
|