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
|
|
Records not updating |
Author |
Message |
|
Posted : 2007-10-31 08:08:34 |
I have a simple Crystal Report that works perfectly but now and then doesn't update certain records. The reports show line items in a QB Sales Order and looks up in the Invoices table which items are invoiced and which aren't. The latest occurrance reports 8 line items. 6 line items eminating from the one invoice report perfectly. The other 2 coming from a different invoice show quantity of zero invoiced but the invoice shows both line items fully invoiced in QB. The misreporting is associated with this one specific invoice. I called FLEXquarters who said there may be something in the data related to that invoice that is not being passed by the QB API to the ODBC driver (that QB itself is not fussy about). Any thoughts?? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-31 08:23:03 |
Sounds like the optimized table for InvoiceLine needs to be rebuilt. Try running:
SELECT TxnID FROM InvoiceLine VERIFY WHERE TxnID = 'x'
or
sp_optimizefullsync InvoiceLine
to rebuild the optimized table. |
|
|
|
|
Posted : 2007-11-01 02:23:06 |
Tom: I am happy to delve into how to do a rebuild of the "optimized table". I assume you are talking of a table within the QODBC product. I have no idea where/how to access that. Can you point me in the right direction and tell me where to find a manual that talks about the product. Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-01 09:07:50 |
|
|
|
|