"Invalid account reference in cell XX" error occurs when printing a report
Problem
The following error may occur when defining a range of accounts in Column A using multiple structure codes, where more than one of these structures have the same number of segments:
Invalid account reference in cell XX
For example, the criteria in Column A is:
300 ~ 370 - 50010 ~ 99999 - CT ~ PA - 15 ~ 15
The following account structures have been set up in the company:
|
Structure Code |
Description |
Segments Used |
|
ACCT |
Balance Sheet Accounts |
Account |
|
CCACT |
Cost Center - Account - Group |
Cost Center, Account, Group |
|
CCLOC |
Cost Center - Account - Location - Group |
Cost Center, Account, Location, Group |
|
CCTYPE |
Cost Center - Account - Type - Group |
Cost Center, Account, Account Type, Group |
Solution
The error message occurs because there is more that one structure code with same number of segments.
Specify the structure code in the criteria to resolve the problem.
Format the criteria as follow:
aaaa[ ], bbb ~ ccc - A[ ]
Note. The square bracket indicates the structure codes.
The report should now generate without any errors.
Example:
Assume CCLOC is the structure code that you want. Set the criteria in Column A as:
300 ~ 370 - 50010 ~ 99999 - CT ~ PA - 15 ~ 15[CCLOC]
See also