Including a Debit item on a Vendor during Automatic Payment execution

SAP Financials Tip – Including a Debit item on a Vendor during Automatic Payment Program execution.

In this post we will demonstrate how the Automatic Payment Program can be configured to be able to pick a debit item in your payment proposal.

sap-tips

Debit items can be posted on a vendor by creating a down payment or posting a credit memo on the vendor. For the purpose of our demonstration we assume that the debit item is created by a down payment.

The down payment process starts with the creation of a down payment request. You create a down Payment request with transaction F-47, either directly in AP, or with link to the Purchase order.

Assume again that in our case, we are creating a down payment request directly from FI-AP without reference to a PO Created from MM.

To create a payment request follow the menu path:

Accounting — Financial Accounting — Accounts Payable — Document Entry — Down Payment — Request

Or use transaction F-47

down-payment-request-header-data

Select the G/L indicator “A”.

Press enter

down-payment-request-correct-vendor-item

Simulate and save

posted-in-company-code

If you display the Vendor line item with FBL1N, and select the “Noted Items” option, you will see the down payment request as below:

vendor-line-item-display

vendor-line-item-display-2

Now you can make the down payment using the automatic payment program F110.

Note: in addition to several configuration settings relating to special G/L Transactions (which will be discussed in another post), you should carry out the configuration step (discussed below) to allow the APP Program to pick the down payment request during the payment run. Otherwise you may get the error below:

Company codes 9999/9999 do not appear in proposal 17.09.2016 FA009; correct

Message no. FZ003

Alternatively, you can still execute the Down Payment manually through F-48, as below:

Accounting — Financial Accounting — Accounts Payable — Document Entry — Down Payment — Down Payment

post-vendor-down-payment-header-data-2

Click on Requests above

post-vendor-down-payment-choose-requests

Highlight the item and click on “create down payments”

post-vendor-down-payment-display-overview

posted-in-company-code-9999

If you display the Vendor line item with FBL1N, and select the “Special G/L Transactions” option, you will see the down payment as a debit item on the vendor.

debit-item-on-the-vendor

Assume now that you posted an invoice with FB60, FV60 etc. of say USD 100,000

If you now display the Vendor line item with FBL1N, and select “Normal items” and “Special G/L Transactions” options, the situation will be as below:

debit-and-a-credit-item-on-this-vendor

Note: that you have a Debit and a credit item on this Vendor.

However, without the settings below, if you execute the Automatic Payment Program (F110), the debit item of the down payment will not be picked up in the payment run. Meaning that only the invoice posted will be included in the payment proposal (see below), when what you actually wanted is to pay the net (invoice posted minus the down payment made).

edit-payment-proposal-open-items

In order to pick both the debit and the credit item maintain the settings below:

Financial Accounting (New) —- Accounts Receivable and Accounts Payable—- Business Transactions— Outgoing Payments— Automatic Outgoing Payments—-

Payment Method/Bank Selection for Payment Program— Set Up All Company Codes for Payment Transactions

Or use transaction FBZP

customizing-maintain-payment-program

Click on All Company Codes above and select your company code

double-click-on-your-company-code

Double click on your company code

change-view-company-codes-details

Include the special G/L transaction to be paid and save.

Special G/L indicator “F” means Down Payment Requests
Special G/L indicator “P” means Payment request
Special G/L indicator “A” means Down Payment

With the inclusion of the Special G/L indicator “A” in the above setting, you will be able to pick both the debit and the credit item during the payment run, as below

With the inclusion of the Special G/L indicator “F”, you should be able to pay the down payment request through F11O, instead of manually through F-48 (as done above).

edit-payment-proposal-open-items-2

You can now continue with your payment run (F110).

automatic-payment-transactions-status

Note below, that what is paid from your bank account is the net USD 85,000.

f110

Author: Ebrima Fatty Founder of SapGurus.com

If you would like to hear about SAP Financials work opportunities in Europe, or need to hire SAP experts please get in touch at eursap.eu

×
Show