Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 15, 2016 at 03:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2016 at 02:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2016 at 03:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Sanjai Babu Ajay Maheshwari SAP Trainer

      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