Missing and MIsmatched data from QBXML data retrieval - Stack Overflow

admin管理员组

文章数量:1277888

Im working with QBXML to retrieve the detail transaction report by account, which should get me 62K transaction records.about 60K of them are correct, matching my data from using my old VBA routine that used QBFC. The other 2K are either missing records (like only the credit part of a simple check transaction), or have the TxnID being shared with two completely separate transactions (like one side is a check, the other is a closing entry for retained earnings. Anyone have any problem like this? Here is an example of what the data looks like for the same TxnID:

any idea for why QBXML might be returning this kind of data?

search for the txnnumber=11767 in all the XML files, only one of two records come up

<DataRow rowNumber="178">
<RowData rowType="account" value="Cash:Checking-All:cashUSB" />
<ColData colID="2" value="11767" />
<ColData colID="3" value="Check" />
<ColData colID="4" value="2021-12-29" />
<ColData colID="5" value="-44.98" />
<ColData colID="6" value="cashUSB" />
<ColData colID="7" value="Bank Service Charges" />
<ColData colID="8" value="Harland Clarke" />
<ColData colID="12" value="44.98" />
<ColData colID="15" value="D-50775" />
<ColData colID="16" value="01/10/22 22:34:44" />
<ColData colID="17" value="F172-1641872084" />
</DataRow>

Search for txnID=F172-1641872084 which is the correct TxnId for that TxnNumber, and this false record came up, missing a lot of columns: found one instance embedded in a subtotal or text row. not a correct amount

<TextRow rowNumber="2483" value="Retained Earnings" />
<DataRow rowNumber="2484">
<RowData rowType="account" />
<ColData colID="2" value="0" />
<ColData colID="3" value="Closing Entry " />
<ColData colID="4" value="2021-12-31" />
<ColData colID="5" value="5062.49" />
<ColData colID="13" value="5062.49" />
<ColData colID="16" value="12/31/21 00:00:00" />
<ColData colID="17" value="F172-1641872084" />
</DataRow>
<DataRow rowNumber="2485">
<RowData rowType="account" value="Retained Earnings" />
<ColData colID="1" value="Total Retained Earnings" />
<ColData colID="5" value="5062.49" />
<ColData colID="12" value="0.00" />
<ColData colID="13" value="5062.49" />
</DataRow>
<TextRow rowNumber="2486" value="Total Shareholder Loans/Distrib" />
<TextRow rowNumber="2487" value="Loans from Shareholder" />

本文标签： Missing and MIsmatched data from QBXML data retrievalStack Overflow