Knowledgebase
[QXL Online] Differences in data available between QXL Online and QuickBooks Online's export feature
Posted by Andy - QODBC Support on 06 July 2022 07:54 AM

Differences in data available between QXL Online and QuickBooks Online's export feature

I want to share with you that you can extract the limited number of fields in Reports and Tables through QuickBooks Online's export feature. However, you can get each field record using QXL Online as Intuit API provide.

List of tables available through QXL Online and QuickBooks Online's Export

Tables available through QXL OnlineTables available through QuickBooks Online's Export
Account Customer
Attachable Employee
AttachableReference Vendor
Bill Sales
BillExpenseLine ProductServiceList
BillItemLine
BillLinkedTxn
BillPayment
BillPaymentAppliedToTxn
BillPaymentLine
Budget
BudgetDetailLine
Check
CheckExpenseLine
Class
Company
CompanyCurrency
CompanyCurrencyAttachable
CreditCardCharge
CreditCardChargeExpenseLine
CreditCardCredit
CreditCardCreditExpenseLine
CreditMemo
CreditMemoLine
CreditMemoLinkedTxn
Customer
CustomField
DateDrivenTerms
Department
Deposit
DepositAppliedToTxn
DepositAttachable
DepositLine
Employee
Entitlements
Entity
Estimate
EstimateLine
EstimateLinkedTxn
Host
HostSupportedVersions
Invoice
InvoiceLine
InvoiceLinkedTxn
ItemGroup
ItemGroupLine
ItemService
JournalEntry
JournalEntryCreditLine
JournalEntryDebitLine
JournalEntryLine
ListDeleted
Payment
PaymentAppliedToTxn
PaymentLine
PaymentMethod
Preferences
PreferencesPOCustomField
Purchase
PurchaseExpenseLine
PurchaseItemLine
PurchaseLine
PurchaseOrder
PurchaseOrderExpenseLine
PurchaseOrderItemLine
PurchaseOrderLine
PurchaseOrderLinkedTxn
PurchaseOrderTxnLineDetail
PurchaseTxnLineDetail
ReceivePayment
ReceivePaymentLine
RefundReceipt
RefundReceiptLine
SalesReceipt
SalesReceiptLine
StandardTerms
TaxAgency
TaxCode
TaxCodePurchaseTaxRateDetail
TaxCodeSalesTaxRateDetail
TaxRate
TaxRateEffectiveTaxRate
TaxService
TimeTracking
Transfer
TxnDeleted
Vendor
VendorCredit
VendorCreditExpenseLine
VendorCreditItemLine
VendorCreditLine
VendorCreditLinkedTxn
VendorContacts

List of Reports available through QXL Online and QuickBooks Online's Export

Reports available through QXL OnlineReports available through QuickBooks Online's Export
AccountList AccountList
BalanceSheetDetail BalanceSheetDetail
GeneralLedger GeneralLedger
CustomerBalanceDetail CustomerBalanceDetail
CustomerBalanceSummary CustomerBalanceSummary
ExpenseByVendorSummary ExpenseByVendorSummary
CashFlow CashFlow
IncomeByCustomerSummary IncomeByCustomerSummary
InventoryValuationSummary InventoryValuationSummary
JournalReportFR JournalReportFR
ProfitAndLossDetail ProfitAndLossDetail
ProfitAndLossStandard ProfitAndLossStandard
SalesByClassSummary SalesByClassSummary
SalesByCustomerSummary SalesByCustomerSummary
VendorBalanceDetail VendorBalanceDetail
VendorBalanceSummary VendorBalanceSummary
TrialBalance TrialBalance
APAgingDetail APAgingDetail
SalesByDepartmentSummary SalesByDepartmentSummary
SalesByItemSummary SalesByItemSummary
TaxSummary TaxSummary
APAgingSummary APAgingSummary
ARAgingDetail ARAgingDetail
ARAgingSummary ARAgingSummary
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).