Select Field Assistant

Modified on Sun, 26 Jul at 4:22 AM

Overview

The QQube Excel Add-In includes a Select Assistant that lets you choose QuickBooks report fields for a Dynamic List or PivotTable without working directly with database tables, relationships, or data dictionaries.

QQube Excel Select Assistant for choosing report fields

QQube Selects the Fields; Excel Builds the Report

After you choose the required fields, close the Select Assistant and continue working entirely within Excel. Other than the Presentation Cleanup feature, the QQube Excel Add-In does not control the finished report.

How QQube Data Is Organized

QQube provides two primary types of data models.

Data Model	Structure
Financial Summary	May contain hundreds of measures and only a few dimensions, such as Account, Class, and Company.
Detail	May contain up to 50 measures and many dimensions. Examples include Sales, Inventory, Job Cost Details, Purchasing, General Ledger Detail, Profit and Loss Detail, Accounts Receivable, and Accounts Payable.

The following example shows the general layout of a Detail data model. Each model contains its own subset of fields, but the organization is consistent.

QQube Select Assistant showing the field organization for a Detail data model

Field Categories

Measures

Quantity, amount, and rate fields that can be summed, averaged, counted, or evaluated with minimum and maximum calculations.

Date Dimensions

Dates and related calendar attributes used for period-based reporting and analysis.

List Dimensions

QuickBooks list information such as Customer, Account, Item, Class, Vendor, and Employee.

Document Attributes

Fields that apply to the complete document, such as Reference Number, Terms, and Customer Custom Fields.

Document Dates

Individual transaction dates that are useful in applications that generate their own Date Dimension from a single date field.

Geography

Address information in both abbreviated and complete formats.

Document Line Attributes

Fields that apply to individual transaction lines, including Other 1 and Item Custom Fields used on transactions.

Linked Transactions

The Select Assistant also includes fields from transactions linked to the current document.

For example:

A Bill Payment Check is linked to the Bill it pays.
A Bill can also be linked to the Purchase Order from which it was received.
Both linked posting and linked non-posting information can be selected.

QQube Select Assistant showing Linked Transaction fields

Select Fields More Efficiently in Large Workbooks

In a large workbook, adding one field at a time can take several seconds because QQube rebuilds the underlying Excel structure after each selection.

1. Turn Off Auto Refresh

Clear the Auto Refresh option at the bottom of the Select Assistant.

QQube Select Assistant Auto Refresh option

2. Select All Required Fields

Choose every field needed for the report while Auto Refresh remains cleared.

3. Turn Auto Refresh Back On

Select Auto Refresh again.

QQube rebuilds the Excel structure once using all selected fields instead of rebuilding it after every individual choice.

Expected Result

Use the Select Assistant to choose QQube fields without working directly with the database structure. For larger workbooks, temporarily disable Auto Refresh so multiple field selections can be applied in one update.