Accounts Payable Data Model

Overview of the QuickBooks Accounts Payable Data Model

This data model is based upon the actual Accounts Receivable report in QuickBooks, and the date is controlled in the QQube Configuration Tool.

You have the ability to due aging by Transaction Date AND Due Date in the same report.

Features

• Over 850 available fields
• 22 Measures including 9 not available in any QuickBooks report
• 35 Additional DAX measures for Power/Pivot and Power BI
• Posting and LInked Transactions
• Printed and Base U of M Quantities
• Home and Foreign Currencies
• Simultaneous Due Date and Transaction Date buckets

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Due Date Suggested Discount Date Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes Geography
	List Based Dimensions:  Account (Purchases) Account - Expense Offset Class Company Currency Customer Customer Rep Employee Item Job Job Rep Other Name Sales Rep Terms Vendor
	Linked Information:  Payables Linked Transactions Account (Cash Source)

Additional DAX Measures for PowerPivot and Power BI