Sage 100

Looking back at v3.71 to create a simple AR history report. ARN and ARO are definately in the folder, but can not access in crystal, they are skipped tables. What am I missing. Tried a query also and not in the list to choose.

If you try to rebuild them, do they show up there?

Yes they are in that list

I wonder if you can actually rebuild? I know you can't do much with everyone on the system, but just wondering if there is a network lock on the files. Vaguely seems to me the only reason I've ever seen a file missing.

The only time I have ever had troubles like this, the company code I was using did not have the module setup.... Maybe nothing, maybe everything...

Try copying into another company and create report from there.

Figured it out. Someone had messed with the ODBC field/table security. It was on 9, changed to a 5 and I can see the table