SAP Business ByDesign bank statement with return and unification

[MariaIsabelPaz]

Hello everyone,

I have a question about how to resolve a case and I wanted to know if anyone could help me.

I explain, I have three ids of outgoing payments with the following amounts:
- ID 5 - $500.00
- ID 6 - $250.00
- ID 7 - $250.00
When I receive my bank statement, it turns out that the bank accumulated the three IDs into a single outgoing amount, so I only have one outgoing transaction of $1,000.00. 
In addition to that, one of the payments was returned to me by the bank and I found out when I viewed my bank statement. 
So on my bank statement I have the following transactions:
- Outgoing - -$1.000,00
- Incoming - $250,00
When i do the payment allocation i have no idea how to separate the amount of the $250,00 that the bank returned, to mark it as a refund and then assign it to the $250,00 incoming.

I may have an idea of how to solve this but first I would like to know what it's your opinion

[frank_jahnigen · Accepted solution]

Hello Maria Isabel,

Usually the Bank Transfer over -1,000.00 USD - containing all 3 payments - would have been confirmed first in a payment allocation.

A following item would contain an incoming bank transfer over 250.00 USD representing the return.
If not already shown - the the Payment Method should be altered to 'Incoming Return of an Outgoing Payment' in the allocation.

Under 'Payment Confirmations/Returns' the candidate payment would be found under query 'All Payments Confirmed by Bank (time)'.
In case the standard query 'All payments not confirmed' is applied, such a returned payment would not appear as a) it is confirmed and b) the payment direction naturally is Incoming.

Hope this helps,

Frank

[MariaIsabelPaz · Accepted solution]

Hello Frank, Thanks it was a great help! And it worked perfect