Power BI Connector for QuickBooks

Build 25.0.9540

ClearTransaction

Marks specified transaction checks in QuickBooks with statuses such as Cleared, NotCleared, or Pending for reconciliation.

Stored Procedure-Specific Information

To execute this procedure, enter:
    EXEC ClearTransaction TxnID = '300-1234567890', ClearedStatus = 'Cleared'

In the example above, TxnID refers to a balance sheet transaction.

Input

Name Type Description
TxnID String The unique identifier of the transaction to be cleared. The TxnID must refer to a balance sheet transaction.
TxnLineID String The unique identifier of the specific line item within the transaction to be cleared.
ClearedStatus String The status indicating whether the transaction has been cleared.

使用できる値は次のとおりです。Cleared, NotCleared, Pending

Result Set Columns

Name Type Description
* String The output data varies depending on the QuickBooks XML (QBXML) request provided.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540