Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Write from Access 2007 Datasheet View |
Author |
Message |
Dale |
|
Group | : Members |
Posts | : 3 |
Joined | : 2008-07-02 |
|
Profile |
|
Posted : 2008-07-16 09:32:20 |
I can read all the tables in Access 2007 just fine, but would like to change the data that QB lets us change from the Datasheet View in Access. Is this possible. I have a Read/Write version of QODBC.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-07-16 11:42:57 |
Only List type tables (ie: Customer, Vendor, Employee, Account) can be changed using a MS Access Datasheet grid. No transaction type tables (ie Invoice, InvoiceLine, Bill, BillItemLine, BillExpenseLine) can be changed. You also need to modify the datasheet view and set all the read only (reserved for QuickBooks use only) columns to be not updatable.
See: Where are the schema rules for using QODBC? How do I use sp_columns? for more details. |
|
|
|
Dale |
|
Group | : Members |
Posts | : 3 |
Joined | : 2008-07-02 |
|
Profile |
|
Posted : 2008-07-20 09:44:16 |
I have converted a company from Peachtree to QuickBooks and would like to be able to include the Class designation in the QuickBooks entries electronically. I did an Update Query that worked fine for the BillExpenseLine and SalesReceipt tables but cannot do the same thing with the CheckExpenseLine, JournalEntryCreditLine, or JournalEntryDebitLine tables. (The other entries are few and can be done manually.) Could you please let me know how to do it? The documentation seems to indicate that the ClassRefFullName and ClassRefListID fields allow modifications.
To do the Update, I created a local table and pasted in the Classes from an Excel sheet (where I computed the Classes using a formula based on the Peachtree Accounts) and only updated the ClassRefFullName. It automatically input the ClassRefListID.
I got the following error on the CheckExpenseLine: OCBC—update on a linked table ‘CheckExpenseLine’ failed. [QODBC] Incorrectly built XML from Update Start. (#10045)
With the Journal Update Query, I got the following error: OCBC—update on a linked table ‘JournalEntryDebitLine’ failed. [QODBC] Error: 3170 – There was an error when modifying a General Journal transaction. QuickBooks error message: Transaction not in balance. (#10045)
Alternatively, is there a utility to simply input the classes in the entries in QuickBooks since this is probably a common problem when doing a Peachtree to QuickBooks conversion?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-07-20 23:09:39 |
|
|
|
|