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