Skip to main content

Knowledge Center

Serial number templates (SNT)

The Serial number templates (SNT) application is used to specify the numbering scheme of serial numbers for Products (ART), which results in Product units (LCM) with the designated serial numbers.

Various combinations of date formats, free text, user specified sequences, and values of specific fields in RamBase can be used.

Setup in Company settings (CSV)

To open the Company settings (CSV) application from the RamBase menu, select Admin and then Overview. Click on Company settings and then Production, followed by Production again.

Tip

In the Company settings (CSV) application, search for "Serial number" to quickly list the Use SNT archive for serial number setting, and the settings which must be deactivated.

Required setting

Description

Use SNT Archive for Serial Number

This setting must be set to ON to enable the serial number template (SNT) setup . The Serial number templates (SNT) defines the serial number format for Product units (LCMs).

If this setting is activated, all Company settings (CSV) that include 'Serial number' under Production/LifeCycleManagement must be 'OFF'

Listed below are the settings which must be set to 'OFF' - If Use SNT archive for serial number is set to 'ON'

Company setting

Description

Auto Prefix on Serial Number

N/A for new customers, use the new SNT template system.

Description for this old setting:

If this setting is activated, all Company Settings that include 'Serial number' under Production/LifeCycleManagement must be 'OFF' It the setting is 'ON',

Prefix can be set.

Serial numbers are then automatically generated for Purchase Orders (SPO) where the Product has 'Yes' in AutocreateSnoForSPO or Life Cycle's (LCM) where the Product (ART) has 'Yes' in AutocreateSnoForLCM.

The setting 'ProductionSerialNumberCounter' must also be set if serial numbers should automatically be generated.

Automatic Serial Number Model

N/A for new customers, use the new SNT template system. Description for this old setting: Value in this setting must be one of the following alternatives.

Modelnr.1=Skipper's setup :: Serialnumber will be Life Cycle number (LCM) with or without 'ProductionSerialNumberPrefix' setting first.

Modelnr.2=DISPLAY's setup. Modelnr.3=Not in use yet. For new customers, use Modelnr.1.

Skipper's setup :: Serialnumber will be LCM.NO and with or without PREFIX setting.

Serial Number Counter

N/A for new customers, use the new SNT template system.

Description for this old setting: Value in this setting is a parameter that will automatically generate serial numbers for Purchase Orders (SPO) or Life Cycles (LCM), - if Products (ART) has AutocreateSnoForSPO=Yes.

SNOCNT is a counter that will automatically be increased by 1 when a new serial number is generated. The serial number will consist of this parameter and CSV/AutoProductionSerialNumberPrefix concatenated (prefix first). Serialnumber generating will only happen for Productions with LCMDOC=UNIT.

Functionality can't be used if CSV/ProductionSerialNumberModel is set to SerialModel=1. To edit the Serial counter, type 'SNO' in the program line and use the F12 option 'Edit Serial Number Settings'

Serial Number Prefix

N/A for new customers, use the new SNT template system.

Description for this old setting:

Value in this setting is a Prefix of serial numbers. The value will be set before Serial number counter or Serial number from Modelnr.1.

Functionality doesn't work when using Serial number from Modelnr.2

Serial Number Prefix Field from Product (ART)

N/A for new customers, use the new SNT template system.

Description for this old setting:

Value in this setting is GR1.

Information from this field on Product (ART) will be used as prefix.

Functionality is not valid for Serial number Model.2. If CSV/ProductionSerialNumberPrefix has a value, this setting will be overridden GR1Classification

Serial Number Start for Pilot Product Productions

N/A for new customers, use the new SNT template system.

Description for this old setting:

LifeCycle (LCM) serial sequence number for pilot series production (Product status=3).

If value in the setting is '10', - LifeCycle (LCM) serial number after ""<part>"" will start on '10' or last used above 10+1.

This functionality will only work if the setting ProductionSerialNumberModel has value=2

Serial Number Start for Prototype Product Productions

N/A for new customers, use the new SNT template system.

Description for this old setting:

Value in this setting is a number. If value is '1', - LifeCycle (LCM) serial sequence number for prototype production (Product status=2 will get LifeCycle (LCM) serial number after "<part>" start on '1'.

This setting will only work if the setting ProductionSerialNumberModel has value=2

Serial Number Start for serial Productions

N/A for new customers, use the new SNT template system.

Description for this old setting:

Value in this setting a number that is used when calculating Serial sequence number for serial production (Product in Status=4). If the value is '100' -

LifeCycle serial number (after ""&lt;part&gt;-"") will start on '100' or last used above 100 + 1. This setting will only work if the setting ProductionSerialNumberModel has value '2'

Overview

To open the Serial number templates (SNT) application from the RamBase menu, select Product followed by Product management and finally Serial number templates.

SNT_Overview.jpg

  1. Serial number templates list - Left side

  2. Header - Right side

  3. Tabs - Right side

  4. Create new serial number template button

  5. Create a new serial number element button

  6. Add new applied product button (Same location as 5.,can be found in the Applied products tab).

  7. Context menu options

Serial number templates list - Left side

The left side is is made up by a header, list and the button to create new serial number templates.

Header

The Header allows the filtering of the list.

The Search field, Filter builder and Column settings uses standard RamBase functionality.

Read more about:
List

The Serial number templates (SNT) are listed here.

Note

Note that when Serial number templates (SNT) are created, they can only be differentiated by their identifier, "SNT/10000". Adding information to the Description field allows for quicker identification and categorization.

Column

Description

St

Displays an icon indicating the current status of the Serial number template (SNT).

Potential statuses for Serial number templates (SNT) are:

  • Status 1 - Pending activation

  • Status 4 - Active

  • Status 9 - Deactivated

Template id

Displays the Serial number template identifier (SNT).

Example:

"SNT/100000"

Description

Displays the description of the Serial number template (SNT). Can be edited while the Serial number template (SNT) is in Status 1 - Pending activation by clicking and editing the Description field in the Serial number template area.

Product status

Displays the current Product (ART) status.

Optional - If a value is present, the Serial number template (SNT) is only valid for Products (ART) of the selected status.

Can be edited while the Serial number template (SNT) is in Status 1 - Pending activation by clicking and editing the Product status drop-down menu in the Serial number template area.

Potential Product (ART) statuses are:

  • Status 1 - Pending activation

  • Status 2 - Pending documentation

  • Status 3 - Pending approval

  • Status 4 - Approved product

  • Status 5 - Pending revision

  • Status 6 - Pending problem solution

  • Status 7 - Pending expiration confirmation

  • Status 8 - Pending expiration date

Buttons

Button

Description

SNT_Create_new_serial_number_template_button.jpg

Used to create new Serial number templates (SNT) in Status 1 - Pending activation.

  1. To create a Serial number template (SNT) in Status 1 - Pending activation, click the Create new serial number template button.

  2. In the following popup, click the Create button.

    Result: A Serial number template (SNT) is now created in Status 1 - Pending activation.

  3. To differentiate the new Serial number template (SNT), add a Description in the Description field in the Header area, on the right side.

  4. Select which Product status the Serial number template (SNT) should apply for, by selecting an option in the Product status drop-down menu.

Serial number template area - Right side

The Serial number template area includes a header along with organized tabs allowing the user to customize, maintain and count serial numbers.

Header

The header allows the user to set a description for the selected Serial number template (SNT) along with option deciding which Product (ART) statuses the serial number should apply for.

  • Description field - Description of the Serial number template (SNT). Can be edited while the Serial number template (SNT) is in Status 1 - Pending activation.

    Tip

    It can be useful creating a Description early, as Serial number templates (SNT) in the left side list, in the Serial number templates area are initially only distinguished by identifiers,

  • Product status drop-down menu - This is an optional drop-down menu - If used the template is only for Products (ART) with the selected status.

    Can be edited while the Serial number template (SNT) is in Status 1 - Pending activation by clicking and editing the Product status drop-down menu.

    Optional Product (ART) statuses are:

    • Status 1 - Pending activation

    • Status 2 - Pending documentation

    • Status 3 - Pending approval

    • Status 4 - Approved product

    • Status 5 - Pending revision

    • Status 6 - Pending problem solution

    • Status 7 - Pending expiration confirmation

    • Status 8 - Pending expiration date

Tabs

The tabs are organized to allow the user to build the serial number template, apply the serial number template to products and view the usage of the serial number template.

Elements tab

The Elements tab is used to build the Serial number template (SNT).

Column

Description

Order index

Line number for the Serial number template (SNT). Is used for ordering the lines when building the Serial number template (SNT).

Content type

The source of the serial number string.

Potential content types:

  • TEXT - A fixed text.

  • DATEFORMAT - A date, in a format decided when creating a serial number element.

  • FIELD - A specific field in RamBase.

  • SEQUENCE - A system managed counter.

Content

This column will be populated based on the selection of Content type:

TEXT

  • A fixed, user defined text.

FIELD - Given field from RamBase

  • LCMNO - Product unit id

  • PART - Product name

  • PWONO - Production work order id

  • PWOREVISION - Production work order product revision

  • PWOPRODSTART - Production work order scheduled start date

    Note

    If PWOPRODSTART is selected, a date format must be selected in the Format drop-down menu.

SEQUENCE - A system managed counter

The user has defined:

  • Length

  • Fill

  • Start value

Format

If the selected Content type is DATEFORMAT or the FIELD option PWOPRODSTART - Production work order scheduled start date, one of the following formats will be displayed:

DATEFORMAT

  • YYYYMMDD - Full date (length 8)

  • YYYY - Year (length 4)

  • YY - Year (length 2)

  • MM - Month (length 2

  • DD - Day of month (length 2)

  • WW - Week number (length 2)

  • DAY - Day number in week (length 1)

  • DDD - Number of day in year

Length

If the length is set to > 0 (greater than 0) means the sequence will have a fixed length, and filled from the left using the Filler value.

Filler

The character filled in when this is a sequence with Length field > 0. (Usually '0').

Sequence start value

The start value if the selected Content type is SEQUENCE.

Has sequence dependence

Changes in this value will make the counter cycle back to its Sequence start value.

edit.svg

bin.svg

To edit an element, the Serial number template (SNT) must be in Status 1 - Pending activation. Click the Edit icon make the adjustments in the popup.

To delete an element, click the Delete icon.

Buttons

Button

Description

SNT_create_new_serial_number_element.jpg

Create a new element by clicking Create new serial number element button.

  1. You can either search for an element, or create a new element by clicking Create new serial number element button.

  2. Click and type the Order index for the element in the Order Index field. The Order Index determines the order of display, with the lowest Order Index being the left-most element.

    2020-08-24_14-50-36.png

  3. Select the Content Type in the drop-down list. There are four content types:

    1. TEXT, select this content type to specify up to 39 characters of the serial number in the Content field.

    2. DATEFORMAT, the format values are:

      DATEFORMAT

      • YYYYMMDD - Full date (length 8)

      • YYYY - Year (length 4)

      • YY - Year (length 2)

      • MM - Month (length 2

      • DD - Day of month (length 2)

      • WW - Week number (length 2)

      • DAY - Day number in week (length 1)

      • DDD - Number of day in year

    3. FIELD, which allows you to choose between the values:

      FIELD - Given field from RamBase

      • LCMNO - Product unit id

      • PART - Product name

      • PWONO - Production work order id

      • PWOREVISION - Production work order product revision

      • PWOPRODSTART - Production work order scheduled start date

      1. If the Content Type is specified to be TEXT, DATEFORMAT or FIELD, select Has Sequence Dependence if the numbering sequence is to restart for every new value of TEXT, DATEFORMAT or FIELD.

        For example, if Has Sequence Dependence is selected in the DATEFORMAT, every change of either the day, week or year restarts the auto-generated numbering in SEQUENCE.

    4. SEQUENCE, a system-generated incremental counter.

      2020-08-24_14-50-36.png

      Specify the Length, Fill and Start Value. Specify the fill characters in the Fill field. Specify the start value in the Start Value field.

      Specify the Length, Fill and Start Value. Specify the fill characters in the Fill field. Specify the start value in the Start Value field.

Applied products tab

The Applied products lists all Products (ART) which the Serial number template (SNT) applies for. The user may use the Add new applied product to link the Serial number template (SNT) to the selected Product (ART).

Icon

Description

Product id

Displays the Product identifier (ART) of the product the Serial number template (SNT) applies for.

Product name

Displays the name of the Product (ART) the Serial number template (SNT) applies for.

Product structure revision

Displays the Product structure (KITART) revision the Serial number template (SNT) applies for.

bin.svg

Delete icon

To remove a linked Product (ART) from the Serial number template (SNT), click the Delete icon.

  1. To remove a linked Product (ART) from the Serial number template (SNT), click the Delete icon.

  2. To confirm, click OK in the following popup.

Buttons

Button

Functionality

SNT_Add_new_applied_product_button.jpg

Note

The serial numbers are created when the Production work order (PWO) is released for production, set from a status lower than 4 to a status of 4, or higher. RamBase searches for the Serial number template (SNT) linked to the products in the Production work order (PWO), and uses any Serial number template (SNT) linked to the product to create the serial number.

If a linked Serial number template (SNT) is not found, a Serial number template (SNT) without linked products is used.

  1. To add a new applied product to the Serial number template (SNT), click the Add new applied product button.

  2. In the following popup, click Product drop-down menu and select which Product (ART) the Serial number template (SNT) is to apply for.

  3. Select which revision of the Product (ART) the Serial number template (SNT) applies for, in the Revision drop-down menu.

  4. To finish adding the applied product, click the Create button.

    Result: The applied product will be listed in the Applied products tab.

Counters tab

Column

Description

Dependence value

Generated for elements of Content type; TEXT, DATEFORMAT or FIELD which has the checkbox Has Sequence dependence enabled, if the element also has a Sequence value.

If there is no Content, the Sequence start value will be used.

The result is a unique serial number.

Sequence value

Last used sequence number on the serial number with Dependence value.

Updated at

System generated date of when last update of was made to the element.

Context menu options

The Context menu options are located in the top-right Header and be expanded by clicking the Context menu options icon.

3dots.svg

Context menu options icon

The available context menu options are listed below:

Context menu option

Description

Open for edit

Will set the selected Serial number template (SNT), from Status 4 - Active or Status 9 - Deactivated, to Status 1 - Pending activation.

Note

If a Serial number template (SNT) has elements of Content type SEQUENCE, and serial numbers have been generated, the Serial number template (SNT) can not be opened for edit.

Activate serial number template

To forward the Serial number template (SNT) from Status 1 - Pending activation to Status 4 - Active, select the Activate serial number template option.

Warning

It is recommended to complete all edits before activating the Serial number template (SNT) as it can not be reverted to Status 1 - Pending activation and edited, after serial numbers have been generated for Product units (LCM), as can be inspected in the Counter tab.

Close serial number template

To set a Serial number template (SNT) in Status 9 - Deactivated, select the Closer serial number template option.

Tip

A deactivated Serial number template (SNT) can easily be reactivated, setting it from Status 9 - Deactivated to Status 4 - Active, by selecting the Activate serial number template context menu option.

In this section: