Power BI Connector for QuickBooks

Build 23.0.8839

Accounts

Create, update, delete, and query QuickBooks Accounts. To update Accounts, set the QBXMLVersion to 6.0 or higher.

Table Specific Information

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for Accounts are Id, Name, Type, IsActive, and TimeModified. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM Accounts WHERE Name LIKE '%Bank%' AND TimeModified > '1/1/2011' AND TimeModified < '2/1/2011'

Insert

To add an Account, specify the Name and Type fields.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier of the account.

Name String False 31

The name of the account. This is required to have a value when inserting.

FullName String True 1000

The full name of the account, including any ancestors (parents) in the format Parent:AccountName.

Type String False 100

The type of account.

The allowed values are ACCOUNTSPAYABLE, ACCOUNTSRECEIVABLE, BANK, COSTOFGOODSSOLD, CREDITCARD, EQUITY, EXPENSE, FIXEDASSET, INCOME, LONGTERMLIABILITY, OTHERASSET, OTHERCURRENTASSET, OTHERCURRENTLIABILITY, OTHEREXPENSE, OTHERINCOME, NONPOSTING.

SpecialType String True 100

The special account type in QuickBooks if applicable.

The allowed values are AccountsPayable, AccountsReceivable, CondenseItemAdjustmentExpenses, CostOfGoodsSold, DirectDepositLiabilities, Estimates, ExchangeGainLoss, InventoryAssets, ItemReceiptAccount, OpeningBalanceEquity, PayrollExpenses, PayrollLiabilities, PettyCash, PurchaseOrders, ReconciliationDifferences, RetainedEarnings, SalesOrders, SalesTaxPayable, UncategorizedExpenses, UncategorizedIncome, UndepositedFunds.

Number String False

The bank number of the account.

Balance Double True

The total balance of the account, including subaccounts.

AccountBalance Double True

The balance of this account only. This balance does not include subaccounts.

BankAccount String False

The bank account number for the account (or an identifying note).

Description String False 200

A textual description of the account.

IsActive Boolean False

This property indicates whether the object is currently enabled for use by QuickBooks.

ParentName String False

This is a reference to a parent account. If set to a nonempty string, then this account is a subaccount of its parent.

ParentId String False

Accounts.ID

255

This is a reference to a parent account. If set to a nonempty string, then this account is a subaccount or job of its parent.

Sublevel Integer True

The number of ancestors the account has.

CurrencyName String False 64

The name of the currency for the account. A minimum QBXML version of 8.0 is required for this feature.

CurrencyId String False

Currency.ID

255

The unique Id of the currency for the account. A minimum QBXML version of 8.0 is required for this feature.

CashFlowClassification String True

Indicates how the account is classified for cash flow reporting.' value='None, Operating, Investing, Financing, NotApplicable.

TaxLineName String True 256

The name of the line on the tax form this account is associated with, if any. Check the CompanyInfo to see which tax form is associated with the company file.

TaxLineId String False 255

The Id of the line on the tax form this account is associated with, if any. Check the CompanyInfo to see which tax form is associated with the company file. Requires QBXML Version 7.0 to modify.

TimeModified Datetime True

When the account was last modified.

TimeCreated Datetime True

When the account was created.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
OpeningBalance String

The opening balance of the account (by default 0). Note that this property is only used when adding new accounts to QuickBooks.

OpeningDate String

The opening balance date of the account. Note that this property is only used when adding new accounts to QuickBooks.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839