Hi, I Created a Report in Crystal Report 10, I add two commands in our Reorts. When I use records from Command_1 my Report working normaly then I use a record...
You need to let Crystal do the work for you. rather than creating the manual commands. you need to use the tables for your report, and use the filtering and...
Hi, I use two commands (Command_1 and Command_2) both commands are use same table of SQL. Command's Querry is: (1) Command_1 Querry is (SELECT SerialNo FROM...
We are using multi-currency database in QuickBooks Enterprise 2004 - Canadian Edition. We are printing GL Transaction Detail by Account report in QuickBooks,...
Does anyone know why this field would have IsPaid = False but in QuickBooks, this transaction shows as a fully paid bill? [Non-text portions of this message...
Hi All How to create customized Field in ItemService Table and QB and how how to insert data into these fields using INSERT QUERY If anybody knows this pls...
Raj, First you create the custom field in QuickBooks. Then in QODBC it will be the name you gave it in QuickBooks with CustomField in from of it. So if you ...
We are preparing to import Bills from our MS SQL 2000 database into Quickbooks via QODBC. We have observed that, when a bill is created within Quickbooks it...
All of the information in Bill is also in BillExpenseLine. If you go to www.qodbc.com <http://www.qodbc.com/> to their help desk, and search on "INSERT" you...
I am using the QODBC driver that comes with QB Enterprise. I'm trying to automate the process for an unattended operation. I have assigned the specific...
(1) Get everybody out of QB (2) Go into QB>Edit>Preferences>Integrated Applications. Remove any ODBC listings. (3) Go to your directory where the QB file is...
Hi Rod, I emailed you. First question I would have would be which version of the driver are you using? Were you logged in as Admin when you set up unattended...
Chuck, Your suggestion worked for one company. For another I had to do what they suggested on the QODBC site (moving all related files except for the QBW)....
Probably the .lgb file. The .ND file is a configuration file, that usually doesn't need to be removed, but just remember to rename them to .old I never like...
Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an error when m odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when the item...
You will have to provide a loop to check for which Price "field" is applicable to that item. If an item is performed or bought from a subcontractor it changes...
A client of mine purchased a QODBC license for V. 6 Read/Write in August of 2006. They never installed and the secretary never notified me until today that...
Are they running QB 2007? I ran into this problem. Basically QODBC 6 will work with all versions of QB up to 2006. QODBC 7 will work with versions up to 2007. ...
This doesn't work: SELECT * FROM Item WHERE Type != 'ItemService' This does work: SELECT * FROM Item WHERE Type = 'ItemService' Am I building this query wrong?...
Try: SELECT * FROM Item WHERE Type <> 'ItemService' Matt Froncek QODBC Development Support / FLEXquarters.com LLC Consultant QODBC Driver for QuickBooks -...
Not sure what you're using to run the query, but in Access you have to say: SELECT * FROM Item WHERE Type<>'ItemService'; ... From: Matt Babineau To:...
Yup, how soon we forget! Glad it helped.. take care, robynz ... From: Matt Babineau To: qodbc@yahoogroups.com Sent: Friday, January 12, 2007 06:50 PM Subject:...
Hi, I have to Udpate all the accounts number of Chart of Accounts. Even do I'm Using QODBC Read/Write I can not update any account and I do not know why, I...
... So far I had to create a small routine to open and close windows as well as adding the charaters require for the account format update. It does work but it...
What version of QuickBooks are you using? QODBC uses the Intuit SDK and Account information was not updatable until QuickBooks 2007. Matt Froncek QODBC...
That answer my question. We are using Pro Version 2006 Thank you! ... From: Matt Froncek <matt@...> To: qodbc@yahoogroups.com Sent: Sunday, January 14,...
I have a VB.NET application that "select * from <table> " succesfully from all the QBOE tables EXCEPT (Invoice, InvoiceLine, InvoiceLinkedTxn). I am using the...
Hi Fellow Programmer, I did used QODBC for one of my projects and it did fulfill all of my client needs. But it we were lucky cause we were working all around...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
