Vendor Invoices automatically to be blocked on creation and unblocked on due date

[former_member228896]

Hi All,

This is a little different scenario , please share your inputs.

Vendor Invoices created for Vendors on Jan 1st, 2016 and Due Date is Mar 31st, 2016

On the date of vendor invoice ( i.e Jan 1st) creation system should automatically make a payment block

On the Due date ( I.e Mar 31st,2016) system should automatically unblock payment block, so that it would include in payment run F110.

Please share your inputs on the solution for above scenario

Rds

Sanjai

[ajaycwa1981 · Accepted solution]

Hi Sanjai

1. Why do you want to do this? If you use APP (F110), it will naturally ensure that no invoices are paid before due date... If that was the reason, educate your client

2. If you still wanna do this, proceed as below

a. The Payment Term that you assign in the Vendor master can be used to Block the line item automatically.. There is a "Payment Block" field in every Payment Term

b. To Unblock - You will require a Z Program for FB02, which runs every night in background and clears the Payment Block.. For this, you will have to allow the Payment Block Field in FB02 - Document Change rules

But seriously, think about (1)

Ajay M

[Gustavo_Vazquez]

Hi Sanjai,

Your request is done with Next Payment Date in F110. ie; if due date is 20/04 and in F110 Net Payment  date is 19/04, the invoice will not be considered in payment run

Another option is to create 2 substituon rule where

1- BSEG-BSCHL = "31" and BSEG-FDTAG > SY-.DATUM  ; Block Payment

2- BSEG-BSCHL = "31" and BSEG-FDTAG <= SY-.DATUM  ; Release Payment

You will have to update documents via batch job or create a program to clear payment block. There is nothing automatic.

Kind Regards

[former_member228896]

Hi All 

Thanks for your inputs

Let me elaborate why we need this

Process Steps

a) When vendor invoice is created say  Jan 1st , 2016, an open invoice extract will be generated and sent to CITI Bank.

Note: Invoice Due date is Mar 31st,2016.

b) Based on invoice extract , CITI Bank will immediately make payment to Vendor

c) On Due date , Company will execute F110 and make payment to CITI Bank . ( Vendor Master - CITI Bank will be alternative payee)

Now as per Point a) I need to block the vendor invoice, because sometimes in F110 with next payment run date is given as  - Mar 31st,2016.

Regards,

Sanjai

[Gustavo_Vazquez]

HI Sanjai,

If you must to block the invoice, then you need a program or a substitution as i propoesed.

There is no automatic mehtod. SAP expect human interaction if the invoice is blocked.

Kind Regards

[ajaycwa1981]

Hi Sanjai

Follow the Steps I mentioned above

It should work

Ajay M

[former_member228896]

Thanks Ajay for your inputs .

I'm considering standard option1 ( Use F110 and give proper due date) , however if business still insists it may tilted towards payment block option 2

.

Rds

Sanjai

[Former Member]

Hi Sanjai

A simple bdc program can achieve this:

At the time of posting the invoice, block the vendor item with a payment block using a BTE or exit or BAPI, if the due date is not today.

Create a BDC program and execute it by end of every day, which will unblock if the due date is next day.

Regards