[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 TableProblem 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. | |
|