PANTHEON™ manual

 Categories
 Скласти тех карту
[Expand]User Manual for DataLab PANTHEON 5.5
[Collapse]Datalab PANTHEON 5.5
 [Expand]Orders
 [Collapse]Settings
  [Expand]Subjects
  [Collapse]Items
    SLOPAK Packaging Classification
    Environmental Duties
   [Expand]Items
   [Expand]Item Types
   [Expand]Item Categories
    Units of Measurement
   [Expand]Pricing Formulas
    Import Price List
   [Expand]Serial Number Templates
    Quick Pricing
   [Expand]Fixed Prices
   [Expand]Find Item
   [Expand]TouchScreen Profiles
    Packaging and Packaging Waste
    Waste Materials
  [Expand]Manufacturing
  [Expand]Personnel
   Calendar
  [Expand]Financials
  [Expand]Customs
  [Expand]Program
 [Expand]Manufacturing
 [Expand]Goods
 [Expand]Service
 [Expand]Financials
 [Expand]Personnel
 [Expand]ZEUS Business Intelligence System
 [Expand]Desktop
  Web Portals
  Extra
 [Expand]Datalab Software System Environment
 [Expand]Messages and Warnings
 [Expand]Additional Programs
 90632
[Expand]Pantheon RA (android POS) guide
[Expand]Довідник користувача Datalab PANTHEON Farming
[Expand]User Site

Load Time: 750,061 ms
print   |
Label

Import Price List

Import Price List

010382.gif010383.gif010381.gif

 

With the PANTHEON suite you can keep a price list outside the application and import it for use in the program. This means that you can create a price list in a spreadsheet (Microsoft Excel for example), external database (dBase, for instance), or evem with a word processor! Moreover, this option is useful for companies with geographically dislocated branches which must use the same prices in all stores.

Selecting the Import Price List (Goods | Price Change), opens a dialog where you can specify filepath:

023869.jpg

Upon entering or seleting price list file and clicking Open, the prices are automatically transferred to the Items register.

The file for transfer must be in dBase III format. The IDENT field with the appropriate structure (see file structure) where the IDENT is primary key is required. See below for file structure:

Field Name Type   
               
Length Decimal Places (Description)
IDENT Character 16   Item ID
NAZIV Character 40   Item name
PRODCENA Numeric 13 2 Retail price including tax
MPCENA Numeric 13 2 Retail price excluding tax
VPCENA Numeric 13 2 Wholesale price 1
VPCENA2 Numeric 13 2 Wholesale price 2
SESTAVNICA Numeric 13 2 Specification price
NABACENA Numeric 13 2 Item's purchase price


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