F9 Report Writer

 

 

  • Installs in just minutes
    • Shared Excel add-in
    • One SQL script
  • Easy to learn and use
    • Leverage your knowledge of Excel
    • Use Excel shortcuts to create financial reports in minutes
  • Modular Security Model
    • Allows blocking transaction detail by the combination of user, company, and module
    • Uses Dynamics SL Access Rights control
  • Compartmental Security model
    • Prevents users from seeing any data they shouldn't
      • Use mask an/or lists to allow viewing balances and transactions by combinations of company, ledger, account, and subaccount
      • Maintained using an Excel worksheet (copy/past, search/replace, etc.)
    • Shared woorkbooks will have different information depending on who opens them
    • No need to schedule, generate, or distribute internal financial reports
  • Adds custom functions to Excel
    • PTDBAL(CpnyID,LedgerID,Acct,Sub,FiscYr,Pd)
    • YTDBAL(CpnyID,LedgerID,Acct,Sub,FiscYr,Pd)
    • PDEND(CpnID,FiscYr,Pd)
    • and many more!
  • Balance functions (PTDBAL, YTDBAL) include sophisticated options
    • View only credits or debits
    • Include unposted transactions, even in future period
    • Use Consol account and/or subaccount
  • Insert from SL form for easily importing entities like company ID, ledger ID, and suaccounts
    • Create drop down lists
      • Subaccount drop down list can be by segment(s)
    • Drop lists of entities into your Excel worksheet
      • List of all accounts
    • Can create range (cell) names for entities
    • Insert descriptions--uses XLstatements functions like ACCTDESC(CpnyID,Acct)
  • Summarize by using masks, ranges, and/or lists
    • Companies in the same database
    • Accounts
    • Subaccounts
    • Periods
    • E.g., CpnyID can be "00//", Acct can be "101?;1030:1080;-1055, Sub can be "*"
    • Companies from different databases may be used in the same formula by using multiple functions, e.g., =PTDBAL("0060","10??,"*",2016,10)+PTDBAL("0010","101??","*",2016,6)
  • Double-click on a PTDBAL cell to drill down
    • First level expands from any summary, e.g.,accounts, subaccounts, periods
    • Second level shows transaction detail in the GL for an account/subaccount/period
    • Third level shows the entire batch of transactions in the subsidiary ledger
      • Saves hours when auditing
      • Can be blocked by using Modular Security
      • Includes inter-company transactions
    • Fourth level available to show attachments
    • All levels are filtered by Compartmental Security
  • Drill down options
    • See entity ID and name (e.g., AP Vendor) at GL detail level (when posting in detail)
    • Notes on Batch, entity, document, and detail from Dynamics SL are Excel comments
    • Show transaction type descriptions
    • and more!
  • Add columns to drill down detail sheets
    • User fields
    • Any other columns from any screen level
    • Configurable for all users or specific users
  • Auto-generate reports by subaccount
    • Department reports- as workbooks or worksheets in the same workbook
    • Reports can be static (just numbers) or XLstatements workbooks
    • Can also create PDF files or send to printer