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...
[QODBC-Desktop] Troubleshooting - Creating PO using Alpha Five basic scripting not working correctly
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...
Help Desk Software by Kayako