Document Layout is used for adding fields to the documents which, in their turn, could be shown in the Lasernet reports. These could be fields from the tables of documents (e.g.: Sales Shipment Header for the shipment document), or fields from another table (e.g.: Customer table) if the table has a relation to the document table (e.g.: the Sell-to Customer No. field in the Sales Shipment Header table has a relation to the No. field in the Customer table).




General Fast tab



The fields on the General FastTab are described in the following table.


FIELDDESCRIPTION
No.Unique identifier for the document layout.
DescriptionShort description of the document layout.
DocumentIdentifies a document type for the layout. All are predefined Lasernet documents except for the following: Custom Report – If selected, the Custom Report-related fields become accessible – Custom Reports).
Last Modified DateIndicates the date on which the document layout was last modified.
Last Modified by User IDIndicates who last modified the document layout.


Custom Reports


As previously stated, if the Document = Custom Report, additional fields become accessible on the General FastTab.



The fields within the Custom Report group are described in the following table.


FIELDDESCRIPTION
Top DataItem Table No. / Top DataItem Table NameDetermines the table used as the Header table for the document which is necessary to create relations between the tables and the document.

For example, the Issued Reminder Header table is the top data item table for the Reminder document.
Report No. / Report NameDetermines the custom report that has been created for a particular document.

Sections


This is where you add the tables. Please start by using the Suggest button in the top. This will give you the main tables and add filters as well. Then you just need to add fields.




The fields fields on the Sections FastTab are described in the following table.


FIELDDESCRIPTION
Section TypeIndicates an option:
  • Header (If you like the information to be shown in the header).
  • Line (If you like the information to be shown on the lines).
DescriptionShort description of the layout. It is a simple description.
Table No. / Table NameIndicates from which table you would like to get information. It could also be a table that you are using to filter another table that you are going to have.


Line Menu

The actions on the Line menu on the Sections FastTab are described in the following table.


FIELDDESCRIPTION
Increase IndentationIndents the line to create a relation to the line above, therefore creating a parent/child relationship. Parent lines have indented lines below.
Decrease IndentationDecreases the indent on the line to create a relation to the line above/below, therefore creating a parent/child relationship. Indented lines are the child in the relationship.
FiltersRelates the selected table to the Top Data Item or if indented, then to the table that is on the level above.
FieldsIndicates which field is available in the document.


Filters


The Filters menu is where you build the relation between the two tables. Below we are looking at the Sales Line filters.




As you can see we are using the Document Type field for both tables and then Document No. from the Sales Line and that goes to No. from the Sales Header table. This is our relation between the two tables Sales Header and Sales Line.


If you want to add e.g. the Item table to the Sales Line, you need to add it below the Sales line and then Increase Indentation two times so it is below as a child to the Sales Line.



Now you can open the Filter menu and add your your fields so you can build your relations between the Sales Line and Item table.



Fields


When all your relations are added, next step is to add the fields from the tables. Open the Fields menu and add the fields you want. This has to be done for each table.