Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
 Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : How do I pay a bill via wire transfer or EFT?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC SQL Sample Scripts Forum

 New Topic 
 
 Post Reply 
[1]  
 How do I pay a bill via wire transfer or EFT? 
 Author   Message 
  Sal 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-06-29 
 Profile
 Posted : 2007-09-20 00:47:59
 Thanks for the good examples of bill payments.  Now I'm wondering how I can pay a bill without using a check # (by wire transfer or EFT or some other method).  QB help says to go to Pay Bills and select Assign a check no, then put Wire or some other reference in the check# field.  How would this be done in QODBC?

Thanks,

Sally 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-20 10:22:58

When you do this in QuickBooks:

it simply inserts "Wire#1234" as the check refnumber. To apply the payment with a RefNumber using QODBC we simply do:

INSERT INTO BillPaymentCheckLine (PayeeEntityRefFullName, BankAccountRefFullName,
RefNumber, IsToBePrinted, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, FQSaveToCache)
Values ('John Smith', 'Checking', 'Wire#1234', 1, '5CBA-1197768466', 100.00, {d'2007-12-31'}, 0)

See: How can I apply check payments or credits to bills? for more details.

 

 

  Top 
  Sal 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-06-29 
 Profile
 Posted : 2007-10-03 04:00:57
Now I'm getting the following error on every wire transfer payment posting:

IsAService: False
SQL Statement: INSERT INTO  "BillPaymentCheckLine"  ("PayeeEntityRefFullName","TxnDate","BankAccountRefFullName","RefNumber","IsToBePrinted","AppliedToTxnTxnID","AppliedToTxnPaymentAmount","FQSaveToCache") VALUES (?,?,?,?,?,?,?,?)
Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll">
        <BillPaymentCheckAddRq requestID = "1">
            <BillPaymentCheckAdd defMacro = "TxnID:51840C14-6509-40C5-9C14-547CEDE66E30">
                <PayeeEntityRef>
                    <FullName>AMERICAN TRADING &amp; COMPANY_V</FullName>
                </PayeeEntityRef>
                <TxnDate>2007-10-02</TxnDate>
                <BankAccountRef>
                    <FullName>Bank of America - Operating</FullName>
                </BankAccountRef>
                <RefNumber>Wire B7037</RefNumber>
                <IsToBePrinted>0</IsToBePrinted>
                <AppliedToTxnAdd>
                    <TxnID>E8E-1191347699</TxnID>
                    <PaymentAmount>5961.52</PaymentAmount>
                </AppliedToTxnAdd>
            </BillPaymentCheckAdd>
        </BillPaymentCheckAddRq>
    </QBXMLMsgsRq>
</QBXML>

The code that runs from Access is:

   sSQL = "INSERT INTO BillPaymentCheckLine (PayeeEntityRefFullName, TxnDate, BankAccountRefFullName, RefNumber, IsToBePrinted, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, FQSaveToCache)" & _
          "VALUES (""" & chkQuotes(VendName) & """, """ & TransDate & """,""" & chkQuotes(AcctName) & """, """ & chkQuotes(RefNo) & """, 0, """ & TxnId & """, " & Amount & ",  0)"
   dbs.Execute sSQL

The SQL looks fine.  Any idea what is causing the error?

Thanks 

  Top 
  Sal 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-06-29 
 Profile
 Posted : 2007-10-03 04:31:52
Here's some more info from the SDK message file:

20071002.142713    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 4232).
20071002.142714    I    5708    SpecVersion    Current version of qbXML in use: 6.0
20071002.142714    I    5708    QBSDKMsgSetHandler    QUERY: Bill
20071002.142714    I    5708    BillStorage::DoQuery    Setting iterator chunk size to 00000500
20071002.142714    I    5708    QBSDKMsgSetHandler    Request 1 completed successfully.
20071002.142714    I    5708    MsgSetHandler    Finished.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 4232), ret = 0.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 4232).
20071002.142714    E    5708    XercesSAXErrorHandler    Element 'IsToBePrinted' is not valid for content model: '(PayeeEntityRef,APAccountRef?,TxnDate?,BankAccountRef,(IsToBePrinted|RefNumber),Memo?,AppliedToTxnAdd+)' -- error at line 7, column 375 in XML data.
20071002.142714    I    5708    MsgSetHandler    Parser error, finishing.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 4232), ret = 1.
20071002.142714    E    4232    RequestProcessor    Process Request error = 80042500, There was an error when parsing the provided XML file.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 4232).
20071002.142714    E    5708    XercesSAXErrorHandler    Element 'IsToBePrinted' is not valid for content model: '(PayeeEntityRef,APAccountRef?,TxnDate?,BankAccountRef,(IsToBePrinted|RefNumber),Memo?,AppliedToTxnAdd+)' -- error at line 7, column 375 in XML data.
20071002.142714    I    5708    MsgSetHandler    Parser error, finishing.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 4232), ret = 1.
20071002.142714    E    4232    RequestProcessor    Process Request error = 80042500, There was an error when parsing the provided XML file.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 4232).
20071002.142714    E    5708    XercesSAXErrorHandler    Element 'IsToBePrinted' is not valid for content model: '(PayeeEntityRef,APAccountRef?,TxnDate?,BankAccountRef,(IsToBePrinted|RefNumber),Memo?,AppliedToTxnAdd+)' -- error at line 7, column 375 in XML data.
20071002.142714    I    5708    MsgSetHandler    Parser error, finishing.
20071002.142714    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 4232), ret = 1.
20071002.142714    E    4232    RequestProcessor    Process Request error = 80042500, There was an error when parsing the provided XML file.
20071002.142715    I    5708    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 4232).
20071002.142715    I    5708    SpecVersion    Current version of qbXML in use: 6.0
20071002.142715    I    5708    QBSDKMsgSetHandler    QUERY: Bill Payment Check
20071002.142715    I    5708    BillPmtCheckStorage::DoQuery    Setting iterator chunk size to 00000500
20071002.142715    I    5708    QBSDKMsgSetHandler    Request 1 completed successfully.
20071002.142715    I    5708    MsgSetHandler    Finished.

Looks like something with IsToBePrinted? 

  Top 
  Sal 
  
 Group: Members 
 Posts: 6 
 Joined: 2007-06-29 
 Profile
 Posted : 2007-10-03 04:45:03
I removed IsToBePrinted field from the INSERT statement and it worked fine.  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to