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
    [Collapse]Fixed Assets
     [Expand]Settings and Fixed Asset Registers
     [Expand]Register - Fixed Assets in Acquisition
     [Expand]Fixed Assets
     [Expand]Small Tools
     [Expand]Depreciation Calculation
     [Expand]Fixed Assets Inventory Count
     [Expand]Error Messages Occurring in Fixed Assets
     [Expand]Import of Fixed Assets from Excel file
      Fixed Asset Card
    [Expand]Credits and Leases
    [Expand]Преглед на осчетоводявания
     Консолидирани финансови отчети
    [Expand]Reports
    [Expand]Special 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: 421,8993 ms
"
   1002434 | 209301 | 404995 | Review
Label

Import of Fixed Assets from Excel file

Import of Fixed Assets from Excel File

010381.gif010411.gif010382.gif010383.gif

 

 

 

Function "Import from Excel File"  can be found on Import/Export button of Fixed Assets form. It enables import of Fixed assets with all detail necessary for further work, postings and evidences.

 

File Path

Path to excel file for import fixed assets data.

Open

Use Open button to transfer data from excel file in Pantheon grid.
Transfer Use  Transfer button to enter data in fixed assets register.
Register Overview USe Register Overview button to review prepared data and their match with register in Pantheon.
Fill In Missing Registers on Transfer Some of missing data in registers can be completed with this option marked. These registers are (subjects, chart of account, cost centers.

 

Datoteka v Excelu mora v naslednjem zaporedju vsebovati naslednje kolone (modra polja pomenijo podatke v glavi OS/DI, rdeča na pozicijah stanja in zelena podatke na gibanju OS/DI, rumena poljubna polja):

  • Inventory No.
  • Quantity
  • Name
  • Name 2
  • Acquisition Date
  • Activation Date
  • Disposal Date
  • Deactivation
  • Deprec. Category
  • Accelerated Depr. (T/F)
  • Deprec. Factor
  • Cost
  • Salvage Value
  • Supplier
  • Supplier's Invoice
  • Year of Manuf.
  • Calculation ID
  • Factory No.
  • Department (FA header
  • Cost Cenetr (FA header)
  • Person Resp.
  • Caretaker
  • Component Of
  • Group
  • Functional Status
  • Date (in position of Value panel )
  • Cost (purchase value in position of Value panel)
  • Accumulated depreciation (in position of Value panel)
  • Status
  • Location
  • Company
  • Dept.
  • Cost Center
  • Issued On
  • Expected Return Date
  • Return Date
  • Quantity
  • User
  • Acquisition Account DR
  • In Acquisition Account CR
  • Deprec. Account DR
  • Deprec. Account CR
  • Upward Reval. Acct. DR
  • Upward Reval. Acct. CR
  • Upward Reval. Acct Diff.
  • Downw. Reval. Acct. DR
  • Downw. Reval. Acct. CR
  • Downw. Reval. Acct. Diff.
  • Text Field 1
  • Text Field 2
  • Text Field 3
  • Text Field 4
  • Text Field 5
  • Text Field 6
  • Text Field 7
  • Text Field 8
  • Text Field 9
  • Text Field 10
  • Num. Field 1
  • Num. Field 2
  • Num. Field 3
  • Num. Field 4
  • Num. Field 5
  • Num. Field 6
  • Num. Field 7
  • Num. Field 8
  • Num. Field 9
  • Num. Field 10
  • Date Field 1
  • Date Field 2
  • Date Field 3
  • Date Field 4
  • Tax Deprec. Date
  • Deprec. Cost
  • Accumulated Tax Deprec.
  • Tax Deprec. Status
  • ​Date of assignment
  • ​Date of end of assignment
  • ​Assigned Quantity
  • Document

 

We can use template and example on sample file.


 

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