Account - Inventory Dimension

Modified on Mon, 27 Jul at 11:07 PM

Inventory Account Summary

The QQube Inventory Account Dimension contains QuickBooks accounts used to identify inventory activity.

Dimension Type

QuickBooks list dimension

Account Represents

An inventory account from the QuickBooks Chart of Accounts

QuickBooks Source

Account List

Primary Use

Group or filter inventory activity by inventory account

Included Data Models

Operations: Inventory

QuickBooks Source

The fields are derived from the Account List in QuickBooks.

This dimension provides a separate inventory account role so the Inventory data model can use Sales, Inventory, and Cost of Goods Sold account dimensions simultaneously.

Source Example

QuickBooks Account List source for the Inventory Account Dimension

Separate account role

The Inventory Account Dimension allows inventory accounts to be analyzed independently from other account roles in the same data model.

Available Fields

Display Order	Field Name
1	Inventory Account Active
2	Inventory Account Level
3	Inventory Account Has Children
4	Inventory Account Parent Full Name
5	Inventory Account Full Name
6	Inventory Account Name
7	Inventory Account Number
8	Inventory Account Number and Name
9	Inventory Account Description
10	Inventory Account Type
11	Inventory Account Category
12	Inventory Account Posting Type
13	Inventory Account Special Type
14	Inventory Account Cash Flow Classification
15	Inventory Account Tax Line Description