Unable to set RefNumber via QuickBooks XML (qbXML version 11.0)

Question

I've tried both CheckAdd and CheckMod, and have been unable to set the RefNumber using QuickBooks Pro 2012 on Windows XP. I searched for RefNumber in the QuickBooks SDK Concepts Manual and didn't see anything that might address this problem. On the web, I did see a QODBC post on the topic.

Here's the CheckMod I tried. I don't receive an error when I issue this request; the RefNumber just isn't set.

<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="11.0"?>
<QBXML>
    <QBXMLMsgsRq onError="stopOnError">
        <CheckModRq>
            <CheckMod> <!-- required -->
                <TxnID >85-1388374219</TxnID> <!-- required -->
                <EditSequence >1388374219</EditSequence> <!-- required -->
                <RefNumber>12345678901</RefNumber>
            </CheckMod>
        </CheckModRq>
    </QBXMLMsgsRq>
</QBXML>

See my comments explaining why no answer has been yet accepted. — Brian, Jan 10 '14 at 16:51

user3150303 · Answer 1 · 2013-12-31T22:23:44.730

1

I had the same issue, only using QBFC. I fixed it by changing the line :

requestMsgSet = sessionManager.CreateMsgSetRequest("US", 2, 0)

To:

requestMsgSet = sessionManager.CreateMsgSetRequest("US", 13, 0)

So by referencing QBXMLMajorVersion that was older they changed something so it would stop saving the refnumber. Changing it to the 13 fixed it.

edited Dec 31 '13 at 22:23

answered Dec 31 '13 at 22:12

user3150303

11
2

Thanks; maybe someone else will be helped by your answer. I don't have version 12 or 13, so I can't verify your solution, sadly. I did try versions 2 through 10 with no success, though that's not what you were suggesting. – Brian Jan 01 '14 at 19:48

score 0 · Accepted Answer · answered Jan 07 '14 at 14:59

One thing to keep in mind is if the check is marked "To Be Printed" (or "Print Later" in later versions of QuickBooks), you'll need to mod this to false in order for the RefNum to save. I tested using the following request (my TxnID and EditSequence will of course be different):

<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="11.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "stopOnError">
        <CheckModRq requestID = "0">
            <CheckMod>
                <TxnID>3CF-1389105873</TxnID>
                <EditSequence>1389106557</EditSequence>
                <RefNumber>12345678901</RefNumber>
                <IsToBePrinted>0</IsToBePrinted>
            </CheckMod>
        </CheckModRq>
    </QBXMLMsgsRq>
</QBXML>

I've been unable to reproduce my error, and haven't seen the To Be Printed text within the checks. Perhaps the latter caused the former. Thanks for your answer. — Brian, Jan 10 '14 at 16:51
I wasn't able to verify Hpjchobbes answer, though from time to time I did see "To Be Printed" in checks. My guess is that his/her answer is correct. — Brian, Jan 17 '14 at 19:06

Unable to set RefNumber via QuickBooks XML (qbXML version 11.0)

2 Answers2