|
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
|
|
| Access and Quickbooks Transaction Tables Not Updating |
| Author |
Message |
|
|
| Posted : 2009-02-18 09:25:49 |
Using Access 2003
QB Pro 2006
Installed QB USA 2009 Read/Write
Error that i'm receiving when I try to update the transaction field "RefNumber"- "The record has been changed by another user since you started editing it"
I followed all steps and have retrieved all tables into Access. In addition I went to http://www.qodbc.com/qodbcaccess.htm and downloaded the video and followed the steps to update employees. When I did these steps everything worked great and the information did update to Quickbooks.
Now when I create a form for transactions and try to update the "RefNumber" field I get "The record has been changed by another user since you started editing it". It does not allow me to select the 'save record' button. In addition, I followed the steps on this forum to change my Access settings in options>advance tab> "edited records.
I've run out of options and the only thing I can think is the "RefNumber" field can not be edited . All I'm trying to do is match up downloaded credit card transactions to invoices by going back in and putting a PO number into the transaction record for each credit card charge.
Any help would be great.
Thanks,
Mike |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2009-02-18 10:25:41 |
|
|
|
|
|
| Posted : 2009-02-19 07:08:01 |
Tom,
Thanks for your quick reply last night.
I followed all steps below and realized that the Transaction table can not be changed at all. This was causing the multi user issue. I looked though the other tables and can't seem to locate the table that will allow the 'RefNumber" or mybe even the "P.O. #" field to be updated for a credit card charge.
When I'm in QB I'm able to run a Transaction Detail By Account report and I can display the RefNumber or P.O # (which are blank now for all my downloaded credit card transaction).
All I'm trying to do is update each downloaded credit card transaction that comes into QB with a PO# number. This will allow me to run a reports on credit card charges that do or don't have a PO# assigned to the transaction so I can tell if i'm being invoiced correctly. I really don't care what field I use, I just need a field that can be assigned to the line item of the credit card charge and can be displayed in my Transaction Detail By Account report in QB.
Thanks for any additional help you can give me.
Mike
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2009-02-19 10:23:36 |
| Sorry, but no columns in BillPaymentCreditCard, BillPaymentCreditCardLine or BillLinkedTxn are updateable. |
|
|
|
|