PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Collapse]Goods
    [Expand]Mass Printing
     Integration PANTHEON with WebShops
    [Expand]Issue
    [Expand]Receiving
    [Expand]Single Administrative Document (SAD)
    [Expand]Transfer
    [Collapse]Price change
     [Collapse]Price change task bar
       Mass Price Change
       Import Price List
       Sprememba davčne stopnje
       Obrazac o promjeni cijena i marže u maloprodaji
       Price change reports
     [Expand]Change of price document header
      Task bar of the price change positions
     [Expand]Lines of price change
      Data on value of the price change
      Price Change - Posting by Retail Price
      Popravljanje maloprodajnih in prodajnih cen na osnovi spremembe cene (12D in 12E)
     [Expand]Price Change Reports
    [Expand]Inventory count
    [Expand]Recurrent Invoicing
     Create Consignment Report
    [Expand]Prepare cash discount
    [Expand]Custom warehouses
    [Expand]Stock
    [Expand]Trošarinska skladišča
    [Expand]Material Movements
    [Expand]Income/Expense Comparison
    [Expand]Invoices Issued Report
    [Expand]Invoices Received Report
    [Expand]Value-Added Tax
    [Expand]Overview of Material Movement
    [Expand]Summary Reports
    [Expand]Refresh Stock
   [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: 468.7789 ms
"
   6128 | 6716 | 339223 | Published
Label

Import Price List

Import Price List

Import Price List

010411.gif010382.gif010383.gif010381.gif

The DataLab Pantheon™ program pack allows for maintaining of the price list outside of the application and its transfer into the application. This means that the price list can be formed in the table (for example in Microsoft Excel), other database (for example dBase) or even in the text editor. Beside that, this option is also used with the companies, that have geographically separated branches, and have to ensure same prices in all places of business.

Selecting the function "Import of the price list" opens the window, in which you set the file with the price list and path to it:

000514.gif

When you enter the name of the file and path to it, the program automatically transfers the prices from selected file into the items register.

The file for transfer has to be in dBase III format. The mandatory data is the field ITEM with a proper structure (see structure from the asset file), where the field ITEM is the primary key. Example of the import file structure:

Field NameType LengthDecimals (Description)
IDENT Character 16  Item ID
NAZIV Character 40 Name of the item
PRODCENA Numeric 13 2 Retail price with tax
MPCENA Numeric 13 2 Retail price without tax
VPCENA Numeric 13 2 Wholesale price 1
VPCENA2 Numeric 13 2 Wholesale price 2
SESTAVNICA Numeric 13 2 Price of Bill Of Material
NABACENA Numeric 13 2 Purchase price of the item

 


 

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