PANTHEON™ Help

 Toc
 Početna stranica - PANTHEON uputstva
[Collapse]PANTHEON
 [Collapse]PANTHEON priručnici
  [Expand]Vodič po Datalab PANTHEON FarmAccounting
  [Expand]Vodič po PANTHEON Retail
  [Expand]Vodič po DataLab PANTHEON™
  [Expand]Vodič po PANTHEON VET
 [Collapse]PANTHEON korisnički priručnici
  [Expand]Korisnički priručnik za DataLab PANTHEON
  [Expand]Korisnički priručnik za PANTHEON Vet
  [Expand]Korisnički priručnik za PANTHEON Maloprodaju
  [Expand]Korisnički priručnik za PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Vodiči po PANTHEON Web
  [Expand]Vodič za PANTHEON Web Terminal
  [Expand]Vodič po PANTHEON Web Light
  [Expand]Vodič za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
 [Collapse]Korisnički priručniki za PANTHEON Web
  [Expand]Kako započeti s programom PANTHEON Web
  [Expand]Korisnički priručnik za PANTHEON Web Light
   Korisnički priručnik za PANTHEON Web Terminal
  [Expand]Korisnički priručnik za PANTHEON Web Legal
  [Expand]Arhiva starih proizvoda
[Collapse]PANTHEON Granule
 [Collapse]Vodič za PANTHEON Granule
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula Nadzorna ploča
  [Expand]Granula B2B naručivanje
  [Expand]Granula Servis na terenu
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Granula Inventura skladišta
 [Collapse]Korisnički priručnik za PANTHEON Granule
   Početak
   Primjer korištenja PANTHEON Granula u fiktivnom preduzeću
  [Expand]PANTHEON Granule i aktivacija
  [Expand]Granula Kadrovi
  [Expand]Granula Putni nalozi
  [Expand]Granula Dokumenti i zadaci
  [Expand]Granula B2B Naručivanje
  [Expand]Granula Nadzorna ploča
  [Expand]Granula Servis na terenu
   PANTHEON Granule - česta pitanja i odgovori
  [Expand]Inventar Fiksne Imovine Granula
  [Expand]Inventar u skladištu granula
  [Expand]Arhiva
[Collapse]Korisničke stranice
  Test 2
  Test 3
  Test 5
  TEST_Kreiranje noveg zaposlenika 1000003067
  TEST_Kreiranje noveg zaposlenika 1000003067-MK
  TEST3_Kreiranje novog dokumenta 1000003410-SL
  TEST2_Uređivanje kontaktnih podataka 1000003415-SL
  Test
 [Collapse]Test za CG
   Test podređeni 1
  TEST_Kreiranje noveg zaposlenika 1000003067-BA
  TEST_Kreiranje novog zaposlenika 1000003067-SR
  TEST_Kreiranje noveg zaposlenika 1000003067_EU_ORIG
 [Collapse]Pantheon hosting
  [Expand]Hosting robot
  [Expand]DEMO hosting
  Porez ( cookies )
 [Collapse]Prijava na korisničke stranice
   Registracija za Pantheon korisnike
   Glavna stranica
   Prva posjeta korisničkom sajtu
  Novosti
  Uvod u Wiki
  Upute za stranicu izbornika
 [Collapse]Potpora
  [Expand]Tehnička podrška
   Podrška na daljinu za Host korisnike
  [Expand]Daljinska podrška
  Kako upotrebljavam i dopunjujem wiki ?
 [Collapse]Pomoć
   Pantheon Hosting
   Uporedba verzija pantheona
  [Expand]Dokumentacija
   Vsa navodila
   Video uputstva
   Video novosti
   Pitaj druge korisnike
   Postanite PANTHEON svetovalec
   Sve vijesti
   Svi događaji
   Pregled opomb i planova
   Plan
 [Collapse]Informacije
   Obavijesti
  [Expand]Nastavitev deviznih tečajev
 [Collapse]Moji podaci
   Ugovor o osvježavanju
   Podaci o kompaniji
  [Expand]Pooblaščene osobe
   Dovoljenja
   Lični podaci
   Kontaktni podatci
   Osveževalna pogodba
 [Collapse]Forum
   Spremljanje foruma
 [Collapse]Video
   Instruktivni videozapisi
   Video Ažuriranja
  Portal za razvijače
  Tržnica
 [Collapse]Wiki uputstva
  [Expand]Uvod u wiki
  [Expand]Pretraga po Wikiju
  [Expand]Uređenje Wiki-a
   Pripenjanje dokumentov

Load Time: 359,398 ms
"
   6613 | 1 | |
Label


Import Journal Entry from Excel File

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

This function is used for importing entries from an Excel file according to a predefined structure. 

It can be accessed by clicking the  (Import/Export Data) button.

File Path

 File path to the Excel file.

Open

 Opens the Excel file before import.
Transfer Transfers the data into the journal entry.
Register Overview PANTHEON checks if the prepared data matches the existing registers in the program.
Fill In Missing Registers on Transfer

If checked, enables you to add the missing entries in registers (subjects, chart of accounts, cost centers) upon transfer.
Convert to foreign currency from local currency Converts to the currency entered in the Excel file based on the entered exchange rate and currency.
Convert to local currency from foreign currency Converts to the local currency from foreign currency entered in the Excel file based on the entered exchange rate and currency.
Import only data without errors

If checked, the program will only import data with no errors to the journal.

If not checked and if data with errors exists, program will not perform the import (regardless of whether the data contains errors or not) and will display the following information window:

 

If amounts in colum Debit and/or Credit consist of more than two decimal places, following IRIS appears:

 

Excel file should contain following columns in the following order:

  • Journal entry number (if you want to import data into a specific journal entry)
  • Period date for journal entry (if you want to import data into a specific journal entry)
  • Account
  • Subject
  • Debit
  • Credit
  • Document
  • Linked Document
  • Document Date
  • Value Date (Due Date)
  • Currency
  • Exchange Rate
  • Department
  • Cost Center
  • Note
  • Contra Account
  • VAT Date
  • External Document
  • Status (cannot be automatically populated upon transfer)
  • Status name
  • Value Debit (by default, the currency values are populated according to the exchange rate if there is no value entered here)
  • Value Credit  (by default, the currency values are populated according to the exchange rate if there is no value entered here)

You can use the template or check the sample file.

WARNING

To import data to the currently open journal entry, you need to specify the Journal entry number and Period date for journal entry of the given journal entry in the Excel file before import.

 

 

RELATED TOPICS:

  Journal Entry Toolbar  

  Import/Export Data
HINT

Since different reports are calculated with different date and other criteria as well as being shown in different reports you are recommended to save them as templates. Templates are linked to a specific financial report format which makes work with templates easier.

 

Financial reports that are used more frequently you can assign a shortcut in the toolbar!
  

     


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