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.

Did you find this article helpful?