Receiving Error When Generating Balance Sheet Report

Issue: Receiving an error message when generating a Balance Sheet report that says "All accounts must have a Balance Sheet Group assigned."

Click image to enlarge
Balance Sheet Error Message window; says All accounts must have a Balance Sheet Group assigned.
Image 1: Balance Sheet Report Error Message

Environment: Comsense Enterprise

Explanation: There is a general ledger account that is not in the balance sheet model. All general ledger accounts must be in the balance sheet model to create a Balance Sheet report.

Resolution:

  1. Accessing Balance Sheet Model
  2. Assigning the Account to a Balance Sheet Group

Accessing Balance Sheet Model

*Note: Only user roles with balance sheet model security rights can complete this procedure.

Enterprise > System Options > Balance Sheet Model

Click image to enlarge
Enterprise Navigation menu; shows the location of System Options and Balance Sheet Model.
Image 2: Enterprise Left-Hand Navigation Menu

Assigning the Account to a Balance Sheet Group

The left pane of the Balance Sheet Model window is the Balance Sheet Groups pane and the right pane of the Balance Sheet Model window is the Unassigned Accounts pane. The Balance Sheet Groups pane displays the accounts by the balance sheet group.

In the Unassigned Accounts pane:

  1. Select the unassigned account using the right arrow
Click image to enlarge
Balance Sheet Model window; shows the account in the Unassigned Account pane.
Image 3: Unassigned Account
  1. Drag & Drop the account line item in the appropriate balance sheet group
Click image to enlarge
Balance Sheet Model window; shows the account in a balance sheet group.
Image 4: Assigned Account

To reorder the accounts for the Balance Sheet report:

  1. Drag & Drop the account line item to the new position
Click image to enlarge
Balance Sheet Model window; shows the account in a new location within the same balance sheet group.
Image 5: Moved Account
  1. Click Save & Close

The account is now assigned to a balance sheet group for the Balance Sheet report.

Have more questions? Submit a request

Comments