Pogledaj uputstva za PANTHEON™

 Categories
 Скласти тех карту
[Expand]User Manual for DataLab PANTHEON 5.5
[Collapse]Datalab PANTHEON 5.5
 [Expand]Orders
 [Expand]Settings
 [Expand]Manufacturing
 [Collapse]Goods
  [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
   [Expand]Change of price document header
    Task bar of the price change positions
    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]Inventory count
  [Expand]Recurrent Invoicing
   Create Consignment Report
  [Expand]Custom warehouses
  [Expand]Stock
  [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]Refresh Stock
  [Expand]Summary Reports
 [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: 453,131 ms
print   |
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!