1.3.1. Documents

Print Format

In the Print Format window you can manage print formats used for printing documents. The following fields are available:

• Name - name of the print format;

• Description - optionally you can add a description;

• Active - indicates if the print format is active in the system;

• Table - the database table used for generating the report

• Form = checked - indicate that the print format is used for a document report.

• Totals Only, Print Table Format, Standard Header/Footer, Suppress Duplicate Group by, View Report - fields used when defining report print formats;

• Print Paper - defines the size, orientation and margins of the document. Details in Setup;

• Printer Name - enter a specific printer for the print format. If none is entered, the default printer selected at login will be used;

• Header Margin, Footer Margin - set the distance from the top / bottom of the printed page to the beginning / end of main contents in points;

  • Print Font - default font used. Details in Setup;

  • Print Color - default text color used. Details in Setup;

• Copy / Create button - allows you to copy the elements of an existing print format or generate elements based on a table. The current print format table will be changed automatically depending on the source table/print format;

The Display Order and Sort Order tabs should not be used when defining a document print format.

Format Item

The Format Item tab is used to manage the print format items such as text, shapes or images. The following fields are available:

• Sequence - indicates order in which items are displayed and is used for relative positioning;

• Name - the name used to identify the item;

• Format Type - This indicates the type of item formatting (e.g. Field, Image, Line, Rectangle, Text, Print Format). Depending on the selection made here, different fields will be displayed:

  • "Field" - this item will display a value from the print format table;

    • Column - the table column displayed;

    • Barcode Type - this will print a barcode representation column value;

  • "Image" - this item will display an image:

    • • Image Attached - will print the image attached to the item. The file types supported are GIF, JPEG or PNG;

      • Image Field - the image will generated using the an URL located on the report table, in the selected column.

      • Image URL - the image will generated using the URL entered;

  • "Line" - the item will display a line. The start position for the line is the item position and can be defined as either an absolute, or a relative value, as detailed below (see Relative Position). The end position is determined relative to the start position, using the values for Maximum Width / Height;

    • Line Width - determines the line width;

  • "Rectangle" - the item displayed will be a rectangle. The upper left corner is the item positions (see Relative Position). The lower right corner is determined relative to the start position, using the values for Maximum Width / Height;

    • Fill Shape - check to to display a filled, non transparent rectangle;

      • Shape Type - predefined options regarding the rectangle aspect: 3D Rectangle, Normal Rectangle, Oval or Round;

  • "Print Format" - can be used to display a report prin format within this print format (e.g. invoice lines);

    • Column - column through which the secondary print format table is linked to the primary print format table;

    • Included Print Format - secondary print format, used to print the report;

  • "Text" - this item will display the text entered in the Print Text field (for the main language) or in the Translation tab;

    • the following dynamic text values can be used:

      • @*Page@ - the current page number;

      • @*PageCount@ - total number of pages;

      • @*MultiPageInfo@ - page X out of Y. It prints only on reports with multiple pages;

      • @*CopyInfo@ - prints 'Duplicate' on reprinted documents;

      • @*ReportName@ - prints the name of the report;

      • @*Header@ - prints full header, complete with user name / tenant / organization;

      • @*CurrentDate@ - the date of printing;

      • @*CurrentDateTime@ - the time of printing;

      • dinamic values available in the global application context (Tools -> Context) can also be used, for example:

        • @##AD_User_Name@ - the current user;

        • @#AD_Org_Name@ - the organization selected by the current user at login;

• Area - indicates the area of the document where the item will be printed. Available choices are: Header, Footer, and Content;

  • each area has it's own position within the page;

  • if a document is spread across multiple pages (e.g. multiple invoice lines) the header and footer items will be printed on each page;

• Relative Position - indicates how the item position within the page is determined:

  • "checked" - the item position is determined relative to the upper left corner of the area, using the values for X Position (horizontal) and Y Position (vertical);

    • "not checked" - the item position is determined relative to the item with a previous Sequence, using the values for X Space (horizontal) and Y Space (vertical);

    • Next Line - if checked, the item will be printed on the next line. If not checked, the item will be printed on the same line;

    • Next Page - if checked the item will be printed on a new page;

• Field Alignment - alignment for the text within an "Text" or "Field" item: Block, Center, Default, Leading (left) or Following (right).

• Fixed Width - text within an "Text" or "Field" item will have a fixed width, regardless its content;

• One Line Only - if checked, only one line is to be printed, regardless of any restrictions (maximum width, page margins)

  • Note: if the column has a width restriction and the text is wrapped over multiple lines only the first line will be printed.

  • Print Font - font used to print the item. Details in Setup;

  • Print Color - text color used to print the item. Details in Setup;

The Translation tab is used to enter the element text values corresponding to each language other than the system language.

The Print Format Detail report displays a list containing all the elements within a print format, and related information. The report columns represent properties of the respective elements.