QQube for QuickBooks Dimension Details

Version 46

Dimension Details

CLEARIFY® TEAM

Published: 3/28/2017

CLEARIFY® TEAM

Updated: 11/25/2023

0
3916

0 (0votes)

Using Dimensions in QQube for QuickBooks

QQube Technology uses traditional warehousing components to achieve the final results. One of those components is called a DIMENSION, which is nothing more than "I want to measure (e.g. sum, max, avg, count,etc.) BY something.

For example, if you choose to sum the Line Sales Quantity measure from QQube, it would just show a single figure in a single cell, with no context. However if you choose a Customer DIMENSION called Customer Name, then each Customer Name would have its own summed Sales Quantity - one in each cell.

Dragging in Customer Name means that the Sales Amount now has "context" e.g. each customer has a sales amount total.

Available QQube™ Dimensions

NOTE: Date Dimensions are handled in a different section.

DIMENSION	DATA MODEL WHERE DIMENSION IS USED
Account	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Payroll Balance Sheet - Standard Profit and Loss - Standard Trial Balance - Current Trial Balance - All Dates Trial Balance - Activity Statement of Cash Flows Profit and Loss - Job (Enterprise) Profit and Loss - Actuals/Budget/Forecast (Enterprise) Profit and Loss - 52/53 Tax Year (Enterprise) Balance Sheet by Class - Standard Profit and Loss by Class - Standard Trial Balance by Class - Activity Statement of Cash Flows by Class Profit and Loss by Job by Class (Enterprise) Profit and Loss by Class - Actuals/Budget/Forecast (Enterprise) Profit and Loss by Class - 52/53 Tax Year (Enterprise) General Ledger Detail Profit and Loss Detail Cash Position Fixed Assets Audit Trail
Account - Balance Sheet	Balance Sheet - Standard Balance Sheet by Class - Standard
Account - Cash Flow	Statement of Cash Flows
Account - Cost of Goods Sold	Sales
Account - Expense Offset	Accounts Payable
Account - Fixed Asset	Fixed Assets
Account - Inventory	Inventory Management
Account - Profit and Loss	Profit and Loss - Standard Profit and Loss by Class - Standard Profit and Loss Detail
Account - Sales	Sales Inventory Management
Account - Summary	Sales General Ledger Detail Profit and Loss Detail Audit Trail
Bin Location	Sales Open Sales Orders Inventory Management General Ledger Detail Profit and Loss Detail
Class	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll Balance Sheet by Class - Standard Profit and Loss by Class - Standard Trial Balance by Class - Activity Statement of Cash Flows by Class Profit and Loss by Class - Job (Enterprise) Profit and Loss by Class - Actuals/Budget/Forecast (Enterprise) Profit and Loss by Class - 52/53 Tax Year (Enterprise) General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Company	Used in ALL data models
Currency	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position
Customer	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Customer Message	Sales Open Sales Orders Accounts Receivable
Customer Rep	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Customer Sales Tax Code	Sales Open Sales Orders
Document Attributes	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Line Attributes	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Document Sales Tax Item	Sales Open Sales Orders
Employee	Purchases Accounts Payable Inventory Management Job Cost Details Time Tracking General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Employee HR	Payroll
Geography	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Cash Position
Item	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Fixed Assets Audit Trail
Item Sales Tax Code	Sales Open Sales Orders Purchases Open Purchase Orders Audit Trail
Job	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Job Rep	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Other Name	Accounts Receivable Purchases Accounts Payable Inventory Management Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Payment Method	Sales General Ledger Detail Profit and Loss Detail Audit Trail
Payroll Item	Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Audit Trail
Sales Rep	Sales Open Sales Orders Accounts Receivable Purchases Accounts Payable Inventory Management Job Cost Details Cash Position
Sales Tax Item	Accounts Receivable General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Service Item	Time Tracking Vehicle Mileage Payroll
Ship Method	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Inventory Management Job Cost Details Cash Position Audit Trail
Site	Sales Open Sales Orders Inventory Management General Ledger Detail Profit and Loss Detail
Source Name	Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Template	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position
Terms	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Cash Position Audit Trail
UofM	Sales Open Sales Orders Purchases Open Purchase Orders Inventory Management Job Cost Details
Vehicle	Job Cost Details Vehicle Mileage
Vendor	Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail

Comments (no comments yet)

Add a new comment

QQube for QuickBooks Dimension Details | CLEARIFY

Support Guides

Dimension Details

Using Dimensions in QQube for QuickBooks

Available QQube™ Dimensions

Comments (no comments yet)

Search Support Guides

Pages

QQube for QuickBooks Dimension Details | CLEARIFY

Support Guides

Dimension Details

Share

Using Dimensions in QQube for QuickBooks

Available QQube™ Dimensions

Comments (no comments yet)

Search Support Guides

Pages

Loading ...