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
    [Expand]Reports
    [Collapse]Special Reports
     [Expand]Reports for Financial Institutions
      Načrtovanje denarnega toka
     [Expand]Corporate Tax
     [Collapse]Consolidation
       Header
       Company
       Separate Figures
       Consolidated Figures
       Errors
       XBRL Settings
       Data Import
       Outstanding Items
       General
       XBRL
       ESEF Setting
       Uporaba razporejevalnika opravil pri zbiranju podatkov za konsolidacijo
       Steps to follow in implementation of Consolidated
      [Collapse]Usage of Consolidation Reports for Reporting in Ex
        Installation of new (could be empty) database on t
        Preparation of the chart of accounts in the new da
       [Expand]Data retreival from working to new database and re
        Linking of the working and new database for data c
        Mapping both chart of accounts
        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: 515.6394 ms
"
   1006099 | 218477 | 354594 | Updated
Label

Linking of the working and new database for data c

Linking of the working and new database for data collection

010411.gif010382.gif010383.gif

If databases exist on different servers, than linked server must be created. But if they exist on the same server, this procedure is very easy.

Linking databases is done in new database. In the codebook of subject enter one subject, that is our company. This will be used only for linking databases.

Open Administration panel and under Settings and Company find menu Affiliated Companies in new database.

Linking databases

If new database is on the same server as working database enter the following data:

  • Subject (our company)
  • Server Type (select MS SQL (same server))
  • Database (from dropdown select working database)

Other data in this grid is not mandatory to be entered.

Importing Document Types

Next step is to import document types from working database by clicking button Take Over Doc. Types and selecting document types from which the data will be imported.

 

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