Vendor Fixed Monthly Payment by Check

[Former Member]

Hi Experts,

Here is a scenario, we have posted vendor invoice for 100,000 and now we want to pay monthly fixed amount for certain period by check. How can this be accomplished, I tried recurring payments, it works but I cannot cut a check for the recurring document posted.

Another scenario paying monthly rent by check, how can this be accomplished. Meaning at month end I need to cut a check for certain amount and mail it to the vendor..

Sorry if its a very basic questions.

Thanks in advance

Best Regards,

Jen

[eduardo_hinojosa]

Hi

You can try to do it with enhancement in the interface to FI. Please, see Note 301077 - User exits for the interface to accounting. You can use the EXIT_SAPLV60B_008 adding lines creating each customer item by payment. See Note 611040 - Down payment invoice for Italy and you could see how it's possible to do it (although this note is for other requirement related with down payment. You'd need an ABAP resource.

I hope this helps you

Regards

Eduardo

[former_member309133]

Hello Jen

I agree with Ameet and Sekhar on installment payment term. When you do this the F110 run will pick the payment and process it.

[former_member309133]

Hello Jen

I agree with Ameet and Sekhar on installment payment term. When you do this the F110 run will pick the payment and process it.

[Former Member]

Hi,

For 1st Scenario

You can configure "Terms of Payment" (Installment Payment) along with "Terms of payment for Installment Payment" (Holdback / Retainage), hope it will fulfill your requirement.

For 2nd Scenario

You can use Recurring Document

Regards

Sekhar

[Former Member]

Hi Jen

You can have a payment terms for monthly payment and then based on the terms of payment, using F110 payment can be made or else use recurring entry and post the payment entry after that using manual check assign a check no. manually to the payment doc using T.code FCH5 and print the check using FBZ5.

Regards

Rajaram

[ameet_desai]

Hi,

You can accomplish this by the combination of Recurring Payments (Generate the invoice entry) and F110 (Payment entry). Create separate Run ID's for Scenario 1 & Scenario 2 mentioned above and run the Recurring Payments and F110 transactions every month end or you can schedule it as a job to be executed as a job every month. Hope this is helpful.

Thank You.

Regards,

[Former Member]

Ameet,

Thanks a lot for your reply. The problem in scenario 1 is the invoice is already posted for 100,000, now I need to make say a monthly fixed payment of say 10,000 with check. So i can't use both recurring as well f110 since its only a part of invoice payment.

In second scenario, its like paying a rent, u don't receive an invoice, but monthly you have a make a payment.

Thanks.

Best Regards,

Jen

[venkateswaran_k]

Hi Jen

As Ameet said,

You may ask your ABAP team to write a program and schedule it for the defined periods.

1.  Create a BDC for the above steps and record it.

2.  As the ABAP team to write a BDC program and pass the value as defined inside the program

3.  Schedule it in background and set the interval as once in one month until next x months...

Regards,

Venkat

[venkateswaran_k]

Hi Jen

I think, as I mentioned earlier you can make a bdc of a payment program and make that as a background scheduled for the specific periods.  ( example to be executed on specific day of every month) and number of times...

This may give you a solution nearer to your requirement

Regards,

Venkat

[ameet_desai]

Hi,

Ypu have to make new payment term as Intallment Payments and then every month you shoud be able to do achieve this.

In the 2nd scenario, You will have to book the expense:

Rent A/c Debit

To Vendor A/c

Only afther doing this you can make payment to the Vendor. You have to make one more entry but it will smoothen your work.

Thank You.

Regards,