GASB 34 AND BUDGET TYPES
In fiscal year 2002, government entities received new reporting requirements under “GASB 34”
(Governmental Accounting Standards Board Statement Number 34). A portion of GASB 34 requires that these entities report both original and final (i.e., revised) budget amounts.
 
To address this reporting need, FundWare 7.20 (and above) divides the original single Budget information into two groups: Budget Type 1 and Budget Type 2. This means that there are now five areas of core:
 
• Actual
• Budget Type 1
• Budget Type 2
• Commitment
• Encumbrance
 
When you select the data type in F9, you now have three budget options (if you have upgraded to version 7.20 or above):
 
• Budget 1—Draws data categorized as Budget Type 1 in FundWare.
• Budget 2—Draws data categorized as Budget Type 2 in FundWare.
• Total Budget—Combines the data categorized as Budget Type 1 and Budget Type 2 in FundWare
 
All versions of FundWare prior to 7.20 continue to have only one Budget option. In F9, your only budget option in lists will be “Budget 1.”

 
THE “ROLL” OPTION
F9’s Roll option (defined during F9 Setup) has caused some confusion to our customers. Therefore, we would like to clarify what this setting does.
 
When the Disable Roll Option check box is selected (i.e., displays a check mark) in the F9 Setup window, you will see the following results:
 
• Balance Sheet Accts (defined during account setup in FW as an Asset or Liability “account”)—F9 returns YTD balance for the specified period (including fiscal open balance) unless the periodspecifier contains the word “Change” or “Transactions”. If the period specifier contains the word “Change” or “Transactions,” F9 only returns a net amount for the activity during the specified period and excludes any fiscal opening balance.
 
• P&L Accts (defined during account setup in FW as an Expense or Revenue “account”)—F9 only returns a net amount for the activity during the period specified and excludes any fiscal opening balance regardless of whether the period specifier contains the words “year to date” or “YTD,” “change,” or “transactions.”
 
• Budget Amounts (i.e., F9 Ledger Types 1, 4, 6, 9, 10)—F9 only returns a net amount for the activity during the period specified and excludes any fiscal opening balance regardless of whether the period specifier contains the words “year to date” or “YTD,” “change,” or “transactions.”
 
When the Disable Roll Option check box not selected (i.e., no check mark displays) in the F9 Setup
window, it results in the following functionality:
 
• If Fundware Roll Option = “0” for the Division—F9 returns amounts the same as if Roll Option were Disabled.
 
• If Fundware Roll Option = “1” for the Division—For Budget Amounts (i.e., F9 Ledger Types 1, 4, 6, 9, 10), Balance Sheet Accts, and P&L Accounts, F9 returns YTD balance for the specified period (including fiscal open balance) unless the period specifier contains the word “Change” or “Transactions”. If the period specifier contains the word “Change” or “Transactions,” F9 only returns a net amount for the activity during the specified period and excludes any fiscal opening balance.
 
• If FundWare Roll Option = “2” for the Division, it results in the following functionality:
— Balance Sheet Accts and P&L Accounts—F9 returns YTD balance for the specified period (including fiscal open balance) unless the period specifier contains the word “Change” or “Transactions”. If the period specifier contains the word “Change” or “Transactions,” F9 only returns a net amount for the activity during the specified period and excludes any fiscal opening balance. 
 
— Budget Amounts (i.e., F9 Ledger Types 1, 4, 6, 9, 10)—F9 only returns a net amount for the activity during the period specified and excludes any fiscal opening balance regardless of whether the period specifier contains the words “year to date” or “YTD,” “change,” or “transactions.”
 
CHECKING THE ROLL OPTION SETTING
Use the following instructions to check the roll setting on your spreadsheets.
 
1. From the F9 toolbar, select Setup. The Setup window displays.
2. Click the Division Profile button in the Setup window. The last item in the Division Profile
displays the Roll Option setting for that FundWare division. Your spreadsheet amounts will adhere
to the rules for that Roll Option number.
 
You can disable the Roll Option by selecting the Roll Option Disabled check box in the F9 Setup window. Your spreadsheets will follow the rules for Disable Roll Option.

THE PERIOD OPTION

You should be aware of how certain Period specifiers (e.g., This Month, This Quarter, 1 Month Ago, and Last Year This Month) use the Period that you specify in F9 Setup to determine what amounts to display in the F9 spreadsheet. If the Period is set to Off in F9 Setup, F9 translates the system date (month) to the respective period for the fiscal year and returns amounts accordingly. The following shows an example of this F9 functionality.

 
Assume calendar fiscal year for this example (i.e., January = 1, July = 7).
Period = Off 
• Cell amount: Amount returned is through period 7.
• Drill down by transaction: Shows transactions through period 7.
• Cell amount and Transactions match (i.e., they both use the period of the system date).
 
Period = 8  Note: The period # (i.e., 8) selected in F9 Setup is greater than the translated system date period # (7).
• Cell amount: Amount returned is through period 8.
• Drill down by transaction: Shows transactions through period 8. p
• Cell amount and transactions match (i.e., they both use the default period selected in the F9 setup).
 
Period = 2  Note: The period # (i.e., 2) selected
in F9 Setup is LESS THAN the translated system date period # (7).
• Cell amount: Amount returned is through period 2.
• Drill down by transaction: Shows transactions through period 2, with the following exception:
— When the period specifier is for a quarter (e.g., This Quarter) and the period selected in the F9 Setup (e.g., 2) is less than the translated system date period (e.g., 7), F9 shows transactions through the entire quarter of the F9 Setup period # (i.e., through March in this example).

This integration is now supported by Infor. Questions regarding resources, functionality, or troubleshooting with the F9 solution can be directed to Infor Support.