Use codes and subcodes in a formula
You can't directly combine grouping codes and subcodes in report formulas at this time in the Report Designer.
For this example, you have a list of accounts with the following account grouping codes and subcodes. You want to create a subschedule that excludes the Inventory Account.
GL Acct | Description | Grouping codes | Amount |
|---|---|---|---|
1000 | Cash on hand | CA | 500.00 |
1020 | Cash in bank | CA:CASH | 13,654.60 |
1030 | Savings | CA:CASH | 30,381.11 |
1200 | Inventory | CA:INV | 111,000.60 |
Total: 155,536.31
You can't use
[(CA)-(CA:INV)]
to exclude inventory from current assets. Instead of subtracting, we'll group the accounts you want to include.
- Identify the accounts you want to group together: Cash accounts, excluding inventory.
- Assign a common subcode to these accounts:
- SelectSetup, thenChart of Accounts.
- For each cash account, add the subcodeCASH:
- Cash on hand:CA:CASH
- Cash in bank:CA:CASH
- Savings:CA:CASH
- In Report Designer, use the subcode to group these accounts with the formula[(CA:CASH)].
Result
: Your report will now show only the accounts with the CA:CASH grouping, effectively excluding inventory without complex formulas.Before
: Total Current Assets (CA): $155,536.31After
: Total Cash Accounts (CA:CASH): $44,535.71tip
Always double-check your totals after making these changes to ensure accuracy.
