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
   [Collapse]Financials
    [Expand]Accounting Basics
    [Expand]Posting
    [Expand]Automatic Posting
    [Expand]Accounting Dashboard
    [Expand]Overview
    [Expand]Close
    [Expand]Accruals and Deferrals
    [Expand]Credits and Leases
    [Collapse]Reports
     [Expand]Annual Report for Slovene Authority
     [Expand]Mass Print Reports
     [Expand]General Journal
     [Expand]Account Card - old
     [Expand]Account Card
     [Expand]Outstanding Items
     [Expand]Outstanding Items - old
     [Expand]Debt Structure
      Balance Report of Customers and Suppliers
     [Expand]Invoice Payment List
     [Expand]Pregled zamude pri plačilih
     [Expand]Trial Balance
     [Expand]Financial Reports
     [Expand]Monthly SKV Report for the National Bank
     [Expand]Četrtletno poročilo za AJPES
     [Expand]Summary Reports
     [Expand]Financial Analyses (ZEUS)
     [Collapse]SFR - Statistika Finančnih Računov
       Tiskanje SFR
       SFR Pregled
       SKIS
       Nasprotni sektor
       Finančni Instrument
       Knjižbe
       Izvoz SFR v xml in excel
       Kontrole
       Napake
     [Expand]Cross Reference
      Export General Ledger Data for Tax Purposes
     [Expand]Zavarovanje terjatev
    [Expand]Special Reports
     Consolidated Financials Statements
    [Expand]Fixed Assets
    [Expand]Transactions
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Year-end
    [Expand]Interest
    [Expand]Cash
    [Expand]Archive
     ZEUS Planning
   [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: 359.3467 ms
"
   1000518 | 200555 | 342676 | Published
Label

Izvoz SFR v xml in excel

Izvoz v xml in Excel

010381.gif010411.gif010382.gif010383.gif



Postopka za izvoz poročila v xml datoteko ali excelovo preglednico najdemo na zavihku Izvoz poročila SFR. Do poročila SFR dostopate preko menija Denar - Obračuni - Statistika finančnih računov - SFR.





1. Prenos SFR v Excel

Program omogoča prenos poročila v excelovo tabelo. Pred izvozom podatkov v excel moramo iz Ajpesove spletne strani (http://www.ajpes.si/Statistike/Statistika_financnih_racunov/Program) kopirati predpisano preglednico na lokalni računalnik.

V polju Pot do XLS datoteke na zavihku Izvoz poročila SFR zapišemo pot, kjer se datoteka nahaja in kliknemo Izvozi, kot je označeno na spodnji sliki.


 

Program sporoči, da je izvoz podatkov zaključen in to informacijo potrdimo.

V Excelu dobimo izpolnjeno SFR poročilo za svojo nadaljno uporabo:




2. Prenos podatkov v xml datoteko

 

000001.gif Če spreminjate ime datoteke, pazite, da bo imela končnico xml in da bo pot do direktorija za shranjevanje pravilna.

Ajpes na svoji spletni strani poleg excelove preglednice omogoča tudi uvoz xml datoteke. Datoteko v Pantheonu kreiramo tako, da na zavihku Izvoz določimo pot, kamor želimo shraniti datoteko in kliknemo gimb Izvozi:



 

XML datoteka je kreirana, ko se pojavi informacija (Kreiranje datoteke končano), ki jo potrdimo. Tako kreirana datoteka je pripravljena za uvoz na spletni strani Ajpes.

 

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