不良研究所

听

Dear Budget Module user,

We鈥檇 like to alert you to a problem we鈥檝e encountered with the July (period 03) Finance data warehouse views. If you create your own Crystal Report templates, have requested templates tailor made to your purposes, use the Finance data warehouse to extract budget data to another reporting tool, or you have downloaded the Crystal Report template 鈥淢onthly Fund Summary by account (perm and temp)鈥� from our website, this e-mail is important for you.

Due to the FY11 changes, many documents processed in July and intended for fiscal period 03, were assigned a fiscal period of 02. Specifically, the system assigned the incorrect fiscal period to the following fields: 鈥渁dopted budget鈥�, 鈥渁djusted budget鈥�, 鈥渢emporary budget鈥� and 鈥渢ransaction amount鈥澨� (for budget amounts only). These fields were posted to fiscal period 02, whereas the 鈥渁ccounted budget鈥� field, a cumulative or summary budget field, was assigned a period of 03, for the same transactions. Anytime you use a formula field with 鈥渁ccounted budget鈥� along with any one of the other fields indicated above, you will get erroneous results from the cumulative views (these that have the word 鈥渂alances鈥� in the title of the view). Additionally, if you use a 鈥渢ransaction鈥� view, period 03 will have incomplete budget data.

The problem described above is isolated to the month of July 2010 and is specific to the breakdown between permanent budget and temporary budget amounts, however, it does not impact the Budget data warehouse views, because there is no concept of fiscal period in the Budget Module. Additionally, most finance-centric reports built by central Finance, that present a single budget column are not affected by this issue as they use the accounted budget column only, as a result, templates on the Financial Services web site are not affected by this issue.

What can you do?

-听听If you have downloaded the 鈥淢onthly Fund Summary by account (perm and temp)鈥� template from our website, please refresh your version with the one currently on our website 听(/financialservices/reporting/ >> Budget Reports for 1A and 1B funds >> Integrated Budget & Finance >> ), it has been modified to correct for the above problem.

-听听If you create your own templates or extracts using the 鈥渂alances鈥� views, you can redirect your reports to use a 鈥渢ransaction鈥� view. In this case, you must also query for fiscal periods up to and including the period you want (i.e. fiscal period <= 03 (July)), instead of querying on just the period you want (i.e. fiscal period = 03 (July).

-听听If you have previously requested templates tailor made to your purposes, please contact the originator of your template(s) so it may be updated to correct for this problem.

听

If you have any questions or concerns do not hesitate to contact me,

听

Roula

听

Roula Mpekios, CGA

Senior Manager, Office of the Budget

不良研究所

James Administration Bldg

845 Sherbrooke St. W Room 633

听