Accounting and Financial Information Enhancements

  • The statement print program has been modified to use the process transactions through date to perform the aging calculations. Current due is not always synchronized with total due on the statement.  The ageing amounts are based on current date, whereas the total due for the activities listed are based on the process transactions through date.  Since statements are run in advance, the aging calculations should also be based on the process through date. 
  • General Ledger Analysis and Results Menu options have been updated to ensure only those transactions that are truly unmatched are being reported.  All analysis reports should be empty if your files are synchronized.  Note that the last Analysis Date To parameter should be specified as the last date for which you posted transactions permanently when performing comparisons with file MEMTRNGL.
  • Corrected program flaw in menu option to submit the “Member Account Status AR Detail Ageing Report” to prevent data decimal errors from occurring as the result of invalid parameter data. 
  • Corrected GL creation process for Financial Development matching gifts.
  • Enhanced the posting process for Financial Development activities to ensure all available accounting methods such as *Table and YYY/MM are working properly including associated deferrals.
  • Modified accounting reports to display account numbers using the Y-Metro G/L or Y-Vision format as appropriate.
  • Accounts Receivable Aging - development of a standardized aging routine that has been enhanced to facilitate all components of the application that have a need to calculate and/or display AR aging information.  Includes new standardized algorithms to determine the aging of any activity.
  • Weekly A/R Reporting allows for *MONTHLY or *WEEKLY aging.
  • Member Statements with Weekly A/R Aging allows for *MONTHLY or *WEEKLY aging.

·         Work with Member Transactions

    • Added transaction creation date to the initial display panel
    • Added an accounts receivable aging grid to the bottom of the initial display
    • Removal of the F2=Cancel Activity function for EFT Membership activities
    • Automatically displays the billing plan window upon pressing <enter> or <F12=Cancel>, if the balance due is greater than the sum of all scheduled plan payments and does not allow the user to exit until it has been corrected.  This ensures that all changes are accounted for and correctly calculated in the aging process.
  • Developed a program to create undesignated member accounts for those member's that did not already have one as a result of flaws in early versions.  The cause of the problem had been corrected, but the data was never corrected.  Undesignated accounts are created automatically for each primary member at the time they are entered into the database and assigned an activity branch equal to the branch associated to the user adding the member.  Since this is a batch update process, it was decided to assign the activity branch using the first branch specified in the Branches table file.
  • Modified programs to correctly update posting flag that was preventing the transactions in MEMTRANS from posting permanently.
  • Modified aging routine when the effective EFT withdrawal date is invalid.  If an EFT withdrawal date is invalid or the specified withdrawal date for the member activity is not the same as the EFT days specified in the EFT control table file the system produces an error warning on the EFT sales report but does not have any affect on the creation of the sales or payment transactions.  The effective date is used for aging calculations.  The aging routine has been modified to use the creation date when the effective withdrawal date is invalid.