PANTHEON™ Help

 Kategori
 PANTHEON Ndihmë - Mirësevini
[Collapse]PANTHEON
 [Collapse]Udhëzues për PANTHEON
  [Expand]Udhëzues për PANTHEON
  [Expand]Udhëzues për PANTHEON Retail
  [Expand]Udhëzues për PANTHEON Vet
  [Expand]Udhëzues për PANTHEON Bujqësi
 [Collapse]Manualet e Përdoruesve për PANTHEON
  [Expand]Manuali i Përdoruesit për PANTHEON
  [Expand]Manuali i Përdoruesit për PANTHEON Retail
  [Expand]Manuali i përdoruesit për PANTHEON Vet
  [Expand]Manuali i Përdoruesit për PANTHEON Bujqësi
[Collapse]PANTHEON Web
 [Collapse]Udhëzues për PANTHEON Web
  [Expand]Udhëzues për PANTHEON Web Light
  [Expand]Udhëzues për Terminalin Web PANTHEON
  [Expand]Udhëzues për PANTHEON Web Legal
  [Expand]Arkiva e produkteve të vjetra
 [Collapse]Manualet e Përdoruesit për PANTHEON Web
  [Expand]Fillimi PANTHEON Web
  [Expand]Manuali i Përdoruesit për PANTHEON Web Light
  [Expand]Manuali i Përdoruesit për Terminalin Web PANTHEON
  [Expand]Manuali i Përdoruesit për PANTHEON Web Legal
  [Expand]Arkiva e produkteve të vjetra
[Collapse]PANTHEON Granulat
 [Collapse]Udhëzues për Granulat PANTHEON
  [Expand]Granul Personeli
  [Expand]Urdhërat e Udhëtimit Granule
  [Expand]Dokumentet dhe Granula e Detyrave
  [Expand]Dashboard Granule
  [Expand]Porositë B2B Granule
  [Expand]Shërbimi në Terren Granul
  [Expand]Inventari i Aseteve të Paluajtshme
  [Expand]Inventari i Magazinës Granule
 [Collapse]Manualet e Përdoruesit për Granulat PANTHEON
  [Expand]Fillimi
  [Expand]Granula e Personelit
  [Expand]Urdhërat e Udhëtimit Granule
  [Expand]Dokumentet dhe Detyrat Granule
  [Expand]Porositë B2B Granule
  [Expand]Dashboard Granule
  [Expand]Shërbimi në Terren Granul
  [Expand]Inventari i Aseteve të Paluajtshme
  [Expand]Inventari i Magazinës Granule
  [Expand]Arkiv
[Expand]Faqja e Përdoruesit

Load Time: 406,2554 ms
"
  6613 | 1 | |
Label


Lines in Posting Template

Lines in Posting Template

005557.gif 005558.gif

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

 

Enter formulas for calculating in lines of posting templates and (if necessary) define accounts to which the calculated amount is to be posted.

 

 

Line Here is 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 - Using it 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 Classet 4 and 7.
  • P - By Subjects- Using it collects and posts data according to subjects from posting lines.
  • O - By Departments- Using it 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. - Using it collects and posts data according to subjects and departments. Thus combining types P and O.
  • N - By Depts. and Cost Ctrs.- Using it 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. - Using it collects and posts data according to subjects and linked documents.
  • Z - By subjects, linked docs., depts and cost ctrs. - Using it collects and posts data according to subjects and linked documents, departments and cost centers.
  • C - By subjects and cost centers - Using it collects and posts data according to subjects and cost centers.
Name Here you can enter any name of 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 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 interest of transactions on the specified account by using interest rate table. Whenever you do use it in a formula, it is MANDATORY for you to select the interest rate table in header. For a more detailed treatment see capital revaluation report including 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 like in financial reports, hence you can directly reference accounts in 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 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

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

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

POSTING DATA  

It is not mandatory to enter them. If you leave these fields empty, displays calculation according to the entered formula. 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 uisng the distribution key, select the corresponding one from Distribution Keys register by using which you can calculate portions of individual departments.
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 the delay of the first installment in following calendar year.
Addit. Accruals/ Deferral Checked box means that the position get 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!