Sarah,
We use Deferred IDC Processing.

You're correct that a .lis file is generated, but that file contains only
summary information, unless the process is run 'one grant account at a
time', in which case it DOES show the IDC details.  This approach can indeed
show me the ifo  I need, but with a large number grant accounts this
approach is prohibitive in terms of time.  And of course sifting the desired
information out of .lis text files is a time-consuming task in itself.

The .lis data is also written to a Banner table called FRRGRNC.
Unfortunately, this table is wiped clean of its data after each run of the
deferred IDC process.

Obviously taking the info from a Banner table is the approach most people
would HOPE for, but this appears unworkable.  And, while gathering IDC data
from .lis logs is certainly possible, it is incredibly time-consuming.

Does anyone see a third option?  Or even a way to make theses first two
options workable?

Has anyone solved this situation in another way entirely?

--
Thanks for your time,

Rich Magyar
Systems Administrator
Eastern Michigan University
Graduate Studies & Research
734-487-3090

On 04/01/2004 9:28 AM, "Sarah Ber" <xxxxxx@isugw.indstate.edu> wrote:

> Rich,
>
> Do you use the Deferred IDC process or does the idc calculate as each
> transaction is posted?  I don't use the deferred IDC process, but there
> should be a .lis file from resulting from the  process which may detail
> how the process summaries were arrived at.
>
> Sarah
>
> Sarah Ber
> Director Grants & Contracts
> Office of the Controller
> Indiana State University
> 812-237-3553
> xxxxxx@indstate.edu
>
>>>> xxxxxx@EMICH.EDU 4/1/2004 8:54:37 AM >>>
> Hi everyone,
>
> I have a question about the SCT Banner Database and any institution
> out
> there that is using Banner to track Indirect Cost Recovery.
>
> I had HOPED for simple data like "FROM, a "TO", and "AMOUNT".
>
> Unfortunately Banner doesn't store info like this.  It DOES calculate
> all of
> the details, of course, but then it deletes the details once finished.
> Only
> monthly summaries remain.
>
> Want to to verify WHERE money was transferred?... Too bad.   Want to
> verify
> that the money credited into your destination account is correct?...
> Too
> Bad.
>
> Unfortunately, the lack of details in these fund transfer records
> leaves us
> with few options at here at Eastern Michigan University to
> TROUBLESHOOT
> possible mistakes or VERIFY or that IDC amounts are arriving in the
> correct
> places and correct amounts.
>
>
> I'd be very interested to learn if anyone has found a solution to this
> problem, and report details of IDC destination/amount for each grant.
> --
> Does anyone have an Ad Hoc Report that can list the actual IDC dollar
> amounts and account numbers involved when Indirect Cost is recovered
> from
> each individual Grant?
>
>
>
> --
> Thanks for your time,
>
> Rich Magyar
> Systems Administrator
> Eastern Michigan University
> Graduate Studies & Research
> 734-487-3090
>
>
> ======================================================================
> 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")
======================================================================