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
     [Collapse]Annual Report for Slovene Authority
       Transfer of Financial Reports from Web Service
       Basic View
       Setup Export to XML File
       Setup Export to Excel File
     [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)
     [Expand]SFR - Statistika Finančnih Računov
     [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: 765.6165 ms
"
   1003540 | 210509 | 344127 | Updated
Label

Nastavitve izvoza v Excel

Setup Export to Excel File

010381.gif010411.gif010382.gif010383.gif
 

Lokacija excel datoteke

Na disku poiščemo AJPES-ovo Excel datoteko, ki jo bomo polnili s podatki.
Samodejno polni podatke ob dodajanju Če je ta možnost označena, lahko na hitro dodajamo nove zapise v spodnjo tabelo z nastavitvami. Ob pomiku s puščico dol, se podatki iz prejšnje vrstice prepišejo, vrednosti v stolpcih Vrstica in Vrstica PL pa se povečata za 1.
Nastavitve za izvoz v Excel Za posamezen AOP lahko nastavimo ime Excelovega lista (List), številko vrstice (Vrstica), številko stolpca (Stolpec), številko vrstice za prenos podatka za prejšnje leto (Vrstica PL) in številko stolpca za prenos podatka za prejšnje leto (Stolpec PL). Na podlagi teh podatkov bodo v Excel datoteko zapisani podatki za določen AOP za tekoče in prejšnje leto.

 


 

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