How do I correct a Cash Management transaction created in Setup Assistant when the bank account is live?
Description
Cause
Resolution

Transactions that you enter through Setup Assistant do not post to General Ledger. You can correct Setup Assistant transactions in the Cash Management Edit Register task as follows:

Notes:

  • See article 20008 "How do I enter a deposit, withdrawal, adjustment, service charge, or other transaction to a bank account in Cash Management?" for more detailed information on how to enter a transaction in the Edit Register task.
  • If you want to correct a Setup Assistant transaction, but your bank account is not yet live, use article 27017 "How do I correct a Cash management transaction created in the Setup Assistant when the bank account is not yet live?" instead of the following solution.
  1. Enter an adjustment to reverse the Setup Assistant transaction.
    1. Use the same accounting date as the original Setup Assistant transaction.
    2. Enter the opposite amount as the Setup Assistant transaction. For example, if the transaction that you want to reverse is an addition amount, then enter a subtraction amount.
    3. Select the cash account for this bank account as both your credit and debit account. This creates an entry to General Ledger that nets to zero and does not affect any account balances.
  2. If you just want to reverse the original Setup Assistant transaction, you are finished and do not need to proceed further. Otherwise, enter an adjustment to re-enter the Setup Assistant transaction.
    1. Enter a new accounting date as appropriate.
    2. Enter the same amount as the original transaction or a new amount as appropriate.
    3. Select the cash account for this bank account as both your credit and debit account. This creates an entry to General Ledger that nets to zero and does not affect any account balances.
  3. The original transaction and the reversing transaction net to zero so reconcile them together as appropriate. The new transaction can be reconciled as usual. If the original transaction is already reconciled, you can reconcile the two new transactions manually. See article 22176 "How do I change the reconciled status of a transaction in Cash Management?" for more information on how to manually change the status of a transaction from open to reconciled.

Note: If your Setup Assistant transaction was originally entered with an incorrect future date, then this transaction and the reversing transaction you entered in step 1 will always appear at the bottom of the Edit Register window. After you reconcile both of these transactions, you can move them to history so that you no longer see them in the Edit Register window.

When you move these transactions to history, specify a condition that only moves these transactions. For example, if both transactions have a unique future date, add the following condition:

  1. In the Move Entries to History window (Tools, Move Entries, Register To History), click Conditions.
  2. In the Field section, select Accounting Date.
  3. In the Operator section, select Equal to.
  4. In the Value section, type the unique future accounting date used by both the original Setup Assistant transaction and the reversing entry you made (step 1 above).
  5. Click OK twice.
  6. Continue with the Move Entries process.

See article 17405 "How do I move transactions to history in Cash Management?" for more information on moving transactions to history.

DocLink: How do I move transactions to history in Cash Management?
DocLink: How do I enter a deposit, withdrawal, adjustment, service charge, or other transaction types to a bank account in Cash Management?
DocLink: How do I change the reconciliation status of a transaction in Cash Management?
DocLink: How do I correct a Cash Management transaction created in Setup Assistant when the bank account is not yet live?
Defect ID
Steps to duplicate
Related Articles