Table of Contents

Create Labels

You need to define the label file (.lab) that will contain the Business Central data, and set up the tables, relations and fields that determine what information appears on the label.

See Sample Labels for some examples of how labels can be set up.

Add a label

  1. Choose the icon, enter Labels, and then choose the related link.

  2. On the Labels page, select New.

  3. On the Label Card page, in the General FastTab, populate the following fields:

    Field Description
    Code Enter a unique code that represents the label being printed.
    Description Enter a description of the label.
    File Name

    Enter the exact name of the label file.

    The .lab extension must be part of the file name. For example, Shipping.lab. The file location is defined by TEKLYNX.
    Status Ensure the status is Draft or Inactive to edit the record.
  4. In the Label Tables FastTab, add the table that corresponds to the label action.

    This is the table for the page that will have the Print to SENTINEL action, or from which the print action will be triggered. This label action table must always be the first line.

    Field Description
    Table No

    Select the table that corresponds to the record or event from which to print the label.

    The table must be associated with a label action on the Label Actions page.
    Parent Table No. Leave this field blank.
    Record to Print

    If applicable, select the check box to indicate the record is responsible for printing the label.

    One line must have the check box selected, and only one check box can be selected per label code.

    Fields must be added to the table if the check box is selected.
    Table Filter If applicable, apply filters to specify which records should have labels printed. See Add table filters for more information.
  5. Add any child tables.

    Use child tables to add label information not found in the parent table, or to act as a parent for another child table that supplies more details for printing.

    For example, if you're creating a shipping label, and the label action is from the Sales Header table (36), you might want to pull in information that's found in the shipping lines, in which case, you would need to add the Sales Line (37) table.

    Important

    There can only be one child level below the line where the Record to Print check box is selected.

    1. In the Label Tables section, populate the following fields:

      Field Description
      Table No Select the table that contains the information that you want to include on the label.
      Parent Table No.

      Enter the number of the parent table.

      At least one line needs to have the initial label action table as the parent.
      Record to Print

      If applicable, select the check box to indicate the record is responsible for printing the label.

      One line must have the check box selected, and only one check box can be selected per label code.

      Fields must be added to the table if the check box is selected.
      Table Filter If applicable, apply filters to specify which records should have labels printed. See Add table filters for more information.
    2. Add any other child tables that are needed.

  6. Add the table relations between a parent table and a child table.

    This is used to connect the two tables and ensure the correct record information is pulled from the tables.

    For example, on a shipping label where you are listing the sales lines, the system needs to know which sales document to pull the sales lines from, so you would need to relate the Document Type and No. fields in the Sales Header table to the Document Type and No. fields in the Sales Line table. The reason why you would specify the document type is in case different types of sales documents have the same number. If the relationship wasn't created, labels would be created for all sales lines that are in the system with that number.

    1. Select a child line (that is, a line that has a value in the Parent Table No. field).

    2. Select the Table Relations action.

    3. On the Label Table Relations page, populate the following fields:

      Field Description
      Parent Field No. Select the field number in the parent table that will link to the child table.
      Child Field No. Select the field number in the child table that will link to the parent table.
    4. Close the page.

    5. Add the relationships for any other parent and child combinations.

  7. Add the fields you want to print on the label.

    Fields can be added to any line but must be added to the line where the Record to Print check box is selected.

    1. In the Label Tables section, select the line that contains the fields you want to add to the label.

    2. Select the Fields action.

    3. On the Label Table Fields page, populate the following fields:

      Field Description
      Field No Select the field that you want to add to the label.
      No. of Labels

      Select the check box to indicate that you want the field value to determine how many labels to print.

      If the field value is a decimal, the number of labels to print will always round up. For example, if the number is 2.2, then 3 labels will be printed.

      The check box can only be selected for the table where Record to Print is selected and for fields that are a decimal or integer.

      You can only select the check box for one field.

      For the field value to determine the number of labels to print, the label action printer setup must have From Label Table Field Value selected for the No. of Labels Source field.
      Max No. of Labels

      If the No. of Labels check box was selected, enter the maximum number of labels to print.

      Enter zero (0) if there is no maximum number.
    4. Add any other fields that you want to include on the label.

      Important

      The values in the Field Label Name field are what you will copy into the label.

    5. Select Close.

  8. Select Sort Lines to verify the information and sort the lines into the correct order.

  9. Once you have added all of the tables and fields, populate the following field:

    Field Description
    Status

    Select Active to enable the label to be printed from a Print to SENTINEL action, or from a triggering action.

    Changing the status to Active will validate the information.

    The label can now be used to print to SENTINEL.

Add table filters

This step is used when creating the label, and will narrow down the records that will be eligible to print. For example, for the Sales Header table, create a filter for Document Type of Order, which will then only allow labels to be printed for sales orders and not sales invoices, credit memos and so on.

  1. On the Label Card page, in the Label Tables section, select the line to which you want to add the filter.

  2. Select the Table Filters action.

  3. On the Filters window, select the filters you want to add.

  4. Select OK.

    The Table Filter field is populated with the selected filter values.

Copy Label

You can copy an existing label and its setup to a new label. All of the tables, relations, filters and fields will be copied to the new label. You have the option of also copying the label file name.

  1. Choose the icon, enter Labels, and then choose the related link.

  2. On the Labels page, select the label you want to copy.

  3. Select Copy Label.

  4. On the Copy Label page, populate the following fields:

    Field Description
    Target Label Code Enter the name of the label code to be created.
    Copy Filename Turn the toggle on to also copy the label file name.
  5. Select OK.