PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [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
   [Collapse]Old products
     Additional Programs (OLD)
     Web Portals (OLD)
    [Expand]Accounting dashboard (OLD)
     Microsoft Word Add-in (OLD)
     Extra (OLD)
    [Collapse]Uradna pojasnila (OLD)
      Poslovanje z gotovino po novem
      Statistični urad RS - SKIS
      Zaokroževanje
     [Collapse]Data Exchange by OVD standard from version 556700
       Izvoz podatkov iz programa Pantheon
      [Collapse]Uvoz podatkov v program Pantheon
       [Expand]Import Invoices from Custom Excel File in Accounti
       [Expand]Import invoices as entry in accounting service fro
      [Expand]Nastavitve
     [Expand]Izmenjava podatkov po standardu OVD
     [Expand]DDV
    [Expand]Authorizations - General
     Comparing permissions
     Propagade Security
     Permissions
    [Expand]Documentation
    [Expand]Test Page
    [Expand]E-Commerce
    [Expand]Old ZEUS user manual
    [Expand]Guide Archive - Guide for PANTHEON (OLD)
  [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: 390.627 ms
"
   1005389 | 217818 | 352991 | Published
Label

Import Invoices from Custom Excel File in Accounti

Import Invoices from Custom Excel File in Accounting Firm

010381.gif010411.gif010382.gif010383.gif

 

This option is very useful when we want to import data from excel file that does not have columns in Pantheon default (template) order.

We start an import from journal entry (DT470). Open new document type and call Data Exchange by OVD Standard function on Wizard button.

 

New window opens. We set parameters on Preparation panel. Example bellow is for received invoices import. As soon as option Custom Microsoft Excel Type of import is marked, new panel Settings for custom import appears.

 

 

 

 

File Path Enter path to file location.

Fill In Missing Registers on Transfer

 Marked option will expand registers with missing subjects, Subject name 2, Address, ... when trigger button. Not all registers can be expand this way. Register which will never expand by using this options are: Item, Country, Clerk, VAT Type, and some other.
Type of import Use Template Custom Microsoft Excel option.
Invoices Received/Issued Choose one option. Marked Issued will import either issued invoices (customers) or option Received will import received invoices (suppliers).
Document Type

We choose document type reserved for entry in accounting firm from drop down menu.
 
Per Date Enter date. This date will become Date Posted and Target Date in journal entry.
We use button Load to import positions from excel file. We can use enclosed template because the order of columns is important. Lines import stars from line 2.
We use button Post for creating of invoices.

 

 

000001.gif Before Loading data from excel file, Settings for custom import need to be done.
000001.gif Data can be import only from saved excel file to assure correct import.
000001.gif

Be sure to have all registers up to date before import invoices and entries. This is the only way to get satisfied result.
000001.gif

Data import starts from line 2.

 

See more details about import by following links:

Import invoices as entry in accounting service from Excel

Import invoices only as entry in accounting firm

Import invoices as entry in accounting service with postings

 


 

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