v9 faaccts table

andyi · Post by **andyi** » Wed Jun 01, 2005 4:28 pm

In v8.5, we generate our own custom reports using Excel by reading in table faaccts directly with MS Access. I can see in v9 that this table has been modified significantly over the 8.5 version. Gone are a number of fields, including the "ACTUAL" field showing the monthly change in an account's value. In v9 I can see a faprevyr table showing previous year values but I can't find any table showing this year's values. Are these values available in any v9 table? Will I have to process the transaction records myself to get the monthly totals?

Andy Ihlenfeldt
Database Coordinator
North Como Presbyterian

Post by **Zaphod** » Wed Jun 01, 2005 5:42 pm

Will I have to process the transaction records myself to get the monthly totals?

Actually, that's the way it works now in v9. All the reports calculate those things each time you run them. The previous method of having those numbers stored in FAACCTS was part of why you could only have one year's accounting data available to you at any given time.

andyi · Post by **andyi** » Thu Jun 02, 2005 12:06 am

Ok. Given this, I can try to duplicate the database processing that v9 does or I can use a built-in report or create my own PowerChurch "custom report" to output this information. It doesn't look like an built-in report can do what I want, but I'm not even sure a custom report can do it.

I want a single report to show me the balance of each fund and account for each month of the current year. Ultimately, I'll need to parse this report with my own software to convert it to the format I need.

Can you suggest any ways I can get this information?

Post by **Jeff** » Thu Jun 02, 2005 10:07 am

Have you looked at the export accounting data option on the Fund Accounting menu? This option creates a spreadsheet with a beginning balance for each account and the monthly changes for each account. This is similar to what used to be in the Faaccts table but is already broken into separate columns. There is no actual column its amounts will be listed in the correct month. It can be exported in a variety of formats including comma separated values, excel 2 & 5, and XML.

andyi · Post by **andyi** » Thu Jun 02, 2005 3:05 pm

Sweet.