We implemented all Banner modules, including the Grants piece of Finance. This includes the proposal, award set-up, billing, accounts receivable. Though our Tech Dept. programmed some reports for us, we are now able to use MS Access to query the Banner tables and create our own reports. We still are trying to work out some kinks with our billing and AR. Has anyone else fully implemented Banner Grants? If so, I'd like to discuss some of these kinks and how you may or may not have resolved them. Thanks, Fran Solano Simpson University of Denver Dolce, Peter J wrote: >Both Marias- > > > >We have just over $30 million in research funding and have a preaward >data base we created ourselves with Microsoft Access. You can learn >enough about Access in 2-3 days with a manual and training disk to >create a data base like ours. We record information about the outgoing >application and subsequent awards; data on animal care, human subjects, >and subcontracts are in the same data base. The forms-the screens that >display the data-are user-friendly and we can modify them in minutes. >Also in minutes I can run user-friendly reports to show, for example, >the number of funded applications submitted to NIH and the American >Heart Association by the departments of internal medicine and surgery >between 1/1/94 and 6/30 97, except for those that contained subcontracts >or asked for less than $75,000 in the first year. > > > >As for Banner-our school has installed Banner and will deploy the grants >management module this spring. (The understanding of data bases we got >from Access has been invaluable in understanding how Banner works) The >infotech people assure me that they can modify the purchased package to >record the info that our Access data base records, but what about >reporting-can I run reports like the ones above from Banner? We >typically run a report using a query in Access, move it to Excel and >then e-mail it to the recipient. It takes minutes. Can you do >something similar in Banner? > > > >Thanks. > > > >Peter > > > >Peter J. Dolce, Ph.D., Director > >Office of Research Support Services > >Meharry Medical College > >1005 D. B. Todd Boulevard > >Nashville, TN 37208 > > > >Phone 615 327 6703 > >Fax 615 327 6716 > >________________________________ > >From: Research Administration List [mailto:xxxxxx@HRINET.ORG] On >Behalf Of Maria Landis >Sent: Wednesday, February 02, 2005 11:16 AM >To: xxxxxx@HRINET.ORG >Subject: Re: [RESADM-L] Software for Small to Mid-size Institutions > > > >Hi Maria, > >Our Grant Accountant uses SCT Banner Research Accounting module for >post-award mgmt and I, being new to this gig, am just beginning to test >the pre-award forms. So I'm not yet sure of everything the RA module >has to offer but, since SCT Banner is inherent here, I'm willing to give >it a shot. I'll let you know what progresses. > >Maria > > >Montoro, Maria wrote: > > > >Hello all, >Can anyone with annual grant activity under $5 million provide >suggestions >for grants administration software? > >Many thanks, >Maria > >Maria Montoro Edwards >Director, Sponsored Projects >Marywood University >2300 Adams Avenue >Scranton, Pennsylvania 18509 >(570) 961-4775 >www.marywood.edu > > >====================================================================== > Instructions on how to use the RESADM-L Mailing List, including > subscription information and a web-searchable archive, are available > via our web site at http://www.hrinet.org (click on "Listserv Lists") >====================================================================== > > > > > >-- > > > >Maria > >________________________________ > >Maria C. Landis >Information Coordinator >Office of Research Services >The University of Scranton >O'Hara Hall - Room 227 >Scranton, PA 18510 > >Phone: 570.941.6190 >Fax: 570.941.5995 >Web: http://academic.scranton.edu/department/ors/ > >====================================================================== >Instructions on how to use the RESADM-L Mailing List, including >subscription information and a web-searchable archive, are available via >our web site at http://www.hrinet.org (click on "Listserv Lists") >====================================================================== > > >====================================================================== > Instructions on how to use the RESADM-L Mailing List, including > subscription information and a web-searchable archive, are available > via our web site at http://www.hrinet.org (click on "Listserv Lists") >====================================================================== > -------------------------------------- Frances Solano Simpson Director, Office of Sponsored Programs University of Denver 2199 S. University Blvd. Denver, CO 80208 phone: (303) 871-4036 fax: (303) 871-2623 ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ======================================================================