CONTENTS

01. OVERVIEW

The Calculation by View (CTBA212) aims to calculate the balances of items updated previously, indicating whether DEFICIT or SURPLUS occurred in the period based on managerial view settings.

Initial Considerations

Prerequisites to perform the Calculation process by view:

         1- To have the basic registers of the Managerial Accounting module.

         2- To have the Managerial Views ( DREs ) related to registered calculations; namely, the View of general DRE and the DREs of Funds to be calculated separately.  The accounts of main DRE must necessarily be contained in a Funds DRE.

02. EXAMPLE

Registers

Procedure

• Accounting Entries:
  
  Updates → Transactions  → Auto Acctg Entry:
  
  

• Managerial View - CTBA161
  
  
  

Updates → Entities→ Managerial View: 

General DRE - Example with all accounts used in the funds:

PDO Fund:

PSI Fund:

FCA Fund:

Attention!

The presented managerial views are only examples. It is up to the customer to adapt the view to the scenario.

All views must have a summarized totalizer that states the result of the fiscal period. This information is used for updating balances.

• Configuration of Books - CTBA130:
  
  
  Updates → Configurations → Configuration of Books:

Place the cursor on the desired view and bind it to the managerial view through field Manag. View (CTN_PLAGER):

Add

Step by step

In the menu "Miscellaneous → Closings → Calculation by View":

Header Addition Step (Main - QN8)

1. Click Add.
2. Fill in the following fields: 
   1. DRE Code → Enter the Managerial View code related to the DRE;
   2. Description → Description of view (Automatic when filling in DRE Code);
   3. Accounting Batch → Fill in Batch of entry;
   4. Accounting Sub-batch → Fill in Sub-batch of entry;
   5. Calendar Code → Enter the calendar code;
   6. Calculation Year → Enter the year;
   7. Calculation Period → Enter the month of the year in which the entries will be later analyzed and generated as per view settings;
   8. Balance Type → Type of balance;
   9. Currency → Currency.

Completion of specific Funds on Grid (Specific - QN9):

1. Place cursor on grid;
2. Fill in the following fields:
   1. View Code → enter the code of the fund;
   2. Description → Description of view (Automatic when filling in DRE Code);
   3. Surplus Acct→ Fill in the Surplus account;
   4. Deficit Acct → Fill in the Deficit account;
   5. ANS Calc Acct→ Fill in the Calculation account;
   6. Hist Code → Enter an intelligent history code for completion of accounting entry.

Important

• You can add only one calculation by view per period.

Edit

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Edit;
3. Fill in desired fields: 
4. If you want to edit the grid.
   1. Place the cursor on the grid and edit desired fields.

Important

• You can only edit the view when the status is 'To Process'.

View

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click View;
3. Visualize the view as per the fields desired;
4. If you want to view the grid.
   1. Place the cursor on the grid line

Important

• The option "Update View Balances" only enables the action in Editing upon confirmation.

Delete

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Other Actions -> Delete;
   
   
   

Important

• You cannot delete processed

Copy

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Other Actions -> Copy;
3. Fill in the period for the same data in another month, or edit the other fields if desired.

Important

• When making a copy, all calculation by view data are copied, except 'Calc Period' and 'Status'

Updates Balances

Procedure

1- In the menu "Miscellaneous → Closings → Calculation by View";
2- Place the cursor on desired view;
3- Click Edit;
4- Other Actions → Update View Balances

The option to "Update View Balances" updates the fields 'View Balance' of the header, 'View Balance' on the grid, and fields 'Val Ind' found on the header and grid.

The header's Balance View corresponds to a full view, and the grid views are fractions of this full view.

To calculate the sum of grid view balances, they must correspond to the balance of the full view.

Important

• To update the view balances, you need to run the balance update (CTBA190).
• The balances are updated considering the branch of the register.
• If the main view's balance is 0 (zero), the value indicator is 'C'.

Calculate

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Other Actions -> Calculate;

Rules for generating the calculation:

The header's Val Indic field defines which column to use for the calculation entries.

• Val Indic equal to 'D':
  We use the accounts of column Deficit Acct  
• Val Indic equal to 'D':
  We use the accounts of column Surplus Acct 

Field Val Indic of the Items defines whether the value of column Surplus Acct (C) or Deficit Acct (D) will be a Debit or a Credit.

• Val Indic equal to 'D':
  We use the account of column Surplus Acct (C) or Deficit Acct (D) to Debit the Calc Account.
• Val Indic equal to 'C':
  We use the column account Surplus Acct (C) or Deficit Acct (D) to Credit the Calc Account.

See the example below:

After calculating the status, it is updated to "processed".

• Accounting entries generated after calculation:
  
  

• Understanding entries after calculation: 

 Account 256119012001 of column Deficit Acct is used in Debit entry against account 691119011001 of column Calc Acct
Account 256119012002 of column Deficit Acct is used in Debit entry against account 691119011002 of column Calc Acct
Account 56119012003 of column Deficit Acct is used in Credit entry against account 691119011003 of column Calc Acct.

Important

• Internal control fields Date (QN9_DATA0 and Doc (QN9_DOC) are updated when calculating.

Reverse Calculation

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Other Actions → Reverse Calculation;
3. Check whether entries were recorded with entries reversed in the accounting entries table.

The calculation reversal generates entries with accounts in reversed entry to set accounts to zero

After reversal, the calculation record is updated to status "Reversed":

Important

• To return to status 'To Process', use option 'Update View Balances' in option Edit and confirm it.

Example:

Delete Calculation

Procedure

In the menu "Miscellaneous → Closings → Calculation by View":

1. Place the cursor on desired view;
2. Click Other Actions → Delete Calculation;
3. Check whether the entries were deleted.
   
   
   

Calculation deletion aims to delete the entries recorded in the accounting entries (CT2) table.

After deletion, the calculation record is updated to status "Reversed":

03. OTHER INFORMATION

• Detailed Specification - Calculation by View

04. TABLES

• QN9 - Calculation Items by View  
• QN8 - Calculation by View  
• CT2 - Accounting Entries

05. Mental Map