PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Collapse]Program
     [Expand]Document Types
     [Expand]Reports in PANTHEON
      Document Texts
      Delivery Methods
     [Expand]Loyalty Cards
     [Collapse]Administration Panel
      [Expand]Right click on Administration panel tree
      [Collapse]Settings
       [Expand]Settings
       [Expand]Colors
       [Expand]Internet
       [Collapse]Company
         General
        [Expand]Document Texts
        [Expand]Rounding
        [Collapse]Register Settings
          Find Item by ID
          Find Item by Name
          Iskanje subjektov - ltSubj
          Lookup type seznam
          Prikaz zaloge za točno določeno skladišče pri izboru artikla
          Prikaz zaloge za vsa željena skladišča pri izboru artikla
          Prikaz cen ki veljajo za določeno skladišče
          Iskanje po nazivu pošte v polju Pošta v šifrantu subjektov
          Prikaz regije i grada kojima subjekt pripada prilikom izbora kupca na dokumentu
         eDocument
        [Expand]Affiliated Companies
         Exchange Rate Import
         API Keys
         Terms of Sale
        [Expand]Calendar
        [Expand]Accounting Dashboard
       [Expand]Subjects
       [Expand]Items
       [Expand]Manufacturing
       [Expand]Orders
       [Expand]Goods
       [Expand]Financials
       [Expand]Personnel
       [Expand]Documentation
       [Expand]Task Autorun
        Extra Menu
        Task scheduler
      [Expand]Security
       Menu
      [Expand]Users and Groups
      [Expand]Versions/Upgrades
      [Expand]Database
      [Expand]ZEUS
      [Expand]OTOS
     [Expand]Dashboard Components
      Dashboard Reports
      Ad-hoc analysis
     [Expand]ARES
      SQL urejevalnik
    [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: 406.2529 ms
"
   2216 | 2671 | 336957 | Updated
Label

Find Item by ID

Find Item by ID

Find Item by ID

010379.gif010380.gif010381.gif010411.gif010382.gif010383.gif

46304.gif

With the Search by Item option you can set the lookup list or table that will open when you click on the Item field in a document.

037080.png

 

Select Statement
 A default statement that can be selected (i.e. select acIdent, acName, anRTPrice from vHE_SetItem WHERE acActive = 'T' ORDER BY acIdent). You can use only one table!
46311.gif
(Refresh Fields) 		If you add a new field to the select statement, click this button and the program will refresh data of the lookup table in the Field section.

 

000001.gif For a more detailed description on the use of a selected statement see Find Item chapter.

 

Enter in the Search Fields table as many rows as you would like columns to appear in the lookup list or table.

 

Line  
Field Name of the field as defined by the select statement. You can select the name from the lookup list:

This information is mandatory (for more information see Field name must be defined!).
Length
 The length of the field as you would like to have for the table.

This information is mandatory (for more information see Field length cannot be zero!).
Format  
Name
 Name that should appear in the title bar of the lookup list or table.

This information is mandatory (for more information see Field title must be defined!)
000001.gif If you delete all lines in the Search Fields table, the program use the predefined search table.
000001.gif For a more specific method to search items by ID see example Stored procedure to search by ID.
000001.gif If you have determined settings that enable you to select external IDs and enter items data with a scanner, the program will not open the lookup table automatically. You will have to click on the arrow first.

Settings to open the lookup table automatically, when you start to enter the item:
  • Enter 0 (used for the scanner) in the Item ID Length field of the Administration Panel | Settings | Program Parameters | Items | General | General;
  • Database: in Read External ID and Show External ID fields of the Administration Panel | Settings | Program Parameters | Items | General | General select Do not use external IDs, and
  • For an individual user: if you have selected Do not use external IDs in the Read External IDs and Show External IDs fields of the Administration Panel | User Groups | User - general | Users | Personal settings |  |Other settings.

 


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!