Template Dimension

Modified on Tue, 28 Jul at 12:19 AM

Template Summary

The QQube Template Dimension contains the transaction templates maintained in QuickBooks. Templates control form layouts and can also identify different business processes or transaction stages.

Dimension Type

QuickBooks list dimension

Template Represents

A QuickBooks form template and its associated transaction type

QuickBooks Source

Templates List

Primary Use

Group or filter transactions by form, sales category, or workflow stage

Included Data Models

Customers: Sales, Open Sales Orders, Accounts Receivable

Operations: Purchases, Open Purchase Orders, Inventory, Job Cost Details

Finance: General Ledger Detail, Profit and Loss Detail, Cash Position

QuickBooks Source

Template information comes from the Templates List in QuickBooks. Each template has a unique name and is associated with a specific transaction type.

Source Transactions

  • Estimate
  • Sales Order
  • Invoice
  • Credit Memo
  • Sales Receipt
  • Purchase Order

Source Example

QuickBooks Templates List source example

Reporting uses

In Sales analytics, templates can categorize different types of sales. In Job Cost Details, templates can distinguish original estimates from change orders. QuickBooks does not permit negative estimates or change orders.

Missing templates

Missing or inapplicable template information appears as (No Template).

Available Fields

Display OrderField Name
1Template Active
2Template Name
3Template Type

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article