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
|
|
Multiple field changes to Estimate |
Author |
Message |
|
Posted : 2007-08-28 01:04:43 |
I'm using Access 2007 to update fields within Quickbooks Enterprise Mfg and Whsle Edition 7.0. QODBC will not allow multiple changes to an estimate without refreshing between changes. Can this problem be resolved through a simple command? I've reviewed the Estimate setup that allows multiple line items for a single estimate but need assistance in transfering this information into Acccess 7.0 commands in updating existing estimates. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-08-28 08:32:03 |
|
|
|
|
Posted : 2007-08-28 11:54:18 |
The estimates are already loaded into Quickbooks. All we are trying to do is update the EstimateLineRate with the EstimateLineQantity where the EstimateLineQuantity is greater than .08. We have approximatley 6,000 lines in the database with 1,000 estimates. Some estimates have as many as 20 line items. When attempting to update the EstimateLineRate, we are limited to one change per estimate before we have to refresh. |
|
|
|
|