Data Migration of AP Open Items - open payment item on the opposite side of account

[piotr_krol]

Hi All,

I am performing the Migration of Accounting Transaction Data and notice that payments that are migrated as part of Open Items Receivable/Payable are always migrated as positive amounts on the respective credit/debit side, regardless if it was maintained as a positive or negative value in the migration template.

I would like to migrate a negative payment on Accounts Payable (a return payment) but it's look like it is not possible.

How to migrate return payments?

I found 2136459 - SAP note but when I try to post a new supplier charge/credit I can not use the migration clearing account for payables. I have to use the migration clearing account because the migration has been posted despite the fact that the migration clearing account does not balance to zero.

Best Regards

Piotr

[former_member131434]

Hi Piotr,

the general guidance is use the type of the actual business document that had been the basis of this business transaction. I am going to check with accounting colleagues what type would be the right one here.

Best regards
Michael

[former_member131434]

Hi Piotr,

The system uses the Document Type (column 9) to decide whether the amount (which is expected to be entered as positive amount) has to be posted to the debit or the credit side.

Best regards
Michael

[piotr_krol]

Hi Michael,

Thank you for your answer. I see but that doesn't solve my problem. I am trying to enter an open item with "payment" type that will have a negative value because this is a return payment from supplier.

I need a workaround. Maybe it is a good idea to use a new charge/credit but I don't know how to use the migration clearing account when I post a new credit.

Best Regards

Piotr