OCQ – Getting Started

This section will cover the information listed below. Click any link to go directly to that topic:

• Menu And Toolbar Components

  • Refresh Data
  • Query Wizard
    • Sage 300 CRE Company List
    • Select Table
      • Find Window
    • Select Fields
    • Conditions
      • Group Window
      • Conditions Window
        • Creating A Named Range
        • Modifying Query Parameters
      • Keyboard Shortcuts
    • Additional Options
  • Edit SQL
    • Select Query Table
    • SQL Editor
  • Lookup Wizard
    • Key Values
  • Find Wizard
    • Offset
  • Count Wizard
  • Sum Wizard
  • Function Selector
    • TSCount Function
    • TSCustomCaption Function
    • TSCDataFolder Function
    • TSFind Function
    • TSLookup Function
    • TSSum Function
    • OCWorkbook Function
    • OCRetain Function
    • OCFilter Function
    • OCDrillDown Function
    • Optimize Workbook Function
  • Help

• Quick Tour

• Example Exercise(s)

  • Vendor List
  • Address Book
  • Lost Check Report
  • AP/GL Reconciliation

• Troubleshooting Articles