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 Online | Tables 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 Online | Reports 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 |
|