[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 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.
Not all transaction can be marked as cleared. In QuickBooks, you could not mark a transfer transaction as Cleared, because 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 invoice cleared, I am able to perform this transaction can be set cleared in QuickBooks, but 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.
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.