From the qodbc website I have read a lot about sp_rerports and have seen in http://www.qodbc.com/docs/html/qodbc/20/reports/sp_report_detail.asp example SQL i...
You are typing in this exactly: sp_report APAgingSummary show Label, Amount, Amount_2, Amount_3, Amount_4, Amount_5, Total parameters DateMacro = Today',...
Ingrid, Go to www.qodbc.com and click on the download link, run the installer that is downloaded, and begin talking to QuickBooks data immediately thru Access,...
... The free version has only 3 reports in it: * APAgingSummary * ARAgingSummary * CustomerBalanceSummary For more, check out our pro version 30 day evaluation...
Using QB2004 and QODBC 4.0 these reports are available: sp_report BalanceSheetBudgetOverview show Label, Amount, Amount_2, Amount_3, Amount_4, Amount_5,...
does anyone out there know what all is involved in inserting into the depositline table? I have an app that is inserting checks into the deposit line. I have...
Can you send your SQL InsertStatement(s), so I can try it. Also what version of QBs (Year and Country) and what version of QODBC are you using? You can't add...
I'm sorry if this comes across twice... sure: insert into DepositLine (TxnDate, DepositToAccountRefListID, Memo, DepositTotal, DepositLineEntityRefListID, ...
James, The exception breakpoint should not happen. I can duplicate it so I will forward it on to the development. The main problem is the field DepositTotal....
That helps me out! Thanks for your help Matt James ... will ... total ... you should ... The ... until you ... field, ... ache") ... ache") ... ache") ... ...
Can anyone tell me where the sales tax reference code or full name is stored? I am using the ItemInventory table to display specific records and the only tax...
Hi! I needed to do a report of: vendor - by chart of account - by class - by paid from account So far it's been pretty easy to get the billing data and do the...
Hi, We are looking for Sage/Quickbooks/Quicken experts and would need this person to work with our developers and SAs to generate the code necessary to export...
Our checking account is set up with sub-accounts that we use to pay bills. We would like to track the use of these sub-accounts as they represent specific...
There is no Sales Tax in Canada as in the US, which is why there is a tax code in its place for inventory, etc. Could you please forward a screen shot of your...
In Ontario there are two sales taxes - Goods and Services Tax (GST) and Provincial Sales Tax (PST). The tax code applied to purchases (GST) is recorded in the...
What is the process of using the sp_report statement to import or link a table in MS Access? I can do it is Excel by pressing escape when the Quickbooks...
On the View menu is SQL View. Press that then enter your SQL statement. You will need to select from the menu Query->SQL Specific->Pass Through, Also you will...
But isn't the QOBDC driver supposed to access ALL the list tables and isn't the Budget table one of these???? Bob ... Amount, ... Amount_8, ... 2003, ... ...
Bob, QODBC includes the ability to access all of the data available to us using the QuickBooks SDK interface, which has different abilities in each QuickBooks...
Hi gwang: Yes, a copy of our web version of QODBC is available for a free 30 day trial by download. First go to the web page: www.qodbc.com And download and...
Can anyone tell me where the sales tax reference code or full name is stored? I am using the ItemInventory table to display specific records and the only tax...
Thanks, Brad: Then, I think I have got the evaluation version, but I can not make the web application work. it always tell me that file access error, I don't...
I am having a problem inserting into the bill table insert into bill(vendorRefListID, txnDate, dueDate, amountDue, refNumber, memo)values('740000-967039136',...
James, Please read the web FAQ document, you must save the child records before saving to the header record on bills. brad ... Brad Waddell ** FLEXquarters.com...
I am a registered user of the OEM version of QODBC. I currently have version 3.0.0.046. Should I (can I?) upgrade to version 4? Is there a cost to do this? ...