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: 468.7445 ms
"
   1004894 | 217364 | 352304 | Published
Label

Import invoices as entry in accounting service wit

Import invoices as entry in accounting service with postings

 

See users manual Import invoices only as entry in accounting service without postings for the first part and then continue with instructions bellow.

 

Excel file need the columns in the following sequence on tab 2 (Posts):

 

A Key Key number define to which invoice entries belong.
B Position Position from the invoice.
C Account number Account numbers marked red are missing in chart of account register. Missing account need to be set in chart of accounts before Posting (import) invoices.
D Subject  
E Document number  
F Link document  
G Foreign document  
H Debit  
I Credit  
J Currency  
K Exchange rate  
L Date of document  
M Due date  
N Date of VAT  
O Department  
P Cost center When cost center is missing (marked red) in register, entries will be done without it.

 

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

 

 


 

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