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
       [Collapse]Import invoices as entry in accounting service fro
         Import invoices only as entry in accounting service
         Import invoices as entry in accounting service wit
      [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: 453.1252 ms
"
   1004893 | 217363 | 352303 | Published
Label

Import invoices

Import invoices only as entry in accounting firm

010381.gif 010411.gif 010382.gif 010383.gif

We start 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 issued invoices import.

 

 

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 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.

 

Template for import of invoices:

Excel file need the columns in the following sequence on tab 1 (Invoices):

 

A Key Just for orientation, key in another program. The same number represents the position of the same account.
B Date  
C Date of invoice  
D Date of VAT  
E Date Due  
F Document 1  
G Date of document 1  
H Document 2  
I Date of document 2  
J Type of purchase / sale Type of purchase can be chosen from drop down menu. If there is no type of purchase, default will be import. Default is VAT registered.
K Subject code Missing subjects will be add to register if there is marked Fill in Missing Registers on Transfer option.
L Subject Name 2 Missing data will be import to the invoice and subject register when subject is missing (first entry to register only).
M Address Missing data will be import to the invoice and subject register when subject is missing (first entry to register only).
N Post Post number will be add to the post number register when it is missing and if it is marked Fill in Missing Registers on Transfer option.
O City City will be entered from Post number when Post exits in register. When there is no post in register the name of city will be enter to register together with post number.
P Country Country can not be add to the register by import.
Q Subject ISO Code Subject ISO Code can not be add to the register by import. The notice will appear on Errors tab! We have to change the code or add it to register to continue import of invoices.
R Subject's VAT Code Missing data will be import to the invoice and subject register when subject is missing (first entry to register only).
S Type of subject We need to be very careful with importing of Subject types. Subject Type will be added to subject register but not in Subject Types register.
T Department Department in invoice header.Missing department will be add to register if there is marked Fill in Missing Registers on Transfer option.
U Payment method Missing payment method will be add to register of payment methods but without settings in other columns. We suggest to add and set payment methods before import invoices.
V Clerk Pantheon will import current user as clerk even there are some other clerk names in spreadsheet.
W Item Items need to be in Item register before import.
X acNote  
Y Qty  
Z UM Missing units of measurement will be add to register if there is marked Fill in Missing Registers on Transfer option.
AA Price  
AB Discount (%)  
AC VAT code VAT codes need to be in VAT register before import.
AD Department Department in invoice positions. Missing department will be add to register if there is marked Fill in Missing Registers on Transfer option.
AE Cost Ctr. Cost center refers to invoice positions. Missing cost centers will be add to register if there is marked Fill in Missing Registers on Transfer option.
AF Account number Account number will be add to Chart of accounts, but it will not be possible to post invoices before set the new account. We suggest to add all account numbers before import invoices.
AG  Currency Currency for document
AH FX rate FX rate for currency
AI Fiscal number Fiscal number of receipt
AJ IID ZOI or ZKI
AK UIIM EOR- uinique identificator of receipt 
AL No.of copies Number of issued copies of receipt (related to fiscalization of receipt)

 

 

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.

 

 

We can use template and sample file:

  1. template and sample file for import of invoices without entries.
RELATED TOPICS:

  Import invoices from Custom Excel file in Accounting firms

 


 

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