Hi, I am getting the following error trying to run an ASP page that connects to my QuickBooks data file. I have QuickBooks Pro 2003 (for Accountants) and I've...
843
wallyhaupt
Oct 2, 2004 12:14 am
Attempting to create a check transaction from an Access front end. All works fine until I attempt to manipulate the amount field, which is consistent with...
844
tvclarkalaska
Oct 2, 2004 12:14 am
For example: sp_report ProfitAndLossStandard show RowData, RowType, Label, Amount_Title, Amount, NumColumns parameters DateMacro = 'ThisQuarterToDate',...
845
roberthostetler2000
roberthostet...
Oct 2, 2004 12:14 am
Hello, when i use the following SQL statement I get the following error: [QODBC] Unexpected extra token: INNER <!-- start SQL --> SELECT...
846
rob10662000
Oct 2, 2004 12:15 am
I have been able to add invoiceLine records whick result in the creation of invoice records. Using the same method, I tried to add credit memo line items. No...
847
Pogi
pogi_sya
Oct 2, 2004 12:15 am
Which table holds the Bank Transfer Record in Quickbooks? Please help. Thanks...
848
thekindguru
Oct 2, 2004 12:15 am
We just purchased the upgrade. Worked through a couple of DCOM errors. But we are still getting the same error through through SQL Server/Query Analyzer: OLE...
849
jackassreviews
Oct 2, 2004 12:15 am
No, i'm in united states. can you please help. I've done everything i can think off right now and nothing is working. ... region....
850
Chuck Vigeant
txbtech
Oct 2, 2004 9:15 pm
Bank Transfers are not available in the Intuit SDK at this time. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
851
Chuck Vigeant
txbtech
Oct 2, 2004 9:16 pm
INNER JOIN is implicit, and should not be used in the statement. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
852
Chuck Vigeant
txbtech
Oct 2, 2004 9:18 pm
The check amount as you state is not insertable, because it is a calculated total of either checkexpenseline items or checkitemline items. Chuck Vigeant M.Ed....
853
Chuck Vigeant
txbtech
Oct 2, 2004 9:26 pm
Go to Program Files\Intuit\QB Pro 2003 (or wherever the main directory of the QB program is) and run reboot.bat That should solve your problem. Chuck Vigeant...
854
Chuck Vigeant
txbtech
Oct 2, 2004 10:13 pm
NumColumns refers to the total number of columns returned. Amount_count refers to the number of Amount_"x" columns returned to help you with this process. If...
855
Pogi Sya
pogi_sya
Oct 10, 2004 7:18 pm
Will the bank transfer be available soon? Chuck Vigeant <chuck@...> wrote:Bank Transfers are not available in the Intuit SDK at this...
856
cwalker1767
Oct 10, 2004 7:18 pm
I have the web version of QODBC installed on my server and have gone through the steps to create a linked server. I can use the three sample queries using SQL...
857
adamfleet
Oct 10, 2004 7:18 pm
Hi all, I am writing a VB application to insert an invoice into QuickBooks Premier 2004 using the "QODBC Pro Read/Write 2004 Asia Pacific Version 4.20.00.050"...
858
hngnten
Oct 10, 2004 7:19 pm
addendum note to my *.UDL question: Although the "Provider"; tab of the "Data link properties" dialog for My TEST.UDL has to be set to "Microsoft OLE DB Provder...
859
ffierling
Oct 10, 2004 7:19 pm
... So I'd replicate the QB database using Access, then query the database in Access? Sorry, I'm not a database whiz and aren't sure how to set this up....
860
ffierling
Oct 10, 2004 7:19 pm
Hello, Given a query like this: SELECT InvoiceLine.ShipDate, Sum(InvoiceLine.InvoiceLineQuantity) FROM InvoiceLine InvoiceLine WHERE...
861
hngnten
Oct 10, 2004 7:19 pm
I created a file TEST.txt. Chnaged the name to TEST.UDL. then, I attempted to set it up with the UDL "Data Link Properies" window that comes up when I double...
862
ptrcktn
Oct 10, 2004 7:19 pm
Dear Sir/Madam, I've been trying to insert or update an Invoice's CustomFieldOther field without success. Below are examples of my sql statements: (1) To...
863
Matt Froncek
matt_froncek
Oct 10, 2004 7:43 pm
The custom fields Other, Other1 and Other2 are not updatable through the SDK and therefore not updatable through QODBC. Matt Froncek QODBC Development Support ...
864
Chuck Vigeant
txbtech
Oct 11, 2004 4:15 am
That is not possible unless you create a little vb applet that calls the names into an array. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor ...
865
Chuck Vigeant
txbtech
Oct 11, 2004 4:19 am
I suggest that you take a step back and test it in vbdemo to make sure there is no QODBC syntax errors. Then take it back to your code to see if you have any...
866
Chuck Vigeant
txbtech
Oct 11, 2004 4:23 am
We have no timetable from Intuit. We have passed on the request previously. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director,...
867
Matt Froncek
matt_froncek
Oct 11, 2004 4:36 am
Yes, the step back approach is usually the best. In this case, you must insert an InvoiceLine record first. Every invoice must have at least one line. You can...
868
Matt Froncek
matt_froncek
Oct 12, 2004 4:23 pm
If you are doing a pass through query or using VBDemo32 or CPPDem32 then the inner join use the {oj } syntax as follows: SELECT ItemInventory.SalesDesc AS...
869
Matt Froncek
matt_froncek
Oct 12, 2004 4:24 pm
Can you send a snippet of code or SQL statement you are using? Matt Froncek QODBC Development Support QODBC Driver for QuickBooks - Unleash your data at...
870
esjr0969
Oct 15, 2004 2:18 am
I have already loaded QODBC Pro with my Quickbooks Premier. We are getting ready to upgrade to Quickbooks Enterprise. Is there anything I will need to do for...
871
roberthostetler2000
roberthostet...
Oct 15, 2004 2:19 am
That worked! Thanks Matt for the help. Robert ... then the ... QuantityOnSalesOrder, ... ItemInventoryAssemblyLine.ItemInventoryAssemblyLnI ...
