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
     [Expand]Financial Reports
     [Collapse]Templates for Automatic Posting
      [Expand]Toolbar in Posting Template
       Header of Posting Template
      [Expand]Lines in Posting Template
       Generating Reports and Posting
       Errors in Posting by Using Templates
     [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: 421.8709 ms
"
  297 | 390 | 335901 | Updated
Label

Lines in Posting Template

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

On the form Templates for Automatic Posting you can enter formulas for calculating on the lines of the posting templates and (if necessary) define accounts to which the calculated amount is to be posted.

The section can be accessed via the menu Settings | Financials | Templates for Automatic Posting.

Here is a description of the fields:

Line

Displays the consecutive line number from formula and account settings. It is generated automatically and can be changed if required. The numbers are numbered by tens, thus making any subsequent inserting of lines easier.

Type

Select the method, that is, type of data collection from formulas and posted amounts by selected accounts. 

Select the following methods used in collecting data and posting:

  • S - Summary - Collects and posts summary data on accounts from formulas, that is, distribute them by departments and cost centers from distribution key (if selected).This is the most often used type of data collection. See Preparing to Close Class 4 and 7.
  • P - By Subjects- Collects and posts data according to subjects from posting lines.
  • O - By Departments- Collects and posts data according to departments as set in posting lines. See Closing Classes 4 and 7 by Departments.
  • A - By Subjects and Depts. - Collects and posts data according to subjects and departments. Thus combining types P and O.
  • N - By Depts. and Cost Ctrs.- Collects and posts data according to departments and cost centers from posting lines. See Closing Classes 4 and 7 by Departments and Cost Centers.
  • V - By subjects and linked docs. - Collects and posts data according to subjects and linked documents.
  • Z - By subjects, linked docs., depts and cost ctrs. - Collects and posts data according to subjects and linked documents, departments and cost centers.
  • C - By subjects and cost centers - Collects and posts data according to the subjects and the cost centers.
  • T – By Document Type - Collects and posts data according to the document type.

Name

Here, you can enter any name of the posting line, that is, any description of functions carried out in the line.

Formula

Enter the formula representing:

1. What Sort of Operation You Want to Perform Using the Specified Expression, That Is, Account. 

The following operators are available for use:

  • R - Revaluation - Use this operation whenever you want to revaluate transactions on the account mentioned later by using revaluation rates. It is used in revaluating capital and long-term provisions. For detailed treatment see example in the chapter Capital Revaluation Report.
  • S - Sum - By using this operation you sum up the specified expression or account, that is sum up transactions to this account. For a more detailed treatment see for example  formulas used in posting VAT (Setting up Transfer Accounts).
  • A - Line Amount - By using this operation whenever you attempt to use in line a result or value calculated in previous lines. For a more detailed treatment see for example  formulas used in posting VAT (Setting up Transfer Accounts).
  • O - Interest - By using it you can calculate the interest of transactions on the specified account by using interest rate table. Whenever you use it in a formula, it is MANDATORY for you to select the interest rate table in the header. For a more detailed treatment see the capital revaluation report including the interest rate table (Calculation Using Interest Rate Table).

2. With Which Accounts or Groups of Accounts the Setting Is Used. 

Here such expressions are used in the financial reports, hence you can directly reference accounts in the general ledger:

  • D – debit transactions in a given period
  • K – credit transactions in a given period
  • S – absolute value of account balance in a given period = |D - K|
  • P - Credit – Debit (credit balance in a given period) = K - D
  • O – Debit – Credit (debit balance in a given period) = D - K

Enter expressions offset by # (hash) sign. You can reference individual account codes or classes, groups, any level of analytics, etc… Use the wildcard characters

Below You Can Observe Examples of Correctly Defined Expressions:

  • #SD28%# - balance of debit transactions on accounts of group 28
  • #SO4%# - sum of debit balance on accounts of class 4
  • #RP90%# - revaluation of credit balance on accounts of group 90
  • #A10# - #A20# - amount from line 10 in posting template, less the amount from line 20 in the same template
Namig

Because expression in the formula can be quite lengthy, you can view the complete formula at the bottom section.

 Test formula

By clicking this button you test the entered formula (It tests regularity of formula, that is, whether it includes all the characteristics required for successful calculation).

POSTING DATA  

It is not mandatory to enter them. If you leave these fields empty, calculation according to the entered formula is displayed. Of course, you cannot perform posting. You can prepare formulas by defining posting to the debit side in one line, and posting to the credit side in another.

Account DR/
Use Formula

Select the account on the debit side of which you post the calculated amount. Use this option whenever the total obtained amount is posted to the debit side of one single account. Selecting the account in this field rules out the option Use Formula.

Check the Use Formula checkbox whenever you want the amount posted to the debit side of all those accounts specified in formula. Multiple accounts are used in posting to the debit side. If checked, it rules out the option of selecting individual accounts.

If you attempt to determine account as well as use formula from the current line, it returns an error (see Error in account settings (DEBIT)!).

Account CR/
Use Formula

Select the account on the credit side of which you post the calculated amount. Use this option whenever the total obtained amount is posted to the credit side of one single account. Selecting the account in this field rules out the option Use Formula.

Check the Use Formula checkbox whenever you want the amount posted to the credit side of all those accounts specified in formula. Multiple accounts are used in posting to the credit side. If checked, it rules out the option of selecting individual accounts.

If you attempt to determine account as well as use formula from the current line, it returns an error (see Error in account settings (CREDIT)!).

Distribution Key

If you want to perform posting by distributing lines by departments using the distribution key, select the corresponding one from Distribution Keys register by using which you can calculate portions of individual departments.

Rounding

Select number of decimal places for rounding.

Frequency

Frequency of deferrals/accruals. Month, for example, means one amount per month…

Accrual/Deferral Due

We define maturity of deferrals/accruals. A value of 1 means one amount on the frequency (month).

Accrual/Deferral Count

Enter the total number of deferrals/accruals (installments).

Delay of 1st Accr./Def.

We define the delay of the first deferral (installment). For example, 3 means the delay of 3 months from the date of posting journal. A value of -1 means the delay of the first installment in the following calendar year.

Addit. Accruals/ Deferral

Checked box means that the position gets suffix of value, which represents the serial number of deferrals. Deferral numbers are recorded in the Linked Document field.

 


 

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