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
|
|
Table and Column for Cleared check |
Author |
Message |
|
Posted : 2007-03-13 08:47:20 |
Can you tell me what table and what field is used to indicate a cleared check.
The quickbooks page is the Bill Payments(Check) from the vendor center and the word CLEARED appears when a check is marked as cleared.
I a using Enterprise Solutions 7.0 and I would like to automate the clearing process by updateing the table using QODBC.
Thanks
Tom |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-13 10:39:22 |
Intuit have chosen to provide only very limited access to Banking reconcilation functions. But if you want to do it regardless of the warnings, then read on. Using the QuickBooks 2006 Sample Rock Castle Construction company file, the Checking register shows the following:
To locate the TxnID of the "BILLPMT" check I ran:
SELECT TxnID, AppliedToTxnSeqNo, TxnDate, PayeeEntityRefFullName, Amount FROM BillPaymentCheckLine where RefNumber='294'
The TxnID shown is 431F-1071527444. Using this TxnID, I can mark the Check as cleared by running the following using the INSERT only ClearedStatus table:
INSERT INTO ClearedStatus ("TxnID", "ClearedStatus") VALUES ('431F-1071527444','Cleared')
BTW: The valid values are: |Cleared|NotCleared|Pending|
and the check is now marked as "Cleared" in QuickBooks:
Note: Checks must be Printed or Emailed before they can be Cleared. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-07-31 21:08:24 |
To view uncleared Checks you can run:
sp_report CheckDetail show TxnType, RefNumber, Date, Name, Account, OriginalAmount, ClearedStatus parameters DateMacro = 'ThisYear' Where ClearedStatus='NotCleared'
|
|
|
|
|