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:
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 Name | Type |
Length | Decimals |
(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 |