Order payment in wrong bank account

Order payment in wrong bank account

Overview  

Imported orders from a specific customer has their payments going in to the wrong bank account.

Resolution/Solution 
There are three potential workarounds for this issue depending on the circumstances.

Workaround 1

Journal between the two bank accounts, adding a note as to why you are doing this, e.g. incorrect amount from channel. If this has happened to multiple sales orders, this might be the simplest method.

Workaround 2

If this is a one off event then the easiest way to do this is to:
  1. Go to the customer record and select the statement tab.
  2. Click Edit.
  3. Select the erroneous payment in the top right grid.
  4. Click Actions and select Cancel Allocations (Alloc From).
  5. Click Yes and Continue.
  6. Click Actions and select Delete Payment.
  7. If the payment has been reconciled you will need to:
    1. Select the payment in the left hand grid
    2. Click Actions and select Refund Payment or Credit and follow the prompts.
      1. The payment type should be set to Match Source.
  8. Click Actions and select New Payment.
  9. In the dialog box enter the values as required remembering to select the appropriate bank account.
  10. In the top right grid green select the newly entered payment.
  11. In the bottom grid select all of the invoices this is going to be allocated to.
  12. Click Action and select Allocate Payments / Credits to Invoice(s).
  13. Click Yes and Continue.
Note: this option will not work if the payment you are cancelling has been reconciled in the bank.

Workaround 3
If this a long term issue for a particular customer with regular repeated occurrences the following may be used as a workaround. it will force the system to use a specific bank account for all imported orders IF the customer belongs to a specific company class.
  1. Create a new company class for the affected customer(s) that mirrors the customer class to which they currently belong.
  2. Go to the customer record, click Edit and in the Company Class dropdown select the one you have just created.
  3. Click Save Company.
  4. Go to [System Data | System Payment Types].
  5. Click Edit followed by +New.
  6. Fill in the payment type and currency as required and select the company class you have just created in the from the dropdown menu.
  7. Select the bank account you wish this payment type to use for customers belonging to this company class.
  8. Enable Auto Bank.
  9. Click Save Screen.

    • Related Articles

    • Payment For Channel Going to Wrong Bank Account

      Overview The payments for my channels are going to wrong bank accounts Configuration The below steps inform you how to assign a specific bank account to a channel Steps Open the channel you want ot link to the bank account. Click Edit. Scroll to the ...

    • Imported order with no payment

      Overview Order imported from channel has no payment details attached and can not be processed in Sales Invoice Manager. It is worth checking your channel configuration to see if you are allowing unpaid orders to be imported. If you are only importing ...

    • Delete a Payment from a Sales Order

      Overview If you add a payment incorrectly and wish to delete it, this video describes the process. A step by step guide can be found below the video. Steps Ensure the Sales Order is in Edit mode. Go to the Payment tab. Green select the payment line ...

    • Set Up a New Bank Account

      Overview There must be at least one bank account set up in order for the system to work correctly and at least one bank account per currency, for example Sterling account and Euro account. This video shows you how to do this: A step by step guide can ...

    • Delete a Sales Order

      Overview Sometimes you may need to delete a sales order that has been imported or created in error, or cancelled. This must be done one sales order at a time. Usage Move the sales order to any of the following stages in [Sales Invoice Manager]: ...