PANTHEON™ Help

 Категории
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]PANTHEON упатства
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Collapse]Financials
    [Expand]Accounting Basics
    [Expand]Manual Posting and the Journal Entry
    [Expand]Accruals and Deferrals
    [Expand]Счетоводен табло
     Преглед
    [Expand]Automatic Posting
    [Expand]Close
    [Expand]Fixed Assets
    [Expand]Credits and Leases
    [Expand]Преглед на осчетоводявания
     Консолидирани финансови отчети
    [Expand]Reports
    [Collapse]Special Reports
     [Expand]Poročila za finančne inštitucije
      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
    [Expand]Транзакции
    [Expand]Debt Collection - old
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Лихва
    [Expand]Cash Transactions
    [Expand]Year-end
    [Expand]Archive
     Планиране на ЗЕУС
     ZEUS Planning
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Помощ
   [Expand]Старите продукти
   [Expand]Messages and Warnings
   [Expand]Additional programs
  [Expand]Ръководство за PANTHEON Търговия
  [Expand]Ръководство за PANTHEON Vet
  [Expand]Ръководство за PANTHEON Фермерство
 [Collapse]PANTHEON потребителски ръководства
  [Expand]Ръководство за потребителя за PANTHEON
  [Expand]Ръководство за потребителя за PANTHEON Retail
  [Expand]Ръководство за потребителя за PANTHEON Vet
  [Expand]Ръководство за потребителя за PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]PANTHEON Web Guides
  [Expand]Ръководство за PANTHEON Web Light
  [Expand]Ръководство за PANTHEON Уеб Терминал
  [Expand]Ръководство за PANTHEON Web Legal
  [Expand]Архив на стари продукти
 [Collapse]PANTHEON Web User Manuals
  [Expand]Започване на PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
   Ръководство за потребителя за PANTHEON Web Terminal
  [Expand]Ръководство за потребителя за PANTHEON Web Legal
  [Expand]Архив на стари продукти
[Collapse]PANTHEON Гранула
 [Collapse]Ръководство за PANTHEON Гранули
  [Expand]Гранула за служители
  [Expand]Пътни заповеди Гранула
  [Expand]Гранула за документи и задачи
  [Expand]Гранула Табло
  [Expand]Гранула за B2B поръчки
  [Expand]Гранула за обслужване на клиент
  [Expand]Инвентаризация на дълготрайни активи
  [Expand]Гранула за складови наличности
 [Collapse]PANTHEON Granules
   Започване
   Using PANTHEON Granules at Tecta, a fictional company
  [Expand]PANTHEON Granules and activation
  [Expand]PANTHEON Granule Work records
  [Expand]PANTHEON Granule Travel orders
  [Expand]PANTHEON Granule Documents and Tasks
  [Expand]PANTHEON Granule B2B orders
  [Expand]PANTHEON Granule Dashboard
  [Expand]Полеви сервизен гранул
   PANTHEON Granules - FAQ
  [Expand]Инвентаризация на дълготрайни активи
  [Expand]Инвентаризация на склада Гранула
   Архив
[Expand]Потребителски сайт

Load Time: 375,0141 ms
"
   1006100 | 218478 | 405690 | Localized
Label

Mapping both chart of accounts

Mapping both chart of accounts

010411.gif010382.gif010383.gif

Mapping allows transfer of transaction values in General Ledger from our chart of accounts to chart of accounts for external reporting. This mapping is set before data collection. If new account numbers are added to chart of accouts in the working database, then the mapping must be altered to include mapping for new accounts.

Mapping is done on panel Replace/Exclude Accounts:

As seen from picture, account number in working database si 1200. We have to transfer all transactions to account 4730. Type Replace is selected and replacemet is checked as active.

The following data must be entered for each mapping:

Column Description
Account (affilliate) account from working database is entered. Special characters can be used (? and _)
Account (ours)  account for external reporting from chart of accounts in the new database is selected
Name displayed name of account
Type We can exclude or replace transaction from working database
Being Established if checked then replacement/exclusion is done
Exchg. rate type You can define exchange rate for each account separately. you can define exchange rate for all account in created document as well (suggested)
No linked subjekt's posts

This is the reverse option for exclude demengers on reports​

Exclude demengers- option on reports: Program exclude posts betwen seperate figures according to the VAT number entered at subject. Meaning: if posts between mother/daughter1/daughter2  or eny other seperate figure exist in DB and that subject is entered in main DB with the same VAT number, posts will be excluded at gathering data.
% of value Option to set percentange for transfer amounts for accounts

Import of mapping from external Microsoft Excel File

If mapping is prepared in Microsoft Excel file, it can be imported into program by clicking button Import Chart of Accounts:

The structure of the Excel file is:

Column Description

Subject

 Affiliated company name

Account in linked database

 Accounts in source database
Account in master database Accounts in target databae
Type of action Z - replace, I - Exclude account
Enabled Setting is enabled (T) or disabled (F)

 

 

Оценете темата
Темата беше ли ви полезна?
Коментар
Вашият коментар ще бъде видим и във форума!