如何使用IntuitAnywhere拉存款QuickBooksOnline [英] How to pull Deposits from QuickBooksOnline using IntuitAnywhere

问题描述

我试图从QuickBooksOnline所有总帐条目拉进我的C＃Asp.net应用程序给定日期范围。我已经能够成功地拉匹配我使用参考盈亏详细报告票据，支票，和JournalEntries。但是，我似乎缺少从该报告中所有的存款的类型。我拉着数据发票和付款，但他们是来为我找的TxnDates空空的回来。

在情况下，它可以帮助我，包括发票和付款的请求和响应XML日志。

发票请求

 过滤= TxnDate：AFTER：2013-02-28T00：00：00-05：00：AND：TxnDate：BEFORE：2013-04-01T00：00：00-04： 00安培;页次= 1和; ResultsPerPage = 100
 

发票响应

 ＆LT; XML版本=1.0编码=UTF-8独立=YES＆GT;＆LT; QBO：？SearchResult所的xmlns =HTTP：// WWW。 intuit.com/sb/cdm/v2的xmlns：QBP =http://www.intuit.com/sb/cdm/qbopayroll/v1的xmlns：QBO =http://www.intuit.com/sb/ CDM / QBO＆GT;＆LT; QBO：CdmCollections的xmlns：XSI =http://www.w3.org/2001/XMLSchema-instance xsi:type=\"Invoices\"/><qbo:Count>0</qbo:Count><qbo:CurrentPage>1</qbo:CurrentPage></qbo:SearchResults>
 

付款申请

 过滤= TxnDate：AFTER：2013-02-28T00：00：00-05：00：AND：TxnDate：BEFORE：2013-04-01T00：00：00-04： 00安培;页次= 1和; ResultsPerPage = 100
 

付款响应

 ＆LT; XML版本=1.0编码=UTF-8独立=YES＆GT;＆LT; QBO：？SearchResult所的xmlns =HTTP：// WWW。 intuit.com/sb/cdm/v2的xmlns：QBP =http://www.intuit.com/sb/cdm/qbopayroll/v1的xmlns：QBO =http://www.intuit.com/sb/ CDM / QBO＆GT;＆LT; QBO：CdmCollections的xmlns：XSI =http://www.w3.org/2001/XMLSchema-instance xsi:type=\"Payments\"/><qbo:Count>0</qbo:Count><qbo:CurrentPage>1</qbo:CurrentPage></qbo:SearchResults>
 

解决方案

存款是不一样的事，作为一个发票或付款。存款是表示支付定金，到银行单独的事务。

据Intuit的文档，查询存款不被支持的第2版蜜蜂。

I am attempting to pull all the General Ledger entries from QuickBooksOnline into my C# Asp.net application for a given date range. I have been able to successfully pull Bills, Checks, and JournalEntries that match the Profit and Loss Detail report I'm using for reference. However, I seem to be missing all "Deposit" types from that report. I am pulling data for Invoices and Payments but they are coming back empty for the TxnDates I'm looking for.

In case it helps I'm including the Request and Response xml logs for Invoices and Payments.

Invoice Request

Filter=TxnDate :AFTER: 2013-02-28T00:00:00-05:00 :AND: TxnDate :BEFORE: 2013-04-01T00:00:00-04:00&PageNum=1&ResultsPerPage=100

Invoice Response

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><qbo:SearchResults xmlns="http://www.intuit.com/sb/cdm/v2" xmlns:qbp="http://www.intuit.com/sb/cdm/qbopayroll/v1" xmlns:qbo="http://www.intuit.com/sb/cdm/qbo"><qbo:CdmCollections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="Invoices"/><qbo:Count>0</qbo:Count><qbo:CurrentPage>1</qbo:CurrentPage></qbo:SearchResults>

Payment Request

    Filter=TxnDate :AFTER: 2013-02-28T00:00:00-05:00 :AND: TxnDate :BEFORE: 2013-04-01T00:00:00-04:00&PageNum=1&ResultsPerPage=100

Payment Response

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><qbo:SearchResults xmlns="http://www.intuit.com/sb/cdm/v2" xmlns:qbp="http://www.intuit.com/sb/cdm/qbopayroll/v1" xmlns:qbo="http://www.intuit.com/sb/cdm/qbo"><qbo:CdmCollections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="Payments"/><qbo:Count>0</qbo:Count><qbo:CurrentPage>1</qbo:CurrentPage></qbo:SearchResults>

解决方案

Deposits are not the same thing as an invoice or a payment. Deposits are a separate transaction indicating a deposit of a payment, to the bank.

According to Intuit's documentation, querying for deposits is not supported by the v2 APIs.

这篇关于如何使用IntuitAnywhere拉存款QuickBooksOnline的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！