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
    [Expand]Price change
    [Collapse]Inventory count
     [Collapse]Inventory Count Task Bar
       Import/Export Data - Inventory
      [Expand]Reports - inventory count
      [Expand]Inventory Count Wizards
      Inventory Count Header
     [Expand]Inventory Count Lines
     [Expand]Inventory Lines Functions (Buttons)
      Data on inventory value
      Inventory Excesses - Reversing Costs
      Uskladitev stanja količin in serijskih številk
    [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: 546.8503 ms
"
   1000001496 | 221163 | 372237 | Published
Label

Import lines from Excel file

 

You can import lines for the Inventory from a previously created Excel file.

Before the import process, you must first fill in the contents of the header of the document, determine the warehouse, and then save the document.

For complete content relevance, you must prepare the appropriate structure of the Excel file where at least the first two content columns must be completed.

Column A = Item
Column B = Quantity
Column C = Serial number (optional)
Column D = Serial number valid date (optional)
 

Example of creating Excel content for further import of the inventory of the stock into the program:

 

 

000001.gif For successful import of data, the items must be entered in the Item Register !
 
000001.gif

The first row of columns for importing the stock opening is for column names, so the program does not take it into account when importing. The name of the Excel file can be arbitrary (eg: Inventory_WarehouseName). Use an Excel 97-2003 or less XLS file to work.
 

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