FUNDWARE FILES THAT CAN HAVE 0 (ZERO)  RECORDS   
 
Many Fundware files can have 0 records, especially when all features of the software are not being used. Some systems may also have old files that are no longer in use but are still installed with Fundware.  A specific division may not have all files below, if an application has never been used.
 
The files will show in FileMaint.exe when attempting to reorg with an Error 4, and Comments of “No records in input file”. Files with legitimate 0 records can be ignored.
 
Other times a file may be zero due to corruption and can be recreated with an override.
 
Note: some files are version dependent. If the file listed is zero, but the feature is in use, the situation needs to be investigated. If there is any doubt whether the file can be zero, Contact Blackbaud FundWare Support.
 
FILE           DESCRIPTION -                    SITUATION
 
##AMA      Allocation Definitions            Allocations not in use
##ARA      AR Allocations                       AR allocated bill run not in use
##ARD      Additional Calcs                   AR additional calcs not in use
##ARP      AR Stock item pricing           Pricing not in use
##ARJ       Header Open Item AR          Open Item not in use
##ARK     Detail Open Item AR              Open Item not in use
##ARL     GL Accts Open Item               Open Item not in use
Note: The ARJ, ARK, and ARL work together. They will either all be zero or all must have records.
##ARM    Meter Master File                     Meter billing not in use
##ARN     Meter charges                        Meter billing not in use
##BCJ      Control summary                  Budget Control not in use
##BU*     Budget Forecasting               Budget Forecasting not in use
##CAI      Cost Allocation Definitions   Cost allocation not in use
##CIBI     Old columnar reports            Present but not in use
##CICI     Old columnar reports            Present but not in use
##CIDOT Old data item file                    Present but not in use
##CRX      CR import definitions           CR imports not in use
##CSM     Data Item Transactions        No data items used on GL entries
##CSU     Inactive accounts from purge No inactive accounts selected to purge.
##CSX      Transaction export records  Feature may not be in use.
##CSY      Created by posting #S          No created by posting accounts
##CSZ      Temporary posting file          Not usually present
##CW*     Advance Financial Reporter  AFR not in use
##CWI      Additional data item values  No additional data items used in AFR
##FX*       Fixed Assets files                   No Fixed Assets
##GLP       Memorized batches             Saved, imported, or memorized batches not in use
##IC*        Inventory Control                    No longer valid files
##OCR     AP Check reconciliation       No reconciliation in process
##OTBA   AP One-time vendor detail   One-time vendor not in use
##OTBZ    History info by revision         Not used, will always be empty
##OTE       Encumbrance history          No longer used
##OTF       Custom PO form definition  No custom forms used
##OTL       Location Definitions-            Purchase orders not used
##OTX      Currency Exchange rates     No longer in use
##OTM      User-defined vendor data items  User-defined vendor data items not in use
##OTP      AP distribution tables           No distribution tables in use
##OTQ       Recurring obligation alternate reference   No references in saved obligations  
##PGP    Batch posting file  for Project Grant   No records after 7.30
##SYU     Division user definitions        No longer used. (this is not the 00syu which will have size)
##SYC   City Abbreviations used by AP and Classic AR
##TN*    1099 Processing files                                                No 1099s in progress