1. Verify the Account has a System Reserved Attribute and Description Defined.
  2. After adding a System Reserved Attribute, Synch Accounts.
  3. Run the Report again.

 

       If the steps above do not resolve the error then go through these in order until the error is resolved : 

 

1) Check whether your account structure shows a separator after the last dimension.
a. Go to General Ledger> Maintenance> ID Types.
b. Select the ID type you are getting the error on in the ID Type dropdown.
c. Click on the Account Structure tab.
d. Look at the last dimension listed and look for a separator, such as a dash or period.

If there is a separator after the last dimension, follow step 2 below.

If there is not a separator, follow step 3 below.

Make sure you have a good Division backup and that everyone is out of Fundware for all 3 steps below.

2) If there is a separator after the last dimension:
a. Open Division 00
b. Go to System Administration> System Utilities
c. Enter the following in the "Execute Program" portion of the screen:

Program Name: CST208
Switches: 20
Parameters: GLS,DF. (pgs,ss if the problem is a project grant id).

d. elect today's date, the appropriate Division, and "Run".

e. Select C to Change
f. Enter the ID type and change field 8, pressing Enter until at the Char column of the last dimension.
g. Do a control/home to remove the separator.
h. Press <enter> until the top of the screen is reached, where a (0 to accept) should be entered.

2a.  Determine if a separator still exists in the sql table, GLIDtype.
If there is a separator in the last dimension, and the error still occurs, the problem may be solved by running the following script on the server.  This is done from the DOS prompt of the drive Fundware is on, with no one in Fundware.

C:\>osql -E (changing to the drive letter Fundware is on) (There is a space between osql and -E.)

1>use AFW## (where ## = the division number)
2>go
1>select accountstructure from glidtype where idtype = 'A'
2>go
If the accountstructure shown has a character after the last dimension, then
1>update glidtype set accountstructure = 'AXXXX-XXXX-XXXX' where idtype = 'A'  (substituting the correct id type and making sure the account structure is in caps and the dimensions match what was shown above)
 2>go
you should get 1 row affected.

1>exit
exit


3)If the problem exists but there is no separator involved, then rebuild the CSI file external ID's, then Synch Accounts.

a. Open Division 00
b. Go to System Administration> System Utilities
c. Enter the following in the "Execute Program" portion of the screen.

Program Name: CST900
Switches: <blank>
Parameters: CST902

d. Select today's date, the appropriate Division, and "Run".
f. Select the ID type with the problem.
g. Answer "Are your entries correct? Y)es.

h. From Division 00, select Division Maintenance > highlight the division > Synch Accounts

4) If there is not a separator in the last dimension, and the error still occurs, the problem may be solved by running the following script on the server.  This is done from the DOS prompt of the drive Fundware is on, with no one in Fundware.

C:\>osql -E (changing to the drive letter Fundware is on) (There is a space between osql and -E.)

1>use afwcore
2>go
1>delete from central
2>update instance set instanceid=1
3>go

(you should get ### rows affected) from the central table.

(you should get 1 row affected) from the instance table.

1>exit

exit