Open Purchase Orders Data Model

Modified on Wed, 29 Jul at 1:24 AM

Model Summary

The QQube Open Purchase Orders Data Model contains only Purchase Orders that are open in QuickBooks.

Model Type	Open Purchase Order analysis
Transaction Coverage	Linked posting and non-posting transactions
Purchase Order Scope	Open Purchase Orders only
Available Fields	More than 750
Primary Use	Analyze open quantities, amounts, expected dates, and remaining commitments

Native fields come from QuickBooks Purchase Order data. QQube field extensions add selected printed-unit values.

Quantity Fields	Rate Fields	Amount Fields
Line Original Quantity Line Received Quantity Line Open Quantity Line Open Quantity [Printed]	Line Rate Line Rate (Foreign) Line Exchange Rate Line Tax Rate (CAN)	Line Original Amount Line Original Amount (Foreign) Line Original Amount (CAN) Line Received Amount Line Received Amount (Foreign) Line Received Amount (CAN) Line Open Amount Line Open Amount (Foreign) Line Open Amount (CAN)

Quantity Fields	Rate Fields	Amount Fields
Line Original Quantity [Printed] Line Received Quantity [Printed]	Line Rate [Printed]

The prepared Open Purchase Orders examples include 41 visible DAX measures in three display folders. Hidden measures are not included.

Model Structure	One Open Purchase Orders FACT table with related dimensions and relationships already included
Purchase Order Scope	Open Purchase Orders only
DAX Availability	Power BI and Excel Power Pivot examples

Open the prepared example and analyze open Purchase Orders by expected date, customer or job, class, vendor, locality, quantity, or amount.

The FACT table, dimensions, relationships, fields, QQube extensions, and measures are already included.