WebConnector with Auto-Run checked, inserting Duplicate Invoice to the QuickBooks with Rails 3.2.9 -


i using web connector add invoice quickbooks v13. have added provided logic add invoice if invoice not added quickbooks.

when have set autorun option of web connector automatically call api. if have 1 invoice add, first run working fine. second call webconnector, search result invoice in quickbooks sends record statuscode="0" means exist still once again added same invoice quickbooks. not able restrict adding of same invoice multiple time

following rails code insert invoice quickbooks. using qbwc gem in rails application send qbxml request , parse response

def api    if request.get?      render :nothing => true      return    end    if params["envelope"]["body"].keys.first =="authenticate"      add_invoice #add invoice method called search/add invoice    end    req = request    rails.logger.info "=== #{ params["envelope"]["body"].keys.first}  ==="    res = qbwc::soapwrapper.route_request(req)    rails.logger.info render :xml => res, :content_type => 'text/xml'  end

#action search/add invoice

def add_invoice    #searching invoice quickbooks    qbwc.add_job('search_invoice')     '<qbxml>        <qbxmlmsgsrq onerror="continueonerror">          <invoicequeryrq requestid="1">            <refnumber>58869</refnumber>          </invoicequeryrq>        </qbxmlmsgsrq>      </qbxml>'    end      #response of search result    qbwc.jobs['search_invoice'].set_response_proc |r|      if r["xml_attributes"]["statuscode"] == "500" || r["xml_attributes"]["statuscode"] == "1"        #add invoice        qbwc.add_job('add_invoice')          '<qbxml>         <qbxmlmsgsrq onerror="continueonerror">         <invoiceaddrq requestid="58869">         <invoiceadd>         <customerref>         <listid>8000000d-1365397507</listid>         <fullname>john.doe@test.com</fullname>         </customerref>         <txndate>2013-04-08</txndate>         <refnumber>58869</refnumber>         <billaddress>           <addr1>n dallas parkway</addr1>           <city>addison</city>           <state>tx</state>           <postalcode>75001</postalcode>           <country>united states</country>         </billaddress>                 <shipaddress>           <addr1>n dallas parkway</addr1>           <city>addison</city>           <state>tx</state>           <postalcode>75001</postalcode>           <country>united states</country>         </shipaddress>           <ispending>true</ispending>           <ponumber>test qb</ponumber>           <termsref>                    <fullname>visa</fullname>                  </termsref>           <shipdate>2013-04-15</shipdate>           <invoicelineadd>           <itemref>           <fullname>test invoice</fullname>           </itemref>           <desc>test description</desc>           <quantity>1</quantity>           <rate>1000</rate>           </invoicelineadd>         </invoiceadd>         </invoiceaddrq>         </qbxmlmsgsrq>          </qbxml>'        end      end    end    end

i have set autorun option of web connector 5 min, automatically run 5 minute interval , call api.

let's invoice refnumber#58869 new , not present in quickbooks.

when webconnector call api, qbxml request search invoice refnumber#58869 sent quickbooks. gives following response

<?xml version=\"1.0\" ?>\n<qbxml>\n<qbxmlmsgsrs>\n<invoicequeryrs requestid=\"1\" statuscode=\"500\" statusseverity=\"warn\" statusmessage=\"the query request has not been completed. there required element ("58869" not found in quickbooks.\" />\n</qbxmlmsgsrs>\n</qbxml>\n"

and invoice added quickbooks

when webconnector call api after 5 min interval, qbxml request search invoice refnumber#58869 sent quickbooks. gives following response

<?xml version=\"1.0\" ?>\n<qbxml>\n<qbxmlmsgsrs>\n<invoicequeryrs requestid=\"1\" statuscode=\"0\" statusseverity=\"info\" statusmessage=\"status ok\">\n<invoiceret>\n<txnid>15f-1365397789</txnid>\n<timecreated>2013-04-08t10:39:49+05:30</timecreated>\n<timemodified>2013-04-08t10:39:49+05:30</timemodified>\n<editsequence>1365397789</editsequence>\n<txnnumber>62</txnnumber>\n<customerref>\n<listid>8000000d-1365397507</listid>\n<fullname>john.doe@test.com</fullname>\n</customerref>\n<araccountref>\n<listid>8000001e-1364292331</listid>\n<fullname>john doe</fullname>\n</araccountref>\n<templateref>\n<listid>80000001-1364291996</listid>\n<fullname>intuit product invoice</fullname>\n</templateref>\n<txndate>2013-04-08</txndate>\n<refnumber>58869</refnumber>\n<billaddress>\n<addr1>16001 n dallas parkway</addr1>\n<city>addison</city>\n<state>tx</state>\n<postalcode>75001</postalcode>\n<country>usa</country>\n</billaddress>\n<billaddressblock>\n<addr1>16001 n dallas parkway</addr1>\n<addr2>addison, tx 75001</addr2>\n<addr3>united states</addr3>\n</billaddressblock>\n<shipaddress>\n<addr1>16001 n dallas parkway</addr1>\n<city>addison</city>\n<state>tx</state>\n<postalcode>75001</postalcode>\n<country>usa</country>\n</shipaddress>\n<shipaddressblock>\n<addr1>16001 n dallas parkway</addr1>\n<addr2>addison, tx 75001</addr2>\n<addr3>united states</addr3>\n</shipaddressblock>\n<ispending>true</ispending>\n<isfinancecharge>false</isfinancecharge>\n<ponumber>united way</ponumber>\n<termsref>\n<listid>8000000c-1364361757</listid>\n<fullname>visa</fullname>\n</termsref>\n<duedate>2013-04-08</duedate>\n<shipdate>2013-04-15</shipdate>\n<subtotal>67.24</subtotal>\n<itemsalestaxref>\n<listid>80000012-1364967363</listid>\n<fullname>sales tax</fullname>\n</itemsalestaxref>\n<salestaxpercentage>0.00</salestaxpercentage>\n<salestaxtotal>0.00</salestaxtotal>\n<appliedamount>0.00</appliedamount>\n<balanceremaining>67.24</balanceremaining>\n<ispaid>false</ispaid>\n<istobeprinted>true</istobeprinted>\n<istobeemailed>false</istobeemailed>\n<customersalestaxcoderef>\n<listid>80000001-1364291997</listid>\n<fullname>tax</fullname>\n</customersalestaxcoderef>\n</invoicequeryrs>\n</qbxmlmsgsrs>\n</qbxml>\n

here 'statuscode' "0" means response says invoice present in quickbooks.

but still same invoice again added quickbooks. , not able find solution restrict adding of same invoice multiple time.

i have tracked "statuscode" , found quickbooks sending correct status code. maintaining flag in order table track invoice added order quickbooks or not. think problem webconnector. when webconnector's autorun option active, adding last order's invoice again , again if there no order left add quickbooks.


Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());
Read more