Calculation Dialog
Working Papers allows you to create an adjustment where the balance is the result of a calculation rather than an entered value. A calculated journal entry takes values from existing categories (i.e, accounts, mappings, groupings, etc.) to determine the journal entry balance. Any changes made to elements of the calculation will automatically update the calculated adjusting journal entry.
Click on a field in the screen shot below to view its description
Category
Lists the available categories for use in calculated fields.
Engagement Properties
Displays engagement properties values that have been set in Engagement | Properties.
Contact 1
|
Title: |
CLP15 |
||
|
First Name: |
CLP20 |
|
|
| Middle Name: | CLP416 | ||
|
Last Name: |
CLP21 |
|
|
|
Designation: |
CLP25 |
Position: |
CLP29 |
|
Bus Phone #: |
CLP18 |
Bus Fax #: |
CLP19 |
|
Mobile Phone #: |
CLP271 |
|
|
|
Home Phone #: |
CLP272 |
|
|
|
Email Address: |
CLP14 |
|
|
Contact 2
|
Title: |
CLP15 |
||
|
First Name: |
CLP20 |
|
|
| Middle Name: | CLP416 | ||
|
Last Name: |
CLP21 |
|
|
|
Designation: |
CLP25 |
Position: |
CLP29 |
|
Bus Phone #: |
CLP18 |
Bus Fax #: |
CLP19 |
|
Mobile Phone #: |
CLP271 |
|
|
|
Home Phone #: |
CLP272 |
|
|
|
Email Address: |
CLP14 |
|
|
Name/Address
|
Client: |
Client No. |
CLP257 |
Client Name |
CLP256 |
|
Engagement: |
Engagement Type |
CLP258 |
Engagement Description |
CLP259 |
|
Operating Name: |
CLP2 |
|
|
|
|
Address: |
CLP3 |
|
|
|
|
Address 2 (blank) |
CLP4 |
|
|
|
|
City: |
CLP5 |
|
Prov/State: |
CLP6 |
|
Postal/Zip Code: |
CLP7 |
|
Country: |
CLP149 |
|
Phone #: |
CLP106 |
|
Fax #: |
CLP107 |
|
Home Page: |
CLP16 |
|
|
|
|
S.I.C.: |
CLP23 |
|
A.I.C.: |
CLP24 |
|
Tax Jurisdiction: |
CLP28 |
|
Tax Entity: |
CLP97 |
|
Engagement Type: |
CLP125 |
|
Client #: |
CLP145 |
|
E.I.N./B.N.: |
CLP253 |
|
Tax Vendor: |
CLP96 |
Period Balances
|
CLP198=blank |
Allow entry of period balances in Working Trial Balance (Other Entries will be disabled) |
|
CLP198=X |
Allow transaction entry in Other Entries screen (period balances will be calculated) |
|
Period Date Sequence for Other Entries Screen: |
CLP199 |
|
Current Active Period for Other Entries Screen: |
CLP200 |
|
CLP230 |
Display and enter period balances as year-to-date balances |
Reporting Dates
|
Year End Date: |
CLP13 |
Year Begin Date: |
CLP62 |
|
CLP151 |
13 Periods |
|
|
|
CLP152 |
Monthly |
|
|
|
CLP153 |
Bi-Monthly |
Compute bi-monthly balances from: |
CLP163 |
|
CLP154 |
Quarterly |
Compute quarterly balances from: |
CLP164 |
|
CLP155 |
Thirdly |
Compute thirdly balances from: |
CLP165 |
|
CLP156 |
Semi-Annual |
Compute semi-annual balances from: |
CLP166 |
|
CLP157 |
Yearly |
Compute yearly balances from: |
CLP167 |
|
CLP158 |
Random |
|
|
|
Current Period Date Sequence: |
CLP17 |
Current Active Period: |
CLP22 |
Document Information
Displays document information values such as description, role completion information and sign off dates. The calculation syntax based on the item selected are the following:
| Item | Syntax |
|
Document Description |
Isdesc("Document#","0") |
| Extended Description | Isdesc("Document#","2") |
| Sign off User | field("SH", "User#", "Document#") |
| Sign off Date | sdate(field("SH","AD1","Document#")) |
User Defined
Displays user defined values(ud1 to ud15) that are set in CaseView from Tools | User Defined Data. The calculation syntax based on the item selected are the following:
Class Type
Displays class type values such as assets, liabilities, revenues, equity, and expenses. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| Class Type Value | Class("BalanceType","Identifier") |
Accounts
Displays account values that are entered in the Working Trial Balance. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| Account Description | desc("Account#",0) |
| Extended Description | desc("Account#", 2) |
| Account Value | act("BalanceType","Account#") |
Mapping
Displays mapping values that are entered in the Engagement | Mapping interface. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| Map Description | mapdesc("map#", "0") |
| Extended Description | mapdesc("map#","2") |
| Map Value | map("BalanceType","Account#") |
L/S and Groups
Displays group/ LS values that are entered in the Engagement | Grouping interface. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| Description | grpdesc("Group#", "Number","0") |
| Extended Description | grpdesc("Group#", "Number","2") |
| Value | grp("Group#", "BalanceType", "Number") |
Tax Export Codes
Displays tax export code values. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| Description | grpdesc("T", "Number","0") |
| Value | grp("T", "BalanceType", "Number") |
CaseView Data
Displays CaseView data values. The calculation syntax based on the item selected are the following:
| Item | Syntax |
| CaseView Value | cvdata("Group", "Form","Identifier") |
Parent Only Balances
Click 
to include only balances for the specified entity. Sub-entity balances are ignored.
Period Only Balances
Click 
to filter values based on the specified period. Select this option to include only the period movement or activity of the specified period, instead of the default year to date balance. For example, choose to display only the second quarter transactions for sales.
Foreign Exchange
Click 
to apply foreign exchange to the listed values.
Include Sub-Balances
Click 
to include sub-account or sub-map number balances in the top level account/map number balance. For example, when selecting a balance for map number 170, this option will dictate whether or not to include 170.100, 170.200, and 170.300 in the balance.
Other Basis Adjustments
Click 
to include other basis adjustments in the listed values.
Hide Zero Values
Click 
to filter the listed values in the results pane to exclude zero values.
Value Parameter List
Displays the items from the selected category that can be used in a calculated adjusting journal entry. Column headings in bold represent elements that can be linked. .
Hovering over a value in the list will open a tooltip window showing the potential formula and resulting value:
Tips
Right clicking on an element in a column that can be linked will display a context menu that may include the following:
- Link Formula - selecting this option will link the element into the formula.
- Link Data - selecting this option will link the actual data and not a formula.
