PANTHEON™ manual

 Categories
[Expand]User Manual for DataLab PANTHEON 5.5
 No formula defined!
[Collapse]Datalab PANTHEON 5.5 Guide
 [Expand]Orders
 [Collapse]Settings
  [Expand]Subjects
  [Collapse]Items
    Environmental Duties
    SLOPAK Packaging Classification
   [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
 Opening or closing round bracket missing!
 Debugging Formulas
[Expand]Testing and Debugging Formulas
 Opening or closing square bracket missing!
 Conditional statement at position x not enclosed in square brackets!
 Syntax error in conditional statement. Correct syntax is [condition:value]
 Adjacent operators (xx)!
 Last character of the formula is an operator!
 Variable not enclosed in hashes (#)!
 Illegal characters: xyz
 Unknown error!
[Expand]User Manual for Datalab PANTHEON Farming
[Expand]User Site
 Adjacent hashes!
 The line number must be an integer (#xx#)!
 The first character of #xx# must be a transaction type or a column mark!
 The first character of #xx# must be an operation type (R, S, O or A)!
 The second character of #xx# must be a transaction type (D, K, S, P, or O)!
 Variable not defined
[Expand]Kralicek Quicktest Financial Ratios

Load Time: 453,1321 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!