Client Access Follow us on LinkedIn
Call us at: (519) 837-3111 | 3-512 Woolwich St., Guelph, ON

All the "talk" about CaseWare

Tech Notes - CaseView: Cells

Functions

Did you know that you can "flip" the bank balance on CaseView financial statements?

Flipping the bank account displays the account in the Assets section of the Balance sheet only if it has a debit balance. Conversely, if the bank account has a credit balance, it only displays in the Liabilities section of the Balance Sheet.

  1. Create a numeric cell in the Assets section of the Balance Sheet.
  2. Click the Numeric tab and select Negative becomes zero.
  3. Click the General tab and enter a function linking to the bank balance in the Working Trial Balance (AM database).
  4. Click OK.
  5. Now create a numeric cell in the Liabilities section of the Balance Sheet.
  6. To display the bank balance only if it is a credit:
    1. Click the Numeric tab and select Negative becomes zero.
    2. Under Calculation Properties, check the Flip Sign of Value box.
  7. Click the General tab and enter a function linking to the bank balance in the Working Trial Balance (AM database).

Click OK.

The bank balance will display on the Assets side of the Balance Sheet only if the balance is positive. Alternately, if the bank balance is negative, it will display only on the Liabilities side of the Balance Sheet. The result is a flipping of the bank balance to ensure that it appears on the correct side of the Balance Sheet

Back

Renumbering conflicts

When trying to renumber cells, I get an error saying "Renumbering cell 2 conflicts with existing cell 6". What does this mean? The two cells are empty.

The numbers you have chosen, or targeted with the increment chosen, already exist. You cannot renumber your cells over an existing set of cells. This is true even if you're renumbering "cell 6" in addition to "cell 2" because CaseWare renumbers one cell at a time and checks for conflicts with each one.

  1. Renumber the first set to a group of non-existing numbers such as 1,000,000; 1,000,001; 1,000,002;... .
  2. Now renumber the new cells to the cell numbers you want.
This should avoid any conflicts you might have with cell numbers.

Back

Popup Cells

I have a popup cell with several popup items. How would I set up the cell so that it returns by default back to the first item after a year-end close has been performed?

This can be done as follows:

  1. While in the Design Mode, select the popup cell and then click Format 4 Cell.
  2. Click the Roll Forward tab.
  3. In the Pull Value By drop-down list select "Equation".
  4. In the Roll Forward Expression field enter, in quotations, the exact text of the popup cell item you want to set as the default. This does not have to be the first item in the list.
  5. Select the Popup tab.
  6. Check the box "Manual input text must match a popup list item". This must be selected even though the cell is not an input cell.
When performing the year-end close, ensure that the "Update CaseView Roll Forward Cells" box is checked (in the Working Papers Year End Close dialog).

Back

About

Cells are areas in a CaseView document where data can be input directly or linked directly from data in CaseWare. There are six types of cells you can create:

Numeric - accepts only numeric values
Alphanumeric - accepts numbers and text
Date - returns cell values to a date format
Checkbox - can only be selected or deselected, providing a yes or no response
Radio Button - to perform an either/or situation
Button - can only be selected or deselected, providing a yes or no response

Back

Recalculation error messages

If you're getting the mesage "Error in calcuation," check your calculations for the following:

Quotation marks

Each value entered in an equation must be surrounded by a pair of quotation marks in order for the calculation to work. Count the quote marks to ensure they come in pairs and that they are surrounding values.

Opening and closing parentheses

Each value entered in an equation must be surrounded by a pair of quotation marks in order for the calculation to work. Count the quote marks to ensure they come in pairs and that they are surrounding values.

These are the most common causes, however if you are still having problems, verify that the format for your equation is correct.

Back

Adding a column or row of cells- Sum groups

I would like to add a column of figures without typing in each cell reference number. Is there a way I can do this?

Yes- You need to create a sum group. To do this:

  1. Select the column of cells you want to include in teh sum group by pressing the ALT key and dragging.

  2. On the Format menu, select Cell.

  3. In the Sum Group box, enter the name of the sum group and click OK.

  4. In the total cell, enter the following calculation, CGROUP("my sum group") where "my sum group" represents the sum group assigned to the cells you want to total. Do not assign the total cell to a sum group.

As additional cells are added, assign them to the sum group and the values are automatically added into the total cell.

Back

Cell contents and libraries

The cells in my CaseView library document are not displaying content.

CaseView library documents are special CaseView documents that contain frequently used information. Items within the library cannot be edited, but the contents of any library can be copied and then pasted into any CaseView document in any client file. Most of a library's contents consist of generic text and cells containing formulas so that the information can be reused without having to alter client-specific information.

Thus, library documents are not linked to any particular Working Papers client file. This means that only cells set as "input cells" and that have data input in them will display "content" in the library document. Once a library's cells have been copied into a document the linkage will work and you will see data throughout.

Back

ALT key

Did you know you could use the ALT key to "lasso" a column or group of cells.

To do so, position your cursor over the first cell lin the column, press the ALT key and drag over the cells. A blue frame appears around the seldcted cells indicating they are selected. You must have at least 50% of the cell selected in order for it to be "corralled."

If your description carries over on to 2 lines, with the cells being on the second line, you must select from the top line to insure you get all the desired cells.

Back

Accounting & Auditing

Business Tax Accounting

Business Investigation

Consulting

Login