THE “ROLL” OPTION

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 Accounts (defined during account setup in FundWare as an Asset or Liability “account”)—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.
• P&L Accounts (defined during account setup in FundWare 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 Accounts, 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 Accounts 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

Period Specifiers:
You can specify periods in F9 functions either by:
• entering a period specifier directly in the function;
• referencing a label cell or range of label cells that contain the
period specifier.
Period specifiers use a subset of the English language to describe a value in the general ledger. You can specify the length of the period for which you want a value, the type of value you want, and several other parameters, all using standard accounting terms. Each parameter has a default value, so you only need to specify those parameters which deviate from the default. You can enter capitalized or lower case characters. Also, any period specifier keyword can be abbreviated as much as you want, as long as it is still unique among the recognized keywords.
For example, you could not use “b” for “budgeted” because “b” could also mean “balance”. You could, however, use “bu”, “bud”, “budget”, etc. for “budgeted”, since there are no other specifiers that start with these sequences of characters. This is the reason why many of the keywords, such as “months”, are in plural form.  You can use either the plural or the singular, since the singular is just an
abbreviation for the plural.
If a period is not specified F9 defaults to “balance for the current period of this year.”

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 table shows an example of this F9 functionality.

Period Specifier Examples:
Assumption: A system date of July 8 (in the current year). F9 translates “July” to the respective period for the fiscal year.
If your fiscal year begins in January (i.e., January = period 1), July = period 7.  If your fiscal year begins in July (i.e., July through June), July = period 1.
 
Off -  Assume calendar fiscal year for this example (i.e., January = 1, July = 7).
• 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).

8 - Assume calendar fiscal year for this example (i.e., January = 1, July = 7). 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.
• Cell amount and transactions match (i.e., they both use the default period selected in the F9 setup).

2 - Assume calendar fiscal year for this example (i.e., January = 1, July = 7). Note: The period # (i.e., 8) 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 supported by Infor. Questions regarding resources, functionality, or troubleshooting with the F9 solution can be directed to Infor Support.