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
|
|
Cleared Status Field |
Author |
Message |
|
Posted : 2006-06-21 01:42:16 |
I cannot find a field denoting the cleared/uncleared status of a transaction. I found one post on this forum talking about the ClearedStatus table and inserting values into that. But that table does not seem to be used by QuickBooks since it is empty in our database and we have thousands of transactions. I am creating a Crystal report that shows uncleared transactions in the database. Surely there is a field somewhere that I am missing that shows a transaction's cleared status. Please help!!! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-21 08:32:09 |
The ClearedStatus is a "Insert Only" Table and does not contain any records as shown at: Select/update cleared status field (from account register) . My understanding is that the "Cleared" status only appears as a filter on check, bank and credit card reports only. Unfortunately, the Intuit qbXML SDK used by QODBC provides very limited access to Banking reconcilation functions. |
|
|
|
|
Posted : 2006-06-21 09:33:36 |
So are you saying that although QuickBooks clearly shows whether or not a transaction is cleared/uncleared/pending that it is not storing that information in the database? Where would it be storing that information? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-21 10:04:37 |
Try:
sp_report CheckDetail show TxnType, RefNumber, Date, Name, Account, OriginalAmount, ClearedStatus parameters DateMacro = 'ThisYear' Where ClearedStatus='NotCleared'
|
|
|
|
|