PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Collapse]Items
      Environmental Duties
      SLOPAK Packaging Classification
     [Expand]Items
     [Expand]Item Types
     [Expand]Item Categories
     [Expand]Units of Measurement
     [Expand]Pricing Formulas
      Import Price List
     [Collapse]Serial Number Templates
      [Expand]Product Variants
      [Collapse]Enter Serial Numbers
        ID and Document Line in Serial Number
        Example of Serial Number Usage: Traceability of Beef
      Quick Pricing
     [Expand]Fixed Prices
      Find Item
     [Expand]TouchScreen Profiles
      Packaging and Packaging Waste
      Waste Materials
      Šifrant vrst odpadnega materiala
      Šifranti okoljskih dajatev
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Expand]Program
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 421.8828 ms
"
   3088 | 3486 | 337390 | Updated
Label

Key and Document Line Numbers in Serial Numbers

ID and Document Line in Serial Number

010379.gif010381.gif010411.gif010382.gif010383.gif

 

EXAMPLE:

It often happens that one would like to edit the compound serial number so that it would contain ID and document line number.

That is, to use the compound serial number of the following format:

  • KKKKKKKK-LLLLDDDDDDD

where

KKKKKKKK - represents the key (ID) of document of receiving

LLLL - line of document of receiving

DDDDDDD - date of manufacturing

In order to provide such a structutre, two fields of the compound serial number are implemented:

  • KLJUCPOZ - to include key (ID) and line
  • DATUMIZD - to include date of manufacturing

The KLJUCPOZ field can be formatted so that the default value is entered in the SQL statement:

  • KLJUCPOZ;select '#KLJUC#' + '-' + Cast(#POZ# as Char(4))

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!
BOYANVAS29.06.2017Copy from site "KLJUCPOZ;select '#KLJUC#' + '-' + Cast(#POZ# as Char(4))" , paste in Pantheon does not work. There is something wrong in the example.