PANTHEON™ manual

 Categories
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Collapse]Items
      SLOPAK Packaging Classification
      Environmental Duties
     [Expand]Items
     [Expand]Item Types
     [Expand]Item Categories
     [Expand]Units of Measurement
     [Expand]Pricing Formulas
      Import Price List
     [Expand]Serial Number Templates
      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
 [Expand]User Manuals for PANTHEON
[Expand]PANTHEON Web
[Expand]PANTHEON Granules
[Expand]User Site

Load Time: 984.3717 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!