How to clear AP vs AR?

[Former Member]

I would like to clear the supplier invoice off against the customer invoice.

Is this possible?

If yes then, how?

[Former Member]

Yes it is possible.

There are 2 scenarios :

Scenario - 1

A. Receivable amount is same as that of payable amount. In this case, no payment will be made. You can do the below steps:

1. Go to Payables work center.
2. Select Supplier Accounts view.
3. Select the appropriate account and click on View.
4. Click on the button New Charge/Credit.
5. Create a new charge for the total amount and post it.
6. Select this new charge posting and the open items you want to clear.
7. Click on Clear manually.
8. If there is more than one item for clearing then you can also simply start manual clearing with only one item selected. On the following screen you also see all open items of that account and can filter e.g. by document ID to find the matching one.
9. Go to Receivables work center.
10. Select Customer Accounts view.
11. Select the appropriate account and click on View.
12. Click on the button New Charge/Credit.
13. Create a new credit for the total amount and post it.
14. Select this new credit posting and the open items you want to clear.
15. Click on Clear manually.
16. If there is more than one item for clearing then you can also simply start manual clearing with only one item selected. On the following screen you also see all open items of that account and can filter e.g. by document ID to find the matching one.

Please note the below points :

1. This approach will clear items in the Customer and Supplier sides of the account. Creation of New Charge Credit items (Other Payable/Receivable) items will lead to Accounting Entries.
2. The Document Description for these items can be maintained in the New Charge Credit screen, so that it is clear as to why these items are being created.
3. The balances in both Accounts will be consistent.
4. Use the same GL Account for both the charge credits.
5. The posting dates of the charge credits should be the same.

Please also be noted that, if your transaction currency is diferent from your company currency, this approah might lead to profit/loss from exchange rate difference.

B. Receivable amount is not same as that of Payable then do the below steps :

If payable amount is larger than receivable then you will initiate the payment. For example : if payable balance is for 100 USD and receivable balance is for 40 USD then an outgoing payment for 60 USD will be made which will clear your supplier and customer account. You need to do the below steps :

1. Go to Payables work center.
2. Select Supplier Account view.
3. Search for the respective account and select the row.
4. Click on view.
5. Go to Trade Payables tab and Invoice/Payments Sub-tab.
6. Select one item.
7. Click on Pay Manually by and select Other Payment Method.
8. Go to Open Items tab.
9. Click on Accounts and select the Add Account. Here add the customer account.
10. Enter the values in the field.

This will add the account on the screen , now you can select the customer invoices and the supplier invoices. When you click on Execute Payment, 40 USD is cleared, 60 USD is made as an outgoing payment to the supplier.

Scenario - 2

If Recievable is larger than Payable and the payment is foreign initiated then the clearing will be done for the existing payment. For example : if payable balance is for 40 USD and receivable balance is for 100 USD. You need to do the below steps :

1. First of all, create an incoming payment via bank statement with amount 60 to the customer account.
2. When clicking the Reqired link of the bank statement item, make sure this amount partially clear one invoice item, instead of having the payment paid on account.
3. Then go to Receivables work center.
4. Select Customer Account view.
5. Search for the respective account and select the row.
6. Click on view.
7. Go to Trade Receivables tab and Invoice/Payments Sub-tab.
8. Select the Clearing ID. Reset the clearing.
9. Click on Accounts and select the Add Account. Here add the supplier account and match the supplier invoices.
10. Select the button Clear.

This clears you supplier account and customer account with existing payment.

[marlene_katzschner]

Hi Myrthi

ByDesign does not support netting yet. We have in the ByDesign Ideas Place the idea (here you can check, if this would help you as well: https://ideas.sap.com/D18668, nevertheless the ideas forum is only one data source for backlog) and you add additional points or vote for this idea. Until there is a standard solution available in ByDesign you need to use the approach described by Harsh.

Best regards, Marlene