RSS Feed
Knowledgebase : QODBC > Syntax
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM 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 respecti...
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 - CREATING PO USING ALPHA FIVE BASIC SCRIPTING NOT WORKING CORRECTLY PROBLEM DESCRIPTION: I am using Alpha 5 version 10.5 xbasic scripting to export our data to QB Enterprise 2016. I have successfully exported our customer and invento...
TROUBLESHOOTING - EASIEST WAY TO MAKE REPORT SHOWING AVERAGE TIME BETWEEN RECEIPT AND INVOICE OF ITEM PROBLEM DESCRIPTION: I'd like to make a report to show me which items are selling quickly, and which are selling slowly. I figure the thing I need to ...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO ALLOWANCE, BENEFITS, FEDERAL INCOME ETC PROBLEM DESCRIPTION: How we can update Insert PayrollItemNonWage field as Auto Allowance, Benefits, Federal Income etc. If we add, Item Name -...
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 2 closing entries? In the account table,...
TROUBLESHOOTING - CHECK ISTOBEPRINTED UPDATE QUERY PROBLEM DESCRIPTION: I'm having the problem running this SQL statement in VB Demo. The application returns an error message: [QODBC] Not supported. UPDATE Check SET IsToBePrinted = 1 WHERE TxnID = 'B...
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.TxnDa...
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 mo...
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 am able to create the credit memo, however when attempting to add the refu...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING NONEXISTING COLUMN NAME IN LEFT OUTER JOIN QUERY PROBLEM DESCRIPTION: I am executing below query in VB Demo. But VB Demo is crashing at the time of execution. I have checked the same query in MS Access ...
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 ...
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] for download Sample Code. Please refer below s...
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] for download Sample Code. Please refer below step...
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] for download Sample Code. ...
TROUBLESHOOTING - HOW TO FIND ITEM NOT SOLD AFTER A CERTAIN DATE AND MARK IT AS INACTIVE. PROBLEM DESCRIPTION: We would wish to make items that have not sold after a certain date inactive. Is this possible? If so, any help would be appreciated. SOLUTI...
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 - 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 - HOW TO FIND ESTIMATE TO INVOICE CONVERSION TIME PROBLEM DESCRIPTION: I am using MS Excel access QuickBooks Data through QODBC. I have Estimate & some of the Estimates are converted to QuickBooks. I want to know how many Estimates are ...
TROUBLESHOOTING - DOES SP_REPORT SUPPORTS LIKE QUERY PROBLEM DESCRIPTION 1: Does sp_report support "Like" in the parameter? For example: sp_report CustomTxnDetail show Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAc...
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 - HOW CAN I ADD LINE TO AN EXISTING CHECK PROBLEM DESCRIPTION: Is it possible to add a line to a check that already exists? Here is an example form the QB Sample file. Below is a check for $500.00 Now I want to add additional items ...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA EXTENSION NAMED "".QUICKBOOKS ERROR MESSAGE : ATTRIBUTE WITH SPECIFIED NAME ALREADY EXISTS. PROBLEM DESCRIPTION: I am using QODBC for creating Invoice in QuickBooks. I am using Custom...
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 - 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 ...