PANTHEON™ Help

 Kazalo
 Glavna stran - Dobrodošli v PANTHEON navodila
[Collapse]PANTHEON
 [Collapse]Vodiči za PANTHEON
  [Collapse]Vodič po PANTHEON-u
   [Expand]Pomoč
   [Expand]Nastavitve
   [Expand]Naročila
   [Expand]Proizvodnja
   [Expand]Blago
   [Expand]Servis
   [Expand]Denar
   [Expand]Kadri
   [Expand]Namizje
   [Expand]Analitika
   [Expand]Sporočila programa
   [Collapse]Uradna pojasnila
     Poslovanje z gotovino po novem
     Statistični urad RS - SKIS
     Zaokroževanje
    [Collapse]Izmenjava podatkov po standardu VOD od verzije 556700
      Izvoz podatkov iz programa Pantheon
     [Collapse]Uvoz podatkov v program Pantheon
       Import of Invoices for Accounting Firms from Custo
      [Collapse]Uvozi račune kot vnos v računovodski servis za
        Uvozi račune samo kot vnos v računovodski servis
        Uvozi račune kot vnos v računovodski servis z
      [Expand]Uvozi račune iz prilagojene Excel datoteke v računovodstvu
     [Expand]Nastavitve
    [Expand]Izmenjava podatkov po standardu VOD
    [Expand]DDV
   [Expand]Sistemsko okolje
   [Expand]Dodatni programi
    Slovar izrazov
   [Expand]Zastareli produkti
  [Expand]Vodič po PANTHEON Farming
  [Expand]Vodič po PANTHEON Retail
  [Expand]Vodič po PANTHEON Vet
 [Collapse]Uporabniški priročniki za PANTHEON
  [Expand]Uporabniški priročnik za PANTHEON
  [Expand]Uporabniški priročnik za PANTHEON Retail
  [Expand]Uporabniški priročnik za PANTHEON Vet
[Collapse]PANTHEON Web
 [Collapse]Vodiči za PANTHEON Web
  [Expand]Vodič po PANTHEON Web Light
  [Expand]Vodič za PANTHEON Web Terminal
  [Expand]Vodič za PANTHEON Web Legal
  [Expand]Arhiv starih izdelkov
 [Collapse]Uporabniški priročniki za PANTHEON Web
  [Expand]Kako začeti
  [Expand]Uporabniški priročnik za PANTHEON Web Light
   Uporabniški priročnik za PANTHEON Web Terminal
  [Expand]Arhiv starih izdelkov
  [Expand]Uporabniški priročnik za PANTHEON Web Legal
[Collapse]PANTHEON Granule
 [Collapse]Vodiči za PANTHEON Granule
  [Expand]Granula Kadri
  [Expand]Granula Potni nalogi
  [Expand]Granula Dokumenti in Opravila
  [Expand]Granula Nadzorna plošča
  [Expand]Granula B2B Naročanje
  [Expand]Granula Servis na terenu
  [Expand]Inventar fiksnih sredstev
  [Expand]Granula Inventura skladišča
 [Collapse]Uporabniški priročniki za PANTHEON Granule
   Začetek
   Primer uporabe PANTHEON Granul v namišljenem podjetju
  [Expand]PANTHEON Granule in aktivacija
  [Expand]Granula Kadri
  [Expand]Granula Potni nalogi
  [Expand]Granula Dokumenti in opravila
  [Expand]Granula B2B naročanje
  [Expand]Granula Nadzorna plošča
  [Expand]Granula Servis na terenu
  [Expand]Granula Inventura osnovnih sredstev
  [Expand]Granula Inventura skladišča
   PANTHEON Granule - pogosta vprašanja in odgovori
   Arhiv
[Expand]Uporabniške strani

Load Time: 593,7618 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!