Knowledgebase
[QODBC-Desktop] Troubleshooting: Could not Mark Transaction as Cleared in ClearedStatus Table
Posted by Wilson (QODBC Support) on 29 February 2012 08:44 AM

ClearedStatus Table problem

Troubleshooting: Could not Mark Transaction as Cleared in ClearedStatus Table

Problem Description 1:

Try to Mark a transfer-type transaction as cleared in the ClearedStatus table via the statement:

INSERT INTO ClearedStatus (TxnID, ClearedStatus) VALUES ('xxxxxxxxx,' 'Cleared')

But get the error below:

[QODBC] Error: 3000 - the given object ID "XXXXX-XXXXXXXXXX" in the field "txn id" is invalid.

Solutions:

Not all transactions can be marked as cleared. You cannot mark a transfer transaction as Cleared in QuickBooks because the transfer record is created. It is already considered cleared in QuickBooks. You could not mark a cleared transaction as "Cleared."

Problem Description 2:

Try to set the invoice cleared, I can perform this transaction can be set cleared in QuickBooks, but I get the error when using QODBC:

[QODBC] Error: 3170 - There was an error when modifying a ClearedStatus. QuickBooks error message: The cleared status can only be set if the line item account is of a balance sheet type.

Solutions:

Please verify if your transaction is using nominal accounts for your transactions. ClearedStatus can only be inserted with a transaction related to a balance sheet-type account. Balance sheet-type accounts include Current Assets, Fixed Assets, Long-term Liability, and other real accounts.

(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).