Categorized in: 

Activity ID's and rollforward

OUC is working with the campus controllers to resolve a data problem with projects that have multiple activity ID's.  Activity ID's are not meaningful for most projects, where the activity ID is set simply to the digit 1.  Some projects have been set up with additional activity ID's however, and for these there have been issues setting the beginning balances (period zero) for FY 2017.  This can cause discrepancy between summary m-Fin reports and m-Fin FINANCIAL DETAIL.

These are the projects that I think are affected, given my current understanding of the problem:

1549990    REPROGRAMMING MUSCLE STEM CELL
1554046    NIH COPY: TECHNOLOGIES TO DEFI
2511341    ABBOTT CANOPY CARTOID STDY.CT
2521425    SCHERPLRI P04285.CT
2521919    HLAR-NV20234.CT
2522490    NOVO INS.2.DBTS.CT
2522824    GSK HIV1 DRG-1349572.CT
2523501    NJH CMV PREVENTION FC.CT
2524029    ADA DIACYLGYCEROL INS SKELETAL
2525932    PFIZER SU011248.CT
2526434    GSK GW786034.CT
2527696    DFPCC YOUNG STRONG.CT
2532260    FUJISAWA U 209800 CT
2535456    ABT U BETAFECTIN CT
2560510    SAUS-INSUL COMPAR.CT
2560658    NOV.DETEMIR/GLG.CT
2560699    MANN INSULIN PWDR.CT
2565434    VIVUS AVANFIL IN ED PROS.CT
2570075    FKDG GLUT HT SHK  CT
2570318    LIGAND.U TARGRETN.CT
25A3874    NIH CTSA KL2...
4773006    UHALL RTU/ROOF REPL PH 1
4773012    LOT 224 CITY BUS STOP

While the m-Fin reports are where the discrepancies can be seen, the reports themselves are not being worked on for this problem.  Once the data is fixed the reports will be correct.

How to see the issue

Run m-Fin ACCOUNT NUMBER for your project id, for FY2016 thru period 998, selecting ASSETS and LIABILITIES in the LEVEL03 prompt.  Compare to a run for FY2017 for period zero.  The amounts in the first run's END column should be in the second run's END column, with the same ACTIVITY ID's.

I will add comments to this blog post as I learn more about this issue.

Add new comment