|
September, 2005
Issue 5
Contents
The centralised Web based HelpDesk support
ticket system from USA has now been fully integrated into the
Asia Pacific home of QODBC at:
http://www.QODBC.com.au.
 The Customer Helpdesk system has
a FAQ (Frequently Asked Questions) knowledge base section that can
now be accessed using the "Search for Answers" keyword
search function from the top left of all our web pages, often finding a list of answers
for you immediately.
The FAQ Knowledge Base is growing on a daily basis, so if you
can’t find what you’re looking for within your "Search for
Answers" keyword search, submit a Support Ticket. Your
question or technical problem will receive a same day reply even
if you are just evaluating our products or a fully registered
user. We now have 6 technical people monitoring this system
worldwide in order
to provide you with either resource direction or the answers to your
questions.
Click
here to go to our
QODBC HelpDesk System
and submit a Support Ticket.
Back
to Top
From the Asia Pacific Support Desk
Data Access
Worldwide publishes numerous Technical Knowledge Base
articles that provide developers and users with key
information about techniques, fixes and strategies related
to building and deploying QODBC based applications.
Latest Technical Knowledge Base
Articles
Below are the latest articles added to the FAQ Knowledge Base by
the QODBC Team. Click on the questions of interest to you to
see the full details: |
I have installed the latest version of QODBC. Now whenever I go into Crystal 9 and try to create reports with more than one table, Crystal errors out every time?
If you have Crystal
Reports (CR) 9 and when refreshing an existing report with
linked tables, or when creating a new report and linking the
tables, this error message "Crw32.exe has encountered a
problem and needs to close. We are sorry for the
inconvenience" appears, it means the file SACommonControls.dll
is not registered properly. |
Whenever I try to do updates I get the error: [QODBC] Expected lexical element not found:=
There is an open issue on
updates where you cannot use the tablename.columnname syntax
on the set statements, only column name. |
Does QODBC support the update of Custom Fields?
Yes with QuickBooks 2005,
you can update most of the custom fields. The Other, Other1,
and Other2 are not updateable and some of the CustomFields on
Line items. You can use the SP_COLUMNS tablename stored
procedure command in VBDemo to get the EXACT table schema
rules for the QuickBooks Company file you have open. |
Is there anyway to write or add a InvoiceLine Item into an existing Invoice?
Yes, you have to supply
the TxnID of the existing Invoice as the first field in the
Field list and it should work. For Example: INSERT INTO
InvoiceLine (TxnID, InvoiceLineDesc) VALUES
('2B55-1071523067', 'Test Added New Line to Invoice') |
I do not want to install QuickBooks on every machine that needs access. How do I set this up with the QODBC driver?
QODBC Version 5 has the
ability to talk to a copy of QuickBooks running anywhere in
the world over the Internet, or over your local area network.
This feature is built-in and requires no additional charge.
You don't need QuickBooks 2005 for this to work, you just need
to download and install our current QODBC v5 driver release. |
I am trying to do a mail merge between QuickBooks and a letter I have in Microsoft Word using QODBC. I have Microsoft Office 2003 and I don’t seem to be able to connect to the "QuickBooks Data" database. Could someone please send me a step by step procedure to accomplish this? I have no problems connecting to Excel but Word is a big problem!
Step 1 - Start Your Mail
Merge - Start Microsoft Word and open the letter you wish to
mail merge QuickBooks information into. From the Tools
pulldown within the "Letters and Mailings" option, click on
"Show Mail Merge Toolbar" to add the toolbar option to Word.
Once that's done, click on "Mail Merge" to start the merge
wizard. |
How do I change the price of a line in an existing Invoice?
You can use the following
update statement to change the price of a invoice line:
update InvoiceLine set InvoiceLineRate=200 where
InvoiceLine.Txnid='C38-1080104832' and
InvoiceLine.InvoiceLineSeqNo=1 |
I am getting the error: "Could not determine the version of the QuickBooks company data file, or the data file has been modified and requires a newer version of QuickBooks".
There are usually three
main reasons for this error. |
Is the "note" field in the address details for the customer "bill to" and "ship to" addresses accessible through the qbXML SDK and QODBC?
No, that is not a field
exposed from the Intuit qbXML SDK. |
How do I create a Sales Order using QODBC?
This example creates one
Sales Order with 2 order lines. Note how the FQSaveToCache
field is set to True except on the last line. |
How do I get a return value from an insert command which returns the new ID of the record I just inserted with SQL?
You simply execute the
QODBC LastInsertID stored procedure: SP_LASTINSERTID
tablename |
I would really like to be able to write Cheques from Access to QuickBooks - to eliminate a lot of repetitive work. How are cheques written?
This FAQ is Checks 101!
You can only insert to CheckItemLine or CheckExpenseLine. The
Check table is a header table and cannot be inserted into. |
How do I do multiple filters for the same report parameter when using sp_reports?
Multiple filters can be used for
the same report parameter by listing the filters separated
with a "," (comma). |
I'm trying to link a general ledger report in Excel. I've created the sp_report SQL query in Microsoft Query just fine, but the data that it returns contains subtotals and blank lines. I know that QReportGrabber eliminates these lines but I can't figure out what parameters to use to do it using QODBC?
The trick is just add:
where RowType='DataRow' |
I'm attempting to map ship to
information to a shipping application, however the address
information is less than consistent with regards to which
fields contain certain information. How can I overcome this?
If you're asking how can
you control what information QuickBooks operators put where?,
the answer is that you can't! String Functions can however be
used in QODBC to obtain various results in your SQL statements
to build more meaningful "Ship To" address lines in your
application. |
I can't find my
"MONEY TRANSFERS BETWEEN ACCOUNTS" transactions anywhere?
This is a known issue
with the Intuit qbXML SDK. One would expect that they would
appear in the Journal Entry tables but they currently do not.
You can however extract your "MONEY TRANSFERS BETWEEN
ACCOUNTS" transactions using the TxnListByDate or
CustomTxnDetail stored procedure. |
How do I write Deposits using QODBC?
Deposit
inserts are done only to the DepositLine table. The Deposit
table is a header table and cannot be inserted into without
cached DepositLines transactions. |
When I add a new inventory item I
sometimes get an error that the Item already exists. I've
checked the ItemInventory table and it's not there. What's
going on?
Actually you need to check
the ITEM table first. The ITEM table is a combined list of
all Item tables in QuickBooks: ItemInventory,
ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly,
ItemService, ItemFixedAsset, and ItemGroup; with minimum
common fields. |
How do I use the QuickBooks
Reporting Engine with QODBC? I've heard something about
sp_report but I don't understand how to use them?
QODBC supports the printing
of all the QuickBooks Reports through the ODBC Interface,
see our interactive web pages on Data Schema REPORT
DETAILS for all the sp_reports (stored procedure reports)
that may be accessed, including information about the
columns and the parameters for each report. Stored
Procedure reports (sp_reports) can also be used by
Microsoft Excel to bring any number of QuickBooks reports
directly into a spreadsheet by using Microsoft Query. |
How can I see
QuickBooks data in Internet Explorer?
Running QODBC within
your browser, whether it's an internal Intranet or on the
World Wide Web, requires the Web Edition of QODBC. The
QODBC Web Edition includes DCOM servers required to allow
QODBC running as a system service to find the instance of
QuickBooks running on the server console. |
When I use Linked tables in MS
Access the ODBC link locks-up QuickBooks and Access and it
then complains about the link being lost. How do I fix
this?
As far as Linked
tables are concerned, most MS Access developers use the "LinkODBC"
sub procedure modules for their connections as they are
compiled and are far more stable. |
Why is the CustomField table always
empty?
The CustomField table
is a insert only table used to insert or update data in
Custom Fields directly. It's primary purpose is for
updating custom data on tables that cannot be modified
like Sales Receipt. |
Back
to Top
Website Product Links
 |
QODBC is an ODBC
driver for reading and writing QuickBooks 2005/06, 2004 & 2003
Pro, Premier, Accountant and Enterprise
accounting data files by using standard SQL
queries. The Basic edition is FREE! |
 |
QDashboard/QIntegrator
automates the transfer of data to and from QuickBooks with
very little user intervention, with no programming
required! QDashboard eliminates the need to re-enter data
manually, saving time and money and eliminating data
transfer errors caused by manual re-entry. |
 |
QTableGrabber
is an Excel Add-In that gives you access to
QuickBooks data tables with virtually no limitation on
transaction accessibility other than certain payroll
information that Intuit does not make available outside
its QuickBooks product line. |
 |
QReportGrabber allows
you to create a live data link between QuickBooks report
data and an Excel spreadsheet – all from within Excel.
This innovative Excel add-in installs new menus directly
in Excel, allowing you easy access to all available
QuickBooks reports you are familiar with. |
 |
Last Price & Cost Grabber
is a utility that displays a listing of both QuickBooks
vendor costs and customer selling prices for a particular
item – or range of items – in one central location.
There's no need to run multiple reports, take extra time
to select item filters, or re-arrange multiple windows to
see both what you pay for an item, and what price you
charge your customer. Each tab in Last Price & Cost
Grabber can be used independently or in conjunction with
each other. |
 |
QDataViewer is a
multi-purpose reporting and data formatting tool designed
specifically to use QuickBooks 2005/06, 2004 & 2003 Accounting
data. The expandable platform of QDataViewer allows the
customer to add an unlimited number of report variations
to the included "canned" templates based on a basic
knowledge of Crystal Reports 9. If they are not using
Crystal Reports, Data Access Worldwide can also custom
design reports based on customer needs. |
|
Try our
QuickBooks Tools & Utilities for 30 Days FREE! |
Do
you know someone who would benefit from receiving
QODBC News Asia Pacific?
If so, please forward this issue to them and ask them to subscribe
by visiting the link below. We genuinely appreciate your help
in spreading the good news about QODBC!
To subscribe to this newsletter, click
here. Send
comments to
CustomerService@DataAccess.com.au.
Data Access Worldwide is located at Shop 9, 246 Dorset Road,
Boronia VIC 3155, Australia. Tel: +61 3 9761 3644.
Back
to Top
|
