PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Collapse]Financials
      Denominations
     [Expand]Chart of Accounts
     [Expand]Cost Centers
      Payment Methods
     [Expand]Tax Types
      Foreign Inflows and Outflows
     [Expand]Distribution Keys
     [Expand]Interest Rates
     [Collapse]Financial Reports
      [Collapse]Toolbar in Financial Reports
        Checks panel
       [Collapse]Wizards in Financial Reports
         Copy Lines
         Used / Unused Accounts
         Financial Report Check
         Compare financial reports with webservice
         Copy Financial Report Formulas
         Insert Line
         Delete (inserted) Line
         Check all formulas in financial report
         Copy formulas in columns
         Copy Lines from Active Plan
         Copy line between charts of accounts
         Import Financial Report from Previous Chart of Accounts
       [Expand]Import / Export data in Financial Report
       Header in Financial Reports
       Lines in Financial Reports
       Set Footer in Financial Report
       How to Define Date in Financial Report Header?
       Labels
      [Expand]Financial Report Formulas
      [Expand]Using Financial Reports
     [Expand]Templates for Automatic Posting
     [Expand]Depreciation Categories
     [Expand]Revaluation Rates
     [Expand]Payment Orders
      Cash Receipts / Disbursements
      Post Statuses
      Journal Entry Notes
      XBLR Register
     [Expand]Corporate Income Tax Calculation (DDPO/DDD settings)
      XBRL Templates
      ESEF register
      Prenos šifrantov preko spleta
    [Expand]Customs
    [Expand]Program
    [Expand]Documentation
    [Expand]Change User
   [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
   [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: 390.6529 ms
"
   1000001137 | 220852 | 362950 | Updated
Label

100001Q - Copy formulas in columns

010381.gif 010411.gif 010382.gif 010383.gif

By selecting the Copy formulas in columns ARES procedure from the Wizards menu in the toolbar of financial report, you can copy formulas into columns.

Source balance

Select the source financial report for copying formulas.

Dest. Balance

Select the destination financial report for copying formulas. Program only copies the lines with the same line number.

Source formula

Select the source column for copying formula (1-10).

Destination formula

Select the destination column for copying formula from source.

Copy formulas unchanged

This means that program will copy formulas and just add calculation for column C. The letter A will be replaced by the letter C for the third column.

Copy formulas and add prefix for intial date calculation

Similar to the above function, whereas all formulas get prefix X.

 

HINT

A practical use of prefix X in formulas: the program takes into account only the posts from initial balance on a specific date colored yellow for comparative period, in this case 01.01.2007, as shown in the image below.  On report, anValue3 must be entered for Column C and report must be ''flagged' in procedure to use this date. Some reports for some localizations have already been predefined (currently only for CG localization). Predefined reports for other localizations will be created if needed.

 

 

 

RELATED TOPICS:

  Financial Reports

  Header in Financial Reports

  Toolbar in Financial Reports

  Wizards in Financial Reports

 

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