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.

Solutions:

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.

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.