Monday, November 29, 2016

 

 

 

 

 

 

 

 

 

 

 

 

 

Treasury Development

 

 

 

 

Is there a particular feature, enhancement or modification you would like to see in Treasury? Email the development staff at: treasury@adpcnet.com ormanderson@adpcnet.com

Please include the particular module name

Please contact our offices for any assistance on the Treasury software. In an emergency or after hours contact Mark on 580-716-2333 for assistance.


Shortcut keys added to Treasury:

  • Ctrl & F - Summary of Financial Activities
  • Ctrl & Q - Quick Save ( Performs a backup without any comments)
  • Ctrl & R - Enter a Receipt
  • Ctrl & A - Record an Adjustment
  • Ctrl & S - Select a school (for users of multiple schools)
  • Ctrl & O - Offsite Backups (to send or receive a database)
  • Ctrl & X - Exit Treasury
  • Ctrl & M - Send ADPC an email
  • F1 (Function key) - Help Menu
  • Ctrl & L - Set limiting date
  • F11 - Search Utility
  • F7 (Function key) - Visit our Web Site
  • F9 - Edit Last Years Bold Coding

TREASURY Updates - Version - 2.0.0.851 Last Update: 11/29/2016

  • Updated modules
    • Main
      • Main the main screen has a few changes as requested by some users, including;
        • User Interface change
        • Display of Treasury version
        • Display of SQL Version what version your database is running on
        • User will be informed of how long it has been since an update was run
        • User will be informed of some pertinent financial information
        • User will be able to identify if they are running with administrative privileges

 

    • General
      • On monthly close the system will create an automatic backup prior to starting the monthly close-our process
      • Security enhanced on SQL transactions with Administrative privileges on load of Treasury with Status bar for multiple school users
      • Login Module update security enhancement on licensing module with ADPC and licensing verification

 

    • Coding
      • Enhanced - option to change coding of receipts of current and prior months
    •  Reports
      • Updates on Quarterly reports for charter schools

 

TREASURY Updates - Version - 2.0.0.839 Last Update: 8/5/2016

  • Updated modules
    • General
      • Updates were made in Reports, OCAS merge files, links, and Coding modules.
      • IT staff and Users can now browse to where Warrant files are located
      • Update to Login Module (users with multiple schools)
      • Updates in adding a New fund (user adds new Account and system will prompt to add New Fund)
      • The old Utility Menu has been replaced with Services as title, in order to avoid confusion with a similar title under the Treasury menu.
    • Coding
      • Users now have the option to change coding of receipts of current and prior months
        • Summary; Option available under Treasury Receipt - Edit receipt coding
        • Shortcut key Ctrl & C
        • Users are able to sort data by Receipt number, project Source or program
        • Simply click existing line, Enter new data under (New) and Save Edit
        • Account will be added if it does not exist
        • Will update OCAS reporting, Accounts, Funds and relevant Revenue tables in the database
    •  Reports
      • The Detailed Revenue Analysis report now includes an additional report - an option to run a Detailed Analysis grouped by Program
      • The Report can be summarized by checking the summarized button

 

 TREASURY Updates - Version - 2.0.0.812 

  • Updated modules
    • General
      • Updates were made in Adjustments, Reports, New OCAS codes, Year End Close out and Editing Last years Coding
      • The Adjustment and Editing of last years code includes help files - accessible by clicking the help button on each module -
      • With this update users should have been prompted to update their OCAS 2015 Codes - with instructions - if a user was not prompted please contact ADPC.

 

    •  Adjustments
      • Use the Help Button for an overview - In summary;
        • Users will not have to enter two adjustments (contra entries) all is done in one transaction
        • Users are able to delete an Adjustment, provided it is within the current month

 

    •  Reports
      • The Detailed Revenue Analysis report now includes an additional report - an option to run a Detailed Analysis grouped by Project - this is important to establish carry over amounts to be adjusted in the new year
      • The above report can be summarized by checking the summarized button

 

    • Year End Close
      • The Year end close-out routine is updated to include the option to save the reports that is automatically generated at year end;
        • Summary of Financial Activities
        • List of Adjustments
        • Detailed Revenue analysis grouped by Source Code
        • Detailed Revenue analysis grouped by Project Code (Summarized)
      • The reports will be available for future reference or access without restoring back to a prior year. They will be stored by default in the users local drive - C:\EDS\Treasury\Data
      • We recommend to run the Periodic Tasks and visit the Yearly routine for step by step instructions prior to closing out - This is available from Treasure by clicking Utilities - Periodic tasks

 

    • Editing Last Years Code
        • Shortcut key - F9
        • Use the Help Button for an overview - In summary;
          • Users will be able to update last years codes and amounts - without restoring to the prior year (although the option to do so still exists)
          • Note: If changing an amount in an account, a contra edit is required in order to ensure the variance (before change and after change remains zero) - if a variance exists is is vital to reflect this change in the new Fiscal year.

 

TREASURY Updates - Version - 2.0.0.810 

  • Updated modules
    •  Accounts
      • Add accounts will automatically add current fiscal year and set focus on next field
      • Fixed error fields and validate length of Codes to avoid user adding invalid codes
      • Highlighted feature - editing codes while entering
    • Adjustments
      • New Button for fund only adjustments (Warning if attempted fund only adjustment in current fiscal year)
      • Validate Length and validity of each code entered prior saving
      • Highlighted feature - editing codes while entering
    • Investments
      • RE-Invest Interest or Increase an Investment W/O a Treasury Check: user will have a drop-down box listing investment numbers rather than having to type it in avoiding possible input errors and ease of use
  • Add New Fund
    • User can now add a New Fund through the Accounts Menu (User will still be able to add new fund when adding a new account)
  • General
    • Update to Main Screen and About.
  • Projected Carryover
    • Tweak update maximum element array (Fund count)  to 12. Previous allowed 5 funds only fixed.
  • Search Utility
    • Tweaked Search Utility  optimized to search for assistance in reconciliation or finding transactions within receipts and /or checks/warrants
  • Voiding Checks
    • Tweaked possible error, prior user could have duplicate void, not allowing user to un-void check fixed.
  • Applying Warrant files
    • System will recognize any duplicate checks or warrants. User will be warned with option to quit or resume processing.
  • Apply Warrant Files
    • UNC Path now available, to set path applying warrant files (Direct to Server)

 

 

Archived Editing of Treasury Software: (Developer Mark A.) pre 2014

 

TREASURY Updates - Version - 2.0.0.809

  • Unposting posted warrants
    • Tweaking of unposting a warrant - warrant will be marked unposted - the associated check will be reduced by the amount of the warrant.
  • New Account - Bold
    • When adding a new account the account will be marked "B" as default, previously it was left blank and the user had to add the 'B' to mark it as part of the bold code process

TREASURY Updates - Version - 2.0.0.808 

  • Old year warrants
    • The database kept warrant records of schools that were converted from the old DOS system for over 10 years. Causing a problem on close out to year 2014. This update will auto delete warrants older than 5 years of the schools current fiscal year.

TREASURY Updates - Version - 2.0.0.73 

  • Bold code Update Error
    • When running a revenue bold report - a school reported not showing the carry over on sinking fund (fund 41) - Investigated and updated the process to avoid similar events.

TREASURY Updates - Version - 2.0.0.71 Last Update: 7/7/2014

  • Applying diskette with warrants or checks
    • When applying a diskette the system allowed users to apply a diskette with warrants in a future year, the system will halt the process with a message if warrant diskette contains a future year warrant or diskette. Apply the diskette after close-out.
  • Treasury update
    • Streamlined update - was instances of treasury still running which resulted in an incomplete update
  • Periodic Tasks
    • Shortcut available to tips and hints on Yearly (and monthly) processing available directly. Click on Utilities - Periodic tasks. If you have hints or tips of your own please e-mail me to add these for the benefit of other users

TREASURY Updates - Version - 2.0.0.68 Last Update: 6/11/2014

Updated periodic tasks for useful year-end tips click: Here to go there directly.

  • Changing Revenue Coding
    • Under treasury - receipts a new option: Edit Receipt Coding appears
      • A listing of receipts entered for the year will appear - listed by receipt number order
      • Click on the row to edit coding
      • Complete the new coding in the text boxes and click save
      • Note:
        • No changes will be effected if codes are the same
        • Will update monthly, yearly receipts, account information and historic revenue tables
        • Shortcut key available Ctrl & C
        • Changes to funds needs to be recorded through adjustments
        • User can still record adjustment from old to new code if paper trail required
  • Bold code Report - correction
      • Bold code report for revenue had duplicate lines if code rolled to a previous code that already exists - generated report will add figures for same duplicate lines, eliminate the additional line and recalculate the totals
  • OCAS Codes for 2009 has been updated.
    • From the System Menu Run Treasury update Twice (to update the updater)- It will download the file automatically and prompt with instructions - From the Treasury Menu Select [Database] - - Select [Append New OCAS/BOLD Codes] - - Enter drive letter "C" and Year "2014" Click Continue

TREASURY Updates - Version - 2.0.0.67 Last Update: 4/27

  • Backup Routine
    • User has option to setup system to create an automatic backup on exit of treasury - Click on Database, Backup Database - Select the checkbox for automatic backup

TREASURY Updates - Version - 2.0.0.66 Last Update: 4/14

  • Reports
    • Treasury Board report will reflect Liabilities as Warrants or Checks Paid depending if check or warrant school.

TREASURY Updates - Version - 2.0.0.65 Last Update: 3/12

  • Reports
    • Revenue Comparison reports generated random binary errors - corrected.
    • Investment Reports by Fund shows Fiscal year and Fund. The Fund name has been added for readability.

TREASURY Updates - Version - 2.0.0.62 Last Update: 1/08

  • Old Backup's
    • The Software will identify backups that are: Older than 200 days or more than 99 backups found or when the Operating Systems hard drive space is low
      • On this occurrence a screen will pop up after a backup allowing the user to select backups to delete.
      • User can exit this screen or delete backups
      • Once a a backup is created it would stipulate the path of the backups - the user can copy these backups to an alternate backup location (CD\Flash drive|server etc.) if required for future reference, prior to deleting the older backup

 

        TREASURY Updates - Version - 2.0.0.61 Last Update: 1/07

  • Receipt's
    • Receipt registers:
      • All reports has a new check box: "Report by date" once checked user has the option to enter a date range from and to for the requested report
      • The date range requested will appear on the top of the report
      • User will now be able to change a receipt description after entry
  • Database Functions
    • Restoring Database - Information/Comments from old backups will automatically be displayed without the user having to click "View Log of Selected backup" and updated on highlighting a different backup
    • Backing Up - When backing up user will be taken directly to log file for comments and ready to back up.
  • Adjustments
    • After user leaves the Year field - an Account Lookup button will appear for user to select from list of accounts which will populate the coding fields (user may still manually enter the codes)
    • If user uses the "Acct Lookup" the details of the account and financial data will appear on the right (for viewing purposes only)
  • Add Diskette (warrant files)
    • Entering warrants or check from diskette: When user prompted after selecting warrant file: "Do you wish to pint a copy of checks/warrants on this diskette" The "proof list" will now include a total of all the checks on the warrant file
    • NOTE: We always recommend user to print a list of their outstandings prior to applying the diskette - to compare it to the list of checks/warrants - Prior to clicking "Continue Processing" on the diskette in order to avoid applying the same checks/warrants which will create a new record or double up the amounts.
    • The system will catch if Voided check but already cleared and advise user
  • OCAS Codes
    • The database previously kept records of all OCAS coding for previous years. User now has the option to delete those old codes not required: Under Database - Edit Ocas /Bold code descriptions - The new button : "Clean up old year codes" will delete all old codes in the system, except for the current and previous fiscal year.
    • Option to edit last years codes (after close-out) corrected and operational
  • History
    • If user looks up the history of a check or warrant and no record found in the database a message will prompt the user no records found (no message or notice was posted before)
  • Posted Checks/Warrants
    • User can now sort by amount
  • Warrant Schools
    • Voiding a warrant - Previously the warrant was simply marked as unposted. The system will now still allow the user to void a warrant however the associated check will be reduced by the amount of the warrant

 

TREASURY Updates - Version - 2.0.0.60 Last Update: 8/10/2013

  • Close-out Process (Correction)
        • Corrected New funds created for new year. Reported duplications one funds brought to new year.
    • Checks /Expenses (Enhanced)
        • Previously required coding when entering a check from screen (not from diskette or file). Will not require coding on this purpose of check.
    • OCAS Coding (Maintenance)
        • Under Database - Edit OCAS Bold Codes description. New button available: "Clean up Old Year Codes." This will delete all OCAS coding that remained in the database prior to current and preceding years.
        • Updates on Error checking for Program,Subject and Function codes when merging expenditure disks.

 

TREASURY Updates - Version - 2.0.0.56 Last Update: 7/11

  • Backup Process
        • Enhanced performance of backups
        • Option on log file - New checkbox to create a copy of the final End of Year backup, the name will be unique. Therefore will not be deleted as part of the usual treasury maintenance (backups older than a 180 days) It is strongly recommended though to burn a copy of this final backup to CD or disk.
    • Search Utility
        • Enhanced and corrected table names in Database

TREASURY Updates - Version - 2.0.0.49 Last Update: 1/10

  • Backup Process
        • Enhanced performance of backups

TREASURY Updates - Version - 2.0.0.47 Last Update: August2012

  • Reports - Treasurer's to date Revenue Comparison - Accts as Entered
        • Corrected report - Previously did not sum each fund total correctly, it accumulated the figures after each individual fund total - Fixed
    • Monthly Closeout
        • Direct Deposit carry over - any marked direct deposit still outstanding in current month will be carried over to next month.

TREASURY Updates - Version - 2.0.0.46  

  • Clearing Checks
        • Clearing checks was only allowed a maximum length of 5 digits - updated to a allow a length of 6 digits

TREASURY Updates - Version - 2.0.0.45  

  • Funds - Name Change
        • Treasury - Utilities - Fund Information - User has option to rename Fund

TREASURY Updates - Version - 2.0.0.44  

  • Update to Reports
        • Accounts - Print Previous year's Monthly reports - threw an error if Selected 'Y' to total by Source - corrected
    • Bold Code Reports
        • Allow user to save the revenue.dat and expend .dat file to the local C: Drive
        • The files will be overwritten each time the user re-runs the bold code process

TREASURY Updates - Version - 2.0.0.43 Last Update: 7/17/

  • Update Revenue Reports
        • Corrected Detailed Revue Analaysis Year Sub Totals

TREASURY Updates - Version - 2.0.0.42 Last Update: 7/03/

  • Update to Year-End-Close Out Process
        • Monies was not left in prior years to cover Outstandings with the close-out process - corrected

TREASURY Updates - Version - 2.0.0.41 Last Update: 5/03/

  • Report corrections
        • Detail Revenue Analysis
          • Revenue Analysis Year-To-Date did not summarize correctly by source - corrected
        • Estimate of needs threw an error '9' - Error Corrected

TREASURY Updates - Version - 2.0.0.40 Last Update: 4/23/

  • Year End Close Out
        • When closing out June the year end closeout will auto start.
        • Now, the system will automatically generate the following reports prior to starting the Year End Process, but after closing out June:
          • Detailed Revenue Analysis
          • List of Year to Data Adjustments
          • Summary of Financial Activities - Totals by Year for All Years
        • Note: The reports will be minimized to your system tray (at the bottom of your screen) they can each be clicked on and printed for your records
        • Note: Any additional reports can be printed by minimizing the screen at this stage and going to the reports the user may require. Once completed click on the Windows menu option and click on End of Month Processing this will take the user back to click on "Start EOY Processing"
    • Appropriations
      • Off the Treasury Menu note the new item "Appropriations"
      • User may optionally track appropriations, the screen will allow user to add or edit appropriations on this screen
      • If user issues a check and the amount exceeds the appropriated amount (Provided the appropriated amount is greater than zero) the user will receive a warning that the check is in excess of the appropriated amount.
      • The warning will be given only if the appropriated amount is greater than zero.
      • Note: Even if user is issued with a warning - the system will still allow user to go ahead and issue the check.
      • Appropriations may be tracked and printed for record keeping under Treasury - Utilities - Fund Information
    • Search Utility
      • Finalized tweaking of this option under Utilities.

TREASURY Updates - Version - 2.0.0.36 Last Update: 2/21/

  • Investments
    • Corrected error - Investments could not be increased on existing investment of the same number was found that has already matured. This procedure will now only search for open investments of the same investment number

TREASURY Updates - Version - 2.0.0.35 Last Update: 2/16/

  • New Reports
    • Expenses
      • Under the Treasury Menu - Checks/Expenses - Print Expense Registers - The last option -Print check register of all checks for all years - added
    • Receipts
      • Under receipts - Print receipt registers - Option added to print report totaled by "Source, "Site" or "Project"

TREASURY Updates - Version - 2.0.0.34 Last Update: 2/7/

  • Search Utility
    • Tweaked for performance and highlight of input boxes
  • Voiding Checks
    • When grid is populated - it will now display a total of all voided checks
    • Formatted for currency and alignment fixed
    • User will receive a message of successful voided operation (previously no message)
    • Grid will be reset and refreshed after operation (previously grid reflected list of voided checks
  • Deleting Funds
    • Users were able to delete funds, even though there was pending transactions and funds in the particular fund, this has been corrected
  • Backups - Restore
    • The list will now be sorted - Previously it was sorted in the same order as it would appear on the users hard drive or server
  • Investments
    • Reinvesting interest or Increase Investment without a check - User will now be warned if wanting to increase or reinvest funds if the investment has been matured. Previously the system just added the check, however it did not reflect in investments as the investment was matured.

TREASURY Updates - Version - 2.0.0.33 Last Update: 1/25/2007

  • Search Utility
    • From the Main Menu - Utilities - Search Transactions or just press F11 on keyboard
      • This utility will find any check/s or receipt/s within the database
      • Filter results for a specific amount or range
        • If for a certain amount input the same amount in the between fields - top and bottom
      • Filter results for a specific receipt or check number or range
        • If for a specific number input the same number in the between fields - top and bottom
      • Filter results for a specific date or range
        • If for a specific date select the same date in the between fields - top and bottom
      • Filter results by description or part of description
        • e.g.: If looking for a receipt with a description " TA Watson" user can input only "wats"
    • Results will be displayed in a grid format
    • Results can be sorted by amount,date,number or description
    • Please Note:
      • There may be some tweaking to be done - please e-mail us if you run into any errors using this utility
      • The report is for information purposes only - not for editing,deleting or changing data

 

  • Search Utility - Option to Print Added
    • From the Main Menu - Utilities - Search Transactions or just press F11 on keyboard
    • After searching for transactions - the Print Button will be enabled
    • The Printout will add the total and at the bottom of the report, it will show user the details of the query

 

  • Set limited date for reports
    • From the Main Menu - Utilities -Set Limiting date for reports or press ctrl+L on the keyboard
      • By default all financial reports is limited to the last day of the current working month (based on the last month closed out)
      • This allows user to select a future or past date to limit the reports to within this date range
      • Example: Last day of the current month is December - So if user runs financial's all transactions will be included in the report up to and including December 31st. However assume a check was out there dated in January - this check will not be included. If user uses this option and changes the limited date to January 31st for example - this check will be included in the report.
      • User can change to default date anytime
      • NOTE: Once the Treasury application is launched it will always set it to the default date and not to the date the user may have changed in a previous session.

 

TREASURY Updates - Version - 2.0.0.29 Last Update: 11/14/

  • Applying Diskette/s - warrfle.txt

Previously user specified drive (A:) now user can read from hard drive or specify drive A:

  • Treasury - Checks/Expenses Enter Checks from Diskette] or Ctrl & D shortcut 
    [Treasury Process Warrants Enter warrants from Diskette] if warrant school
    Apply Diskette as follows:

 

Note: For first time users to apply file from a hard drive i.e. other than youre a: drive, first create a folder where you are to place your Warrfle files. We recommend placing it in your Treasury folder, which by default would be C:\Treasury or C:\EDS\Treasury and call this folder WarrantFiles or a name that you can identify with.

 

Click Continue and Yes to Browse for file 
i. By default the path would point to your local drive C:\

ii. If you had applied a file from your hard drive before, the treasury system will remember the previous path you applied the diskette from.

iii. Either change the path where the Warrfle file/s are located or if the path is correct, highlight the Warrfle to apply (by clicking on the desired file in the list box at the bottom) Note: Only one file may be applied at a time

iv. Click Select

b. The system will start reading the file and give the user an option to print a copy of the checks on the diskette. (Recommended)

Click Continue Processing 
The system will run another procedure to validate that if this file may have already been applied. (It queries the database for an existing check number for in the same year, fund and amount) User can opt to stop the process if a similar record exist or choose to continue and process record anyway.

 

TREASURY Updates - Version - 2.0.0.28 Last Update: 10/10/

  • Receipt Register - Users are able to obtain report by Month or by specific selected date, receipt number, Account number, Program, Project or Fund and summarized by each option.
  • Expense Registers - an Option has been added whereby user can request a register by a specified date. The report will summarize checks by year and fund, ordered by check number and subtotaled by each fund and a grand total for all.
  • Outstanding Warrants and Checks - Users can now obtain a outstanding report for a selected date or date range. Also this report allows user to generate the report for a particular fund or all funds.
  • Revenue reports - Detail revenue analysis, the year-to-date report has been fixed and will now total the estimated amount for each account correctly

TREASURY Updates - Version - 2.0.0.26 Last Update: 09/29/

  • OCAS Codes for 2007 has been updated. Treasury Users of:
    Version 2.0.01 and up: From the System Menu Run Treasury update Twice - It will download the file automatically or From the Treasury Menu Select [Database] - - Select [Append New OCAS/BOLD Codes] - - Enter drive letter "C" and Year "2007" Click Continue
  • Version 1.0.99 and below : Download the OCAS - 2007 File from the Download Page (Under Utilities) and Save the file to A: drive, select Drive A: as per above instructions or alternatively save to the treasury directory (usually C:\Treasury ) to select "C" drive
  • A quick Save option is available under utilities or by holding the "Ctrl key and pressing Q" (this will save the file without any comments)
  • Applying warrants from diskette, has an additional "audit" function to ensure disks are not applied twice
  • Users with multiple schools can now select a school by clicking the school as before or just entering the school number
  • We have switched to a new FTP site which should speed up the uploading/downloading of databases or when updating the Treasury system (Backups sent offsite will still be available)
  • Investment reports can now be sorted by Investment/CD number for open or all investments
  • Receipt Registers for the current month can now be summarized by selecting Fund as the sort option, Checking the Summarized check box, then select fund or any other sorting option for the summary report.
  • Adjustment descriptions can now be changed
  • Shortcut keys added to Treasury:
    • Ctrl & F - Summary of Financial Activities
    • Ctrl & Q - Quick Save ( Performs a backup without any comments)
    • Ctrl & R - Enter a Receipt
    • Ctrl & A - Record an Adjustment
    • Ctrl & S - Select a school (for users of multiple schools)
    • Ctrl & O - Offsite Backups (to send or receive a database)
    • Ctrl & X - Exit Treasury
    • Ctrl & M - Send ADPC an email
    • F1 (Function key) - Help Menu
    • F7 (Function key) - Visit our Web Site

TREASURY Updates - Version - 2.0.0.19 Last Update: 11/21/

  • OCAS Codes for 2006 has been updated. Treasury Users of:
    Version 2.0.01 and up: From the System Menu Run Treasury update Twice - It will download the file automatically
  • From the Treasury Menu Select [Database] - - Select [Append New OCAS/BOLD Codes] - - Enter drive letter "C" and Year "2006" Click Continue
    o Version 1.0.99 and below : Download the OCAS - 2006 File from the Download Page (Under Utilities)
  • Save the file to A: drive, select Drive A: as per above instructions or alternatively save to the treasury directory (usually C:\Treasury ) to select "C" drive

TREASURY Updates - Version - 2.0.0.18 Last Update: 11/10/

  • Enhancement - Check clearing - use " Enter" key after entering date to move to Continue Button (acts with Tab or Enter Key)
  • Enhancement - Tweaked Clearing checks for performance
  • Enhancement - Update to Treasury Web-Site
  • Enhancement - Added "Utility" option in menu to E-mail or visit web-site from Treasury App.
  • Enhancement - Added from Treasury Menu - Receipt Registers - Current Month - All - Summarized Option - Gives totals of all funds in one report

TREASURY Updates - Version - 2.0.0.15 Last Update: 9/29/

  • Enhancement - Entering Warrants or Checks from diskette - after processing a new button will appear offering the option to add another diskette
  • Enhancement - Clearing Checks - Tab order will move from amount then statement date - not directly to the Continue button
  • Enhancement - Receipts - User has option to add a receipt description based on account name by a click of new button
  • Enhancement - Will receive warning if wanting to add a check that has already been cleared
  • Enhancement - Tweaking done on EOY processing
  • Enhancement - Entering Warrants or Checks from diskette - File: "Warrfle.txt" can now be accessed from Local Disk C: i.e. if file saved to hard drive, a copy will be placed on the hard drive and dated accordingly
  • Enhancement - Backup Procedure will identify the MSDE Version and format the last 2 digits of the backup number - e.g.: BU-mm-dd-(starts with 01 if MSDE 7 and 51 if MSDE 2000) followed by the 3 digit school number
  • Enhancement - Users with multiple schools only has to press ctrl & S at the main screen to change schools
  • Fix - Unclearing checks and warrants tweaked for correct processing

TREASURY Updates - Version - 2.0.0.10 Last Update: 5/31/

  • FTP control Tweaked for performance
  • Restore and Backup Routine performance enhancement - now on steroids
  • Enhancement - Treasury Loading - Opacity plus FTP access
  • FTP Control part of installation Procedure
  • Fix - Endless looping of clearing checks/warrants when adding range fixed
  • Enhancement - Version number available of main menu
  • WEBSITE updated:
    • New FTP Control available in Updates and New Installation

TREASURY Updates - Version - 2.0.0.0 Last Update: 3/14/

  • Enhancement - Transfer Screen has an account lookup option
  • Fix - Editing an Investment
  • Enhancement - Treasury Loading - Opacity plus FTP access
  • FTP - Latest Treasury will automatically be updated - provided you have internet access
  • FTP - Option to send / receive offsite backups for use by ADPC to correct data
  • Tweaking of backup and restore routine
  • Enhancement - Entering receipt functionality & print of receipt option
  • Enhancement - Posting a warrant will reflect school name on print
  • Enhancement - Option to enter checks from screen
  • Enhancement - User will be posted on Main Treasury screen when last update was done
  • WEBSITE updated:
    • New FTP Control available in Updates
    • Controls required for FTP available with download

TREASURY Updates - Version - 1.0.94 Last Update: 1/14/

  • Fix - Entering a receipt with an account that does not exist - Code error -" invalid procedure call or argument" - fixed

ENHANCEMENTS:

  • Entering a receipt simplified in terms of its "flow", user will be given option to add receipts and receive a message on a successful save of receipt.
  • Backup & Restore Procedure
  • End Of Month Close out - Update taskbar to reflect updated last month closed out.
  • Access to ADPC or Treasury web-site from help menu
  • Exit Button available Added to Summary of Financial Activities reports

TREASURY Updates - Version - 1.0.93 Last Update: 1/10/

  • FIX - Investment Reports - Open Investment Ledger and List of All Investments

TREASURY Updates - Version - 1.0.90 Last Update: 12/16/

  • FIX - Applying warrants /checks from disk fixed
  • WEBSITE updated:
    • New Search Utility available in Updates
    • New Registration of DLL's Utility available in Updates
    • XceedZip Version 4.5.77.0 Available for download

TREASURY Updates - Version - 1.0.88 Last Update: 12/09/

  • New - Receipt Register has new option to Print Receipt Registers Summarized by Source for selected fund or for all funds.
  • FIX - Some later versions - Recording expenditures - entering a check as an investment threw error '438' when recorded as investment
  • FIX - Reinvest Investment Screen enhanced for ease of use

TREASURY Updates - Version - 1.0.85 Last Update: 12/05/

  • WEBSITE updated:
    • Developments Updates
    • Treasury Home Page - Download latest Help File
    • Updates - Download latest Treasury Version
    • Updates - Download Component required with windows 98 OS
    • Updates - OCAS Codes 2004/2005 available
    • Updates - New "Treasury" Updates and MX Programs
  • Investment Reports - Open Investment Ledger and List of All Investments will not reflect zero Investments i.e. Null balances
  • Latest Help File For Treasury available - On Treasury Home Page

TREASURY Updates - Version - 1.0.84 Last Update: 11/30/

RESTORE DATABASE:

Automated Backup & Restore routine (Automatic backup prior to completing the Restoration, no overide code required)

TREASURY Updates - Version - 1.0.83Last Update: 11/24/

UTILITIES

Selecting a school:

Selecting a School ( for multi - school ) users will note the log in screen will reflect both the school number and if school is a check or warrant school
Added the option to automate the change from a warrant to a check school, users will require an overide code before process will initiate.


TREASURY Updates - New Version - 1.0.82

Note: Program changes effected in TREASURY 
Last Update: 11/19/

RESTORE DATABASE:

Restore Process will not require an over ride code from ADPC.
Process will effect an automatic backup prior to completing the Restoration

TREASURY Updates - New Version - 1.0.81

Note: Program changes effected in TREASURY 
Last Update: 11/11/

General Changes effected from version 78 to current

Modules Effected with new "Date Time Picker" Control

Notes: on Date Picker Control:
1. Validates - As Date Immediately
2. Option To Scroll Through Months or Year
3. Will Reflect Current Date as Default
4. Move between month / day/ year fields with arrows
5. Will Auto-Correct the Day and Month field if error ( e.g. Month 14 or day 33)

Forms Effected:

Adjustment Entry
Create a Bold Code Disk
Edit/Delete Investment Data
Purchase an Investment W/O a treasury check
Reinvest or increase as inv W/O treasury check
Clear Checks
Checks & Bank Charges
Post Warrants
Enter/void Receipt
Revenue Summary Report
Reports with Option Dates (e.g.: Receipts)
Check & Bank Charges
New View Data Screens
Transfers
Add Warrant from, screen

Corrections in following modules:

Backup & Restore - Fixed form Version 78-80 Now Process so users would be able to backup & restore from any current or previous versions of Treasury
Progress bars added in Backup & Restore process as indication of progress
Advise user of Update, in: Edit of Expenditures
Progress bar will track monthly close-out visible to users
Warn Users when Voiding Checks
Warn Users when Deleting or Voiding Warrants

Enhancements in following modules

Backup & Restore
Adjustments
Create a Bold Code Disk
Bold code combine Disks
Edit acct Number
Edit Last Years Revenue Bold Code Data
Edit/Delete Investment Data
Purchase an Investment W/O a treasury check
Reinvest or increase as investment W/O treasury check
Clear Checks
Edit Expense Code Classification code
Enter Edit Acct Estimates
Closeout Monthly
Closeout Yearly
Fund Report
Checks & Bank Charges
Delete Current Month Misc. Exp
Edit OCAS Code
Add/Edit Ocas Description
Post Warrants
Enter/void Receipt
Register - checks/expenses
Detail Revenue Analysis
Revenue Summary Report
Reporting Modules 
Check & Bank Charges
Imports Checks Warrants From Disk
Void /Delete Expenses
Transfers
Add Warrant from, screen
Add Warrant from disk
Delete Void Warrants
Bold Code processing 
Edit Last Years Rev Bold Code Data
Revenue bold code report & diskette
Expenditure bold code report & diskette
Merge Bold Code disks

TREASURY Updates - Version - 1.0.78
Note: Program changes effected in TREASURY 
Last Update: 10/27/2004

eh - enhancements
co - corrections

SUMMARY of Effected Changes [TREASURY PROGRAM]

IMPORTANT NOTE ON RESTORE PROCESS:
-Restoring will fail if restoring from a backup created on the previous version of Treasury.[Corrected in version 81]
-It is therefore recommended to do an immediate backup - after updating to the latest Treasury version

General

1. eh: Avoid accidental exiting out of system from any "open" module
- User Will be prompted as confirmation

2. eh: Modules acts independently - Can me Minimized, Maximized or Closed

3. eh: Menu - New, in Title bar "Windows" - will track all "open" modules, and reactivate same when selected from main menu

4. eh.: Key's - Added functionality of {enter} key - functions same as {TAB} key in all modules

5. eh: Added New Treasury Help file in build - 1127kb

6. eh: Status bar New - On all open modules will Show - Fiscal Year, Last Month Closed Out, Active Module & date/time

7. eh: Mouse Cursor - changed to "Hourglass" cursor added to various reports to indicate system in process of collecting data

8. eh: Can now access any on-line school through the "Utilities" menu, without leaving/Exiting the Treasury System

(Shortcut to Select School - [Ctrl -S] from Main Menu - provided more than one school placed on-line)


Accounts

General Enhancements: On Adding, Editing and Deleting Account a new Button with a blue Magnifying Glass Appears:
Clicking This Button will Open an " Accounts Register " reflecting Current Accounts In The Schools Database
User Has option to Sort Accounts by any Field or OCAS Dimension
Note: This is for viewing purposes only - Use "List Accounts" or "Display/Print Detail of Accounts" for Printed records

1. eh: - Accounts - Add Account
New appearance and functionality 
default site set to "050"

2. eh: - Accounts - Edit Account
New appearance and functionality

3.co: -Accounts - Edit Acct.
No confirmation to user of successful editing, user will now be prompted: confirmation of success or not
New: User prompted of success & Grid refreshed for view, only Exit on user's instruction

4. eh: - Accounts - Delete Account
New appearance and functionality

5. co: - Accounts - Previously could delete an account with a negative balance - corrected

6. eh: -Accounts - Grids called - OCAS Code selection (New Grid) & OCAS Descriptions

7. eh: -Accounts Code - Validate fiscal year entered before tapping in DBase (performance issue)

8. co: -Accounts - Enter current Year Account Estimates
Calling for SQL Server Login - Corrected
Grid data source called in both properties and code - now coded only 
No confirmation to user of Edit completed & module closes after save

9. eh: -Accounts > - Last Years Monthly Revenue
New appearance and functionality in: Accounts 
Update Accounts without Leaving Module
New Button / Function for "New Account"
Option to Lookup Accounts with new grid added
Textbox reflecting full OCAS coding on editing
Allow Editing of one dimension without resetting the form

10. co: Accounts > Last Years Monthly Revenue
no confirmation to user of successful Update of Revenue Amounts, user will now be prompted of success.

11. eh: Accounts > Display/Print Detail of Account
Report Detail Of Account - New appearance and functionality
- Added Option to View "New Account" after Printing report requested by user
Option to Lookup Accounts with new grid added

Receipts

General Enhancements: On Enter and Void Receipts a new Button with a blue Magnifying Glass Appears:
Clicking This Button will Open a " Receipt Register " reflecting Current Receipts In The Schools Database
User Has option to Sort the Receipt register By Any Field or OCAS Dimension
User Has option to Search the Receipt register by Date
Option To Get Year-to-date receipt transactions 
o Note: User Needs to pre-select the "Order of Grid" prior to clicking the "Get YTD Transactions" if a sort order is required
Note: This is for viewing purposes only - Use "Print Receipt" or "Print Receipt Registers" for Printed records

1.eh: - Receipts-Enter View Receipts:
New appearance and functionality 
Option to Lookup Accounts with new grid added
Validation of Description and Amount Added

2.eh: - Receipts- Print Receipt Registers:
New appearance and functionality 
Option To sort by Fund, Project Or Program added

3.co: - Receipts- Print Receipt Registers:
Error: "Datafield rptprogram.tr_num" -> Corrected call to Dbase - DataSource

4.eh: - Receipts- Print Receipts
New appearance and functionality

Checks

1.eh: - Checks/Expenses > Records Expenditures > Enter Check
New appearance and functionality 
Will not reset form if duplicate check entered, only Message user on this event
Payee - Description field edit 
Validation Check - if check already exists will be performed upon leaving the Check number field and at end of routine
Check Number Field limited Characters (was unlimited)
New Information button to inform user of selected Purpose of check - will pop-up an information box

2.co: - Checks/Expenses > Records Expenditures > Enter Check 
Will advise user of Successfully entered check
Set Max Bank Rate Field to avoid overflow error in event that user exceeds 5 digits
Throw error (message box) if user exceeds 99.9% in bank rate

3.eh: - Checks/Expenses > Records Expenditures > Enter Bank charges W/O Treasury check
New appearance and functionality

4.eh: - Checks/Expenses > Void/Delete Checks
New appearance and functionality 
Added Option To Select Fund From Grid
User will be notified if Selection return a null value / empty grid

5.co: - Checks/Expenses > Void/Delete Checks
Validate maximum amount of Characters in Begin and end Check numbers - avoid overflow error


6.eh: - Checks/Expenses > Delete current month Expenditures W/O Treasury check
New appearance and functionality and updated grid view

7.eh: - Checks/Expenses > Print Expense Registers
New appearance and functionality

8.eh: - Checks/Expenses > Return Check To Outstanding Status > Unclear Checks & Unvoid Checks
New appearance and functionality 
Added Option To Select Fund From Grid

9.co: - Checks/Expenses > Return Check To Outstanding Status > Unclear Checks & Unvoid Checks
Error message on continue button : Operation not allowed when object closed corrected - Corrected connection
Corrected this error in both Unclear and Unvoid checks through Validation of fields

10.eh: - Checks/Expenses > Print Check Status Reports 
New appearance and functionality 
New Option to Select Another report without exiting the module

11.eh: - Checks/Expenses > Display Check Status
New appearance and functionality
Added Option To Select Fund From Grid

Warrants

1.eh: - Process Warrants > Enter Warrants from diskette
New appearance and functionality

2.eh: - Process Warrants > Enter Warrants from Screen
New appearance and functionality 
Added Option To Select Fund From Grid

3.eh: - Process Warrants > Delete Warrants
New appearance and functionality 
Added Option To Select Fund From Grid

4.eh: - Process Warrants > Void Warrants
New appearance and functionality 
Added Option To Select Fund From Grid

5.eh: - Process Warrants > Post Warrants
New appearance and functionality 
Added Option To Select Fund From Grid

6.eh: - Process Warrants > Return Warrants To Outstanding Status > Unpost Warrants 
New appearance and functionality 
Added Option To Select Fund From Grid

7.co: - Process Warrants > Return Warrants To Outstanding Status > Un-Void Warrants 
Added appearance and functionality of Form
Updated Titles & labels of form
Option To Select Fund From Grid

8.eh: - Process Warrants > Print Warrant Lists 
New appearance and functionality 
New Option to Select Another report without exiting the Print Warrant module

9.eh: - Process Warrants > Print/Display Warrant History
New appearance and functionality
Added Option To Select Fund From Grid

Transfers

1.eh: - Transfers > Record Transfer 
New appearance and functionality
New Option to Cancel transfer activity
New Option to Print or View Transfer Activity

2.eh: - Transfers > List Transfer Activity
New appearance

Adjustments

General Enhancements: On Record Adjustments a new Button with a blue Magnifying Glass Appears:
Clicking This Button will Open an " Adjustment Register " reflecting Current Adjustments in the schools Database
User Has option to Sort the Adjustment register By Any Field or OCAS Dimension
User Has option to Search the Adjustment register by Date
Option To Get Year-to-date receipt Adjustment Transactions
o Note: User Needs to pre-select the "Order of Grid" prior to clicking the "Get YTD Transactions" if a sort order is required
Note: This is for viewing purposes only - Use "List Adjustments" for Printed records

1.eh: - Adjustments > Record Adjustments
New appearance and functionality 
New Option to Cancel Adjustment activity
New Option to Print or View Adjustment Activity

2.eh: - Adjustments > List Adjustment
New appearance

Investments

General Enhancements: On Reinvest Interest, Increase, Purchase, Mature/ Un Mature, Edit/Delete Investments a new Button with a blue Magnifying Glass Appears:
Clicking This Button will Open a "Investment Register " reflecting Current Investments in the schools Database
User Has option to Sort the Investment register By Any Field in the Grid
User Has option to Search the Investment register by Date
Note: This is for viewing purposes only - Use "Print " Options under Investments for Printed records

1.eh: - Investments > RE-Invest Interest or Increase an Investment W/O a Check
New appearance and functionality

2.eh: - Investments > Purchase a new Investment W/O a Check
New appearance and functionality

3.co: - Investments > Purchase a new Investment W/O a Check
Throw error (message box) if user exceeds 99.9% in bank rate
Set Max Bank Rate Field to avoid overflow error in event that user exceeds 5 digits

4.eh: - Investments > Mature Investments 
New appearance and functionality

5.eh: - Investments > Un-Mature Investments 
New appearance and functionality

6.eh: - Investments > Edit/Delete
New appearance and functionality

7.co: - Investments > Edit/Delete 
Throw error (message box) if user exceeds 99.9% in bank rate in edit
Set Max Bank Rate Field to avoid overflow error in event that user exceeds 5 digits
User will now receive confirmation of any editing to Investment made

8.eh: - Investments > Print/Display Open Investment Ledger 
New appearance

9.eh: - Investments > Print/Display List Of All Investments
New appearance

Reports


1.eh: - Reports > Revenue Reports > Detail Revenue Analysis & Other Revenue Reports
New appearance and functionality

2.eh: - Reports > Financial Reports > Summary, Board Report
New appearance and functionality

Utilities

1.eh: - Utilities > Fund Information 
New appearance and functionality

2.eh: - Utilities > School System Information 
New appearance and functionality

3.eh: - Utilities > Add/Edit/Delete User 
New appearance and functionality

4.New: - Utilities > Select School 
o Access any on-line school , without leaving/Exiting the Treasury System 
o (Shortcut to Select School - [Ctrl -S] from Main Menu - provided more than one school placed on-line)


Backup and Restore Process

IMPORTANT NOTE ON RESTORE PROCESS:
Restoring will fail if restoring from a backup created on the previous version of Treasury.
It is therefore recommended to do an immediate backup after updating to the latest version


1.eh: - Data Base > Backup Database and Restore Database
New appearance and functionality
Will automatically add Comments for the Backup (Date & School Number) user can add or modify

2.co. - Data Base > Backup Database and Restore Database
Error regarding detach & attaching Engine Corrected - Will now Use & Loop With SQL-DMO and in event it fails:
o Use T-SQL - as alternate route if data base fails to detach during Backup/Restore
o Identify if Local Machine runs on MSDE Version 7 or 8
Comments on previous backup now visible during restoration process
Engine will not stop during the Backup or Restore process, thus will not effect clients tapped into data base at same time

View Data - New Option on Menu -Treasury

1.New: - Treasury > View Data
Allows user to view data of:
o Accounts
o Adjustments
o Receipts
o Investments
Data can be Sorted (Order of The Grid) by: "Select Order Of Grid"
Data can be Searched By Date: "Search By Date" frame
Option To "Get Year-To-Date Transactions"
o Note: User Needs to pre-select the "Order of Grid" prior to clicking the "Get YTD Transactions" if a sort order is required
By Default the Grid Will be loaded with Current Month Data
Amount of records will be reflected
Progress bar will indicate progress on retrieval of data

-------------------------------------------------------------------------------

 

 

 

 

 

 

2014 ADPC. All rights reserved. E-mail any questions or comments to adpc@adpcnet.com Email questions or comments about this website to: manderson@adpcnet.com