The files that hold Advanced Financial Reporting are:

##cwa  ##cwa.idx     Report Definition Header
##cwb  ##cwb.idx     Report Definition Detail
##cwd  ##cwd.idx     Additional data item definition
##cwi   ##cwi.idx      Additional data item values

The cwd and cwi are often empty if data items are not used in the reports.

The files that hold the General Ledger Standard Reports at these later versions are:

##gla  ##gla.idx    G/L report header definitions
##glc  ##glc.idx    Standard report column file for S Y and Z standard reports.

The files now named gla used to be glr.

If there is a successful upgrade from an earlier version to 7.40, you will no longer have ##glr and ##glr.idx in the data directory. At 7.60, the glr files are still present but will be empty. The master file shows as 1 KB.

What you should see is:

##GL720R    ##GL720R.idx
##GLA           ##GLA.idx
##GLC          ##GLC.idx

(Division 95 still has a 95glr and 95glr.idx but this is due to the way the model division was created. It is not what you should see on the data unless at 7.60.)

1. If you still see ##glr and not ##gla, run cstc731,n,n.  This program looks at the glr records and converts them to gla records.  You can see when you run it if it is converting records.  If it has all zeros in the glr, then it is not doing anything.

2. You can use program override, gls118,20,n to scroll and display the reports.  This looks in the gla files.  If you display a report there will be tildas  ~ next to the dimensions.

3. If you try gls108,20,n and you can scroll and see reports (this override looks at the glr files), then they are still in the glr files and have not converted.  If the scroll is empty, they probably have converted.

4. If there are glr files but nothing is in them, then you can try using GLS117,n,n to reload the standard reports.  Using this override does the following:

  • It loads Standard reports and can be run multiple times if the dimensions on the screen were filled incorrectly.
  • It does not delete user-defined reports.  If they are not there, it is because they didn't convert in the first place.
  • It does not delete the AFR reports which are in a completely different set of files, as noted above.
  • If the user had FASB reports, using this override takes out the attribute setups and they will not run without that information being set up again  (these reports are named SOCF SOA SOFP).
  • It also takes out the attributes on combined reports such as COMB1, COMB2, etc.
The FASB and combined reports that come with the system require attribute set up specific to the client.  Once you reload Standard Reports, they are once again at the base level and must complete the set up again.  Many clients do not use FASB or Combined reports, but it is important to ask before doing this.

If the client is missing Project Grant reports and General Ledger is okay, there are comparable overrides looking in the ##pga files.  (pgs118,20,n is comparable to gls118,20,n).