How to troubleshoot F9 issues

Entry Type: Informational

Product: F9

Application: F9

Version Reported: NA

Subject:

How to troubleshoot F9 issues

Possible Resolution:

F9 for Sage MAS 90 and 200:

• In the F9 Setup menu, there are no Sage MAS 90 companies listed to select
  F9 needs to know where Sage MAS 90 is located. On the System line in F9 Setup, browse to the ..\Mas90\SOA\sy0ctl.soa file, or enter the path to Sage MAS 90 (for example, F:\Apps\MAS90\).
  Notes:
• The last backslash is not optional. 
• UNC paths are acceptable.
• Errors in Formula
  If F9 returns errors in a cell, always review the formula, and verify the cell references. For example, if the formula is
  =GL(BSPEC($E13,$C$8,$C$9),H$12,$C$4,$C$6,$C$3) verify that each cell reference is valid.
• General format of a basic F9 formula
  The most basic F9 formula from Sage MAS 90 is =GL(Account Number, Period, Company, Year)
  For example, the following formula returns the account balance for account number 100-00-00 in company ABC for period 5 of fiscal 2003.  If you review the History tab in General Ledger for Sage MAS 90, the two numbers should match.
  =GL('100-00-00','5 or Month 5','ABC','2003')
  Note:
• Each parameter (for example, account number, period, and so on) must be in quotes unless it is a cell reference.
• For connectivity issues with F9 and Sage MAS 90, use this formula to determine whether it reads Sage MAS 90.
• F9 pulls from the wrong year
  If F9 is reading data for the wrong year, verify that the default year of the company is correct in the F9 Setup menu.
• F9.xll
  The default installation path for F9.xll is ..\Program Files\Microsoft Office\Office. Use this file to add F9 to the menu bar in Microsoft Excel, Lotus, or so on.
• In Microsoft Excel, F9 is added from the Tools / Addin menu.
• Each version of Microsoft Excel or Lotus has a specific F9.xll file selected during the installation process.
• This file should not be confused with the F9edit.xll file in the ..\F9 directory. 
• F9 is using YTD information for an account rather than the net change
  F9 should read the net change for income statement accounts. If the YTD information displays, verify that the formula's period code parameter is 'month x' instead of 'YTD', and then verify that the Sage MAS 90 General Ledger Account Maintenance Account type is valid and filled in. 
• What is a BSPEC function?
  BSPEC function allows you to break the account down in to segments, similar to how FRx allows you to separate account segments using the tree and masking. The formula structure is
  =GL (Account Number, Period, Company, Year)
  For example, in =GL(BSPEC($E13,$C$8,$C$9),H$12,$C$4,$C$6,$C$3) the 3-segment account number is enclosed in the BSPEC function.
  Notes:
• It is as though you replaced 100-00-00 with $E13,$C$8,$C$9. The commas separate the account segments.
• With cell referencing, you can run departmental/location reports by changing the value referenced in cell $C$8 or $C$9.
• To see how BSPEC works on a functioning spreadsheet, create a report using the Report Wizard in F9. 
• F9 and Budgets
  F9 can read and incorporate Sage MAS 90 budgets into spreadsheets. Below is an example of a budget formula: =GL('100-00-00','month 5 budget','ABC','2003').

  F9 can also import budgets into Sage MAS 90 using the WGL function or the Budget Write Back option in the F9 Menu. WGL is used to modify existing budget data that have existing gl8 records. Budget Write Back creates GL8 records.