Hi All, As per QuickBooks table schema "BuildAssembly" and "BuildAssemblyComponentItemLine" tables used for Build Assembly. However I am not able to access...
Clifford, The BuildAssembly assembly table is only available in the US version of QuickBooks 2006 and higher. Matt Froncek QODBC Development Support /...
Hi Matt, Thanks for the information. Sincerely, Clifford ... version of ... <http://www.qodbc.com/> ... Behalf Of ... Assembly. ... QODBC ... related ... ...
whats the proper seguece for inserting journal entries? I have a debit entry and two credit enteries for one transactions. Do I need to enter a record into the...
When using the FQSaveToCache field everything is held in memory until the FQSavetoCache is sent equal to FALSE, so the order really does not matter. Just that...
Hello Group, Having a little problem getting a field to show up in a customer OPEN INVOICE report. The field I need printed or exported in the report is found...
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:...
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.
