RSSBus.QbOps

Operations for accessing QuickBooks and performing operations on QB objects. If QB is not running on the server, connstr must be used.

Version: 2.0.24575.0 [Release]
qbAddCreditMemo qbAddCustomer qbAddEstimate qbAddInvoice qbAddItem qbAddJournalEntry qbAddPO qbAddSalesOrder qbAddSalesReceipt qbAddVendor qbDeleteCreditMemo qbDeleteCustomer qbDeleteEstimate qbDeleteInvoice qbDeleteItem qbDeleteJournalEntry qbDeletePO qbDeleteSalesOrder qbDeleteSalesReceipt qbDeleteVendor qbGetCreditMemo qbGetCustomer qbGetEstimate qbGetInvoice qbGetItem qbGetJournalEntry qbGetPO qbGetSalesOrder qbGetSalesReceipt qbGetVendor qbSearchCreditMemos qbSearchCustomers qbSearchEstimates qbSearchInvoices qbSearchItems qbSearchJournalEntries qbSearchPOs qbSearchSalesOrders qbSearchSalesReceipts qbSearchTransactions qbSearchVendors qbUpdateCreditMemo qbUpdateCustomer qbUpdateEstimate qbUpdateInvoice qbUpdateItem qbUpdateJournalEntry qbUpdatePO qbUpdateSalesOrder qbUpdateSalesReceipt qbUpdateVendor

qbSearchPOs Operation

Searches Purchase Orders in QuickBooks by ref number, transaction dates, and/or vendor name.

Required Parameters

refnumber Full or partial Purchase Order reference number. This can be entered in the following formats: refstartswith*, *refendswith, or just refcontains.

Optional Parameters

 conn Connection string consisting of various QuickBooks connection properties for connecting to a QuickBooks instance. If QuickBooks is not running locally, a URL must be specified (i.e. URL='http://myserver'). If opening QuickBooks file locally and QuickBooks is already not open, a company file must be specified. Example: CompanyFile='C:/mycompanyfile.qbw'. Other possible values to provide are 'ApplicationName', 'User', 'Password', 'DelayAfterClose'. If using QuickBooks Online Edition 'QBOEConnectionTicket', 'QBOESessionTicket', 'QBOELogin'.
 customername Vendor name this Purchase Order is issued to.
 startdate Earliest transaction date to search for (in MM-DD-YY, MM-DD-YYYY, MM/DD/YY, or MM/DD/YYYY format).
 enddate Latest transaction date to search for (in MM-DD-YY, MM-DD-YYYY, MM/DD/YY, or MM/DD/YYYY format).
 maxresults Maximum number of results to be returned from this search.

Namespaces

 qb http://www.rssbus.com/ns?QbOps/v1


Output Attributes

 qb:refnumber Purchase Order number.
 qb:id Transaction ID.
 qb:trdate Transaction date.
 qb:duedate Date when payment is due.
 qb:shipvia Shipping method.
 qb:expecteddate Date when the shipment is expected.
 qb:memo Memo regarding this transaction.
 qb:terms Payment terms.
 qb:totalamount Total amount for this Purchase Order.
 qb:message Message to the vendor.
 qb:vendor_name Vendor name this Purchase Order is issued to.
 qb:vendor_address Vendor full address.
 qb:vendor_street Vendor street address.
 qb:vendor_city Vendor city name.
 qb:vendor_state Vendor state name.
 qb:vendor_zip Vendor zip code.
 qb:vendor_country Vendor country.
 qb:shipto_address Full shipping address.
 qb:shipto_name Name for shipping.
 qb:shipto_street Street address for shipping.
 qb:shipto_city City name for shipping.
 qb:shipto_state State name for shipping.
 qb:shipto_zipcode Zip code for shipping.
 qb:shipto_country Country for shipping.
 qb:item_id# Item ID.
 qb:item_name# Item name.
 qb:item_groupname# Item group name.
 qb:item_desc# Item description.
 qb:item_qty# Item quantity.
 qb:item_rate# Item rate.
 qb:item_ratepercent# Item markup or discount percentage.
 qb:item_amount# Total amount for this item.
 qb:item_servicedate# Item date of service.
 qb:item_customername# Customer name for whom the item was ordered.
 qb:template Template used by this transaction.
 qb:editsequence An identifier for this copy of the object, used for versioning.
 qb:tx_id# ID of a linked transaction.
 qb:tx_type# Type of a linked transaction.
 qb:tx_refnumber# Reference number of a linked transaction.
 qb:tx_linktype# Indicates the nature of a link between the transactions (based on amount value or quantity).
 qb:tx_amount# Amount of a linked transaction.
 qb:tx_date# Date of a linked transaction.