FAQ: Account Basics

When the account list spans pages, you can't use the arrows to move accounts within the hierarchy between pages. Instead, you can use the cut and paste function:

Select the account that you want to move.
Right-click and select
Cut
.
Navigate to another page.
Hover over, without clicking, the account that you want in the list before the moved account. Don't click it.
Right-click and select
Paste
. The account moves right after the account that you hovered over.

When a parent account has an account attribute, all the child accounts must have the same account attribute. When you want the child accounts to have different attributes:

From the account list, select the parent account.
From the
Account Attributes
section, select
None
for the attribute that you want to change and save. All child accounts retain the attribute that they had already.
Save.
Select the child account that you want to change.
From the
Account Attributes
section, select a different attribute vale and save. The 1 child account now has a different attribute than the siblings.

This means that:

You haven't set up any general ledger or custom accounts for cube entry.
You already added all accounts set up for cube entry to cube sheets.

From
Modeling
, select
General Ledger Accounts
or
Custom Accounts
.
Highlight the account that you want to add to the cube sheet.
In the
Sheets
section, select
Cube
for
Data Entry Type
and save.

The currency translation isn't working because the account data isn't displaying as currency. To fix:

From the
Modeling
area, click
Custom Accounts
.
From the list, highlight the account.
For
Display As
, select
Currency
.
Save.

Changing the

Balance Type

setting to be the opposite of the root account is the fastest way to change the sign of an account. But, when you have existing data in an account, you typically need to import the data again for the rollups to work properly. To avoid importing the data, you can adjust the values from the sheet view:

Select
Sheets
from the main menu.
Open the sheet that has the account.
Right-click on the account column and select
View by Level
.
Highlight all cells.
Right-click and select
Adjust
.
Select
Apply Adjustment Individually
.
From the
Increase
drop-down menu, select
Decrease
.
In the
Enter value
field, enter
200
.
From the
Value
drop-down menu, select
Percent
.
Click
OK
and save the sheet.