RSS Feed
Knowledgebase : QODBC > SQL Language Support (Syntax)
     

TROUBLESHOOTING - HOW TO APPLY PAYMENT TO MULTIPLE INVOICE PROBLEM DESCRIPTION: How can a payment be applied to multiple invoices? Scenario 1 - 3 Invoices are created. - A payment is received that covers 2 of the invoices, but not necessarily in ...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN QLIKSENSE DESKTOP USING QODBC PROBLEM DESCRIPTION: How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC? SOLUTION: Please create a new application in QlikSense Desktop & c...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA EXTENSION NAMED ". "QUICKBOOKS ERROR MESSAGE: ATTRIBUTE WITH THE SPECIFIED NAME ALREADY EXISTS. PROBLEM DESCRIPTION: I am using QODBC for creating Invoices in QuickBooks. I am using C...
TROUBLESHOOTING - HOW CAN I ADD A LINE TO AN EXISTING CHECK PROBLEM DESCRIPTION: Is it possible to add a line to a check that already exists? Here is an example from the QB Sample file. Below is a check for $500.00 Now I want to add additional item...
TROUBLESHOOTING - HOW TO RECEIVE INVENTORY WITHOUT PURCHASE ORDERS PROBLEM DESCRIPTION: Is it possible to register an item's arrival without the purchase order? If yes, can I insert the rows in the "ItemReceiptItemLine" table using the reference to B...
TROUBLESHOOTING - DOES SP_REPORT SUPPORT LIKE QUERY PROBLEM DESCRIPTION 1: Does sp_report support "Like" in the parameter? For example, sp_report CustomTxnDetail shows Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAc...
TROUBLESHOOTING - HOW TO FIND AN ESTIMATE FOR INVOICE CONVERSION TIME PROBLEM DESCRIPTION: I am using MS Excel to access QuickBooks Data through QODBC. I have Estimate & some of the Estimates are converted to QuickBooks. I want to know how many Estimat...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG OR SCHEMA. PROBLEM DESCRIPTION: I am using QODBC to fetch QuickBooks Data in SQL Server. I have created Linked S...
TROUBLESHOOTING - GETTING ERROR [HY004] [MICROSOFT][ODBC DRIVER MANAGER] SQL DATA TYPE OUT OF RANGE (0) (SQLBINDPARAMETER) WHEN RUNNING PYTHON SCRIPT PROBLEM DESCRIPTION: I am using Python script to access QuickBooks Data. I can select QuickBooks Data ...
TROUBLESHOOTING - HOW TO FIND AN ITEM NOT SOLD AFTER A SPECIFIC DATE AND MARK IT INACTIVE. PROBLEM DESCRIPTION: We would wish to inactive items that have not sold after a certain date. Is this possible? If so, any help would be appreciated. SOLUTION: ...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET WEB APPLICATION SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net.zip] to download Sample Code. ...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING C#.NET SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample.zip] to download Sample Code. Please refer below steps...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP SAMPLE APPLICATION: Please click here [http://support.flexquarters.com/esupport/newimages/INVPHP/QODBC-Invoice-Insert-Sample-php.zip] to download Sample Code. Please refer below st...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP BUT NOT WINDOWS 2000. PROBLEM DESCRIPTION: We have four machines using the ODBC driver with QuickBooks and Access 2003 that work perfectly fine. The odd machine is a slightly higher version of A...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING THE NON-EXISTING COLUMN NAME IN THE LEFT OUTER JOIN QUERY NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Kn...
TROUBLESHOOTING - REFUNDING CREDIT CARDS - THERE WAS AN ERROR WHEN PARSING THE PROVIDED XML FILE. PROBLEM DESCRIPTION: Hello, I am trying to refund CC payments in QuickBooks. I can create the credit memo. However, when attempting to add the refund us...
TROUBLESHOOTING - ERROR: 1000 - THERE HAS BEEN AN INTERNAL ERROR WHEN PROCESSING THE REQUEST PROBLEM DESCRIPTION: I get a very strange error... I have a development system and a dummy QB file (copy of the company file) that runs fine. However, when I m...
TROUBLESHOOTING - DOES QODBC SUPPORT "LIKE 'I%'"? PROBLEM DESCRIPTION: How should the following SQL query be written to work with QODBC, using the "like" filter to restrict records? SELECT Sales.RefNumber, Sales.BillAddressAddr1, Sales.Type, Sales.Tx...
TROUBLESHOOTING - CHECK THE ISTOBEPRINTED UPDATE QUERY PROBLEM DESCRIPTION: I'm having a problem running this SQL statement in QODBC TEST TOOL. The application returns an error message: [QODBC] Not supported. UPDATE Check SET IsToBePrinted = 1 WHERE ...
TROUBLESHOOTING - WHERE IS RETAINED EARNINGS DATA FOUND? PROBLEM DESCRIPTION: I cannot find a table with the retained earnings listed in it. Furthermore, I find no transactions for this account, yet QB reports two closing entries. In the account tabl...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO ALLOWANCE, BENEFITS, FEDERAL INCOME, ETC PROBLEM DESCRIPTION: How can we update the Insert PayrollItemNonWage field as Auto Allowance, Benefits, Federal Income, etc.? Suppose we add,...
TROUBLESHOOTING - EASIEST WAY TO MAKE A REPORT SHOWING THE AVERAGE TIME BETWEEN RECEIPT AND INVOICE OF THE ITEM PROBLEM DESCRIPTION: I want to make a report to show me which items are selling quickly and slowly. I figure I need to look at the length of...
TROUBLESHOOTING - CREATING PO USING ALPHA FIVE BASIC SCRIPTING IS NOT WORKING CORRECTLY PROBLEM DESCRIPTION: I am using Alpha 5 version 10.5 basic scripting to export our data to QB Enterprise 2016. I have successfully exported our customer and inven...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM & PRICELEVELFIXEDPERCENTAGE USING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM THE BILLTOPAY TABLE USING QODBC PROBLEM DESCRIPTION: In the BillToPay Table - How can we select invoices for payment using QODBC? We would like to have the Checkmark Selected for the resp...