User Support Forum

AH! Thank you. I was expecting the content of the tables to be something different but your explanation clears up another reservation I have had with the database design: why store explicit data when it is readily derived from the authenticated source? We skipped version 9 and were in the process of...

In the process of exporting table data from PC 10 with the latest updates, I have run into what appears to be a problem with a couple of tables. in both faprior and faprevyr, the data has been static since the upgrade from PC 8.5 in April, 2007 - not a single addition or deletion. This condition is ...

There have not been any documents published since version 8.5 to map out the data structure.

In version 8.5, the important tables in Fund Accounting were:
.....

I don't have the 8.5 CD handy - where can I access the version 8.5 file documentation?

OK, I was looking for linkages that don't explicitly exist. Actually, pulling the monthly details out of those long strings is straight forward and the V10 tables are a lot easier to work with but I agree - let PC+ do the work where possible. For some reason, FireFox exports the first line of every ...

One very useful piece was the definition of FAPRIOR. That will help a lot as it appears to have sufficient detail to reconstruct the most problematic gaps: missing detail data for transactions made immediately before closing a year. The result of that appears to transfer nearly all the December tran...

I inherited a system that has run pretty much haphazardly (and unaudited) since 1995 and have run into a need to reconstruct activities for some long running (and in some cases, long inactive) accounts dealing with special use funds. We have managed to dig up enough backup disks to cover the entire ...