cancel
Showing results for 
Search instead for 
Did you mean: 

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

piotr_krol
Explorer
0 Kudos
860

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


Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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

0 Kudos

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
Explorer
0 Kudos

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