Assumption: Reader is aware of basic “Automatic Payment Process” concepts.

Most of us are familiar with online banking transactions. There would be thousands of bank transactions happening 24/7. Did you ever think, how does payment reaches a bank/payee, if it is done on a bank holiday or on a Sunday (Global holiday in most of the countries)? Usually banks refer to value date while making  a payment to payee instead of transaction date. In case of real time transfers, value date and transaction date are same. In case of payments with say check, value date may be in future as well. Aligning this kind of requirement to SAP, usually payments are handled in SAP through automatic payment program (F110) or manual payments (F111). To understand the complete process in a better manner, first we need to understand few terminology used in payment process.

Payment media: This is the means of communicating the payment related information to bank. This would have information like payee details, bank account, amount to be paid etc.

E.g.: Payment media can be sent to bank through payment IDOC, flat file, XML file etc.

Value date: This is the date on which bank has to dispatch the money to payee account. Please note that payment media is sent in advance to the date on which payment is to be made to payee. How many days before a payment media should be sent to bank is controlled through configuration.

Payment advice: This is the communication sent to payee/accounting clerk (In some cases where vendor doesn’t have e-mail address) stating with the details of the payments done (List of paid invoices, amount, payment currency etc.) and to which bank account payment is made. This helps the payee to stay updated about the payment progress.

Usually, F110/F111 is run on a weekday and payment media is generated immediately and sent to bank. But, bank will start the payment process on the value date mentioned in the payment media.

Value date configuration and calculation logic:

Value date can be calculated in two different ways.

  1. Without bank calendar
  2. With bank calendar

Value date calculation without bank calendar:

Go to below path in FBZP.

Untitled.png

Enter required company code and proceed. In the next screen, you can assign the number of days to be added to value date.

By default, value date is same as posting date entered in the payment run. Number of days can be assigned at payment method, House bank, account ID, Amount and currency level.

We can assign different number of days for different amount limit for the same account , currency and payment method

E.G: All checks (Check payment method) up to 100000 USD should be paid on 1 day after the payment run and 100001 USD onwards, should be paid 2 days after the payment run. This feature helps to manage the cash flow and funds in a better manner and won’t cause sudden plunge of bank account balance due to unexpected huge payments. Business will have enough

time to analyze the funds situation at any point in time.

Untitled.png

Value date calculation with bank calendar:

This has two steps.

Configuring value date rules:

Go to value date rules from FBZP as shown below. Enter the company code and proceed.

Untitled.png

Enter the house bank, account ID, Transaction name(Free field).

Untitled.png

Reference date for determining the value date: This can have below options.

1          Document date

2          Posting date

3          Due Date

Most of the cases, posting date is selected as value date base line date (Reference date).

Calendar 1: This is the factory calendar ID used for calculating the value date. Bank holidays defined in this calendar are considered while calculating value date.

+ or – sign indicates weather the number of days mentioned is to be added/subtracted.

E.G: If the value date reference is posting date, Payment run Posting date = 01.04.2014

Considering above screenshot,

If 1st April is a holiday as per calendar EC, then value date base line would be 02.04.2014.

If 1st April is a working day as per calendar EC, then value date base line would be 01.04.2014.

Deviation from reference date in days: Number of days mentioned here are added/subtracted based on the sign column to the value date base line date.

From above example, value date calculation happens as below

If 1st April is a holiday as per calendar EC, then value date base line would be 02.04.2014, value date = value date base line + 2 days = 04.04.2014

If 1st April is a working day as per calendar EC, then value date base line would be 01.04.2014, value date = value date base line + 2 days = 03.04.2014

Once transaction name with the value date calculation rule is configured, next step is to assign this transaction to payment method.

Go to below path in FBZP. Enter company code and continue.

Untitled.png

Enter the payment method, Transaction, House bank, account ID and the transaction name created above.Untitled.png

Don’t get confused with the transaction entered in second column with the one in sixth column. The one in second column is used for distinguishing different types of transactions for the same payment method. Below values are allowed here.

Space    Transaction not relevant

1           Bill/exch. for discount

2           Bill/exch. for collection

3           Check deposit at same bank

4           Check deposit in same region

5           Check deposit (general)

This allows to configure different value date rule for same payment method.

EG: If payment method A is used for check payments, check at same bank might need lesser time compared to check in different bank in same region.

Usually transaction in second column is maintained as blank. The one in sixth column is used for determining value date rules (Configured in previous step).

These steps completes the configuration of value date calculation. These rules would be used when payment media is generated and during value date calculation.

Note: Custom logic can be written in payment user exits if standard customization doesn’t meet the requirement.

Your valuable comments and addition of more information on this blog is most welcome 🙂


You can also check the connected blog on Bank/Factory calendar creation.


Bank/Factory calendar creation: Step by step process

Thanks,

V V

To report this post you need to login first.

46 Comments

You must be Logged on to comment or reply to a post.

  1. Pankaj K Agrawal

    Dear Mr. Vinodji,

    Great Document, really very much helpful.

    One thing got to be accepted in SAP, no matter, Million times we visit the screen, still when someone points out and show that do you know here is one more treasure on the screen.

    Really, you are a true treasure hunter sir,.

    Thanks for sharing your valuable knowledge and experience which helps so many consultants.

    Kindest Regards

    p

    (0) 
    1. Vinod Vemuru Post author

      Thanks Pankaj 🙂

      You are absolutely right. Even the most familiar screens might have hidden functionalities which we tend to overlook.

      (0) 
  2. Mehdi Zine

    Hi Vinod,

    My requirement is to handle value date depending on payment currency of the invoice and not the bank account currency.

    Have you an idea about this.

    I look in standard but I didn’t find.

    I look also of possible user exit if you have to process value date.

    Thanks in advance

    (0) 
    1. Vinod Vemuru Post author

      Hello,

      You can use the payment medium user exit to change the value date based on your logic.

      Post complete requirement in forum to get more responses 🙂

      Thanks,

      V V

      (0) 
        1. Vinod Vemuru Post author

          Hello Eric,

          Thanks a lot for the compliment 🙂 .

          However, asking for points is against forum rules. Any article/blog can be rated , liked and provide the feedback though comments as per reader’s discretion. This would further motivate the author to post more knowledge artifacts /enhance the skills in case of any better suggestions from readers. Some experienced readers do add more information through comments.

          If you feel this blog would of help to others, you can share the same from top right corner by clicking the link “Share”.

          Thanks,

          V V

          (0) 
  3. Ondrej Zatopek

    Hi Vinod,

    very interesting blog. I was looking exactly for these settings. I would like to add one information. In order to be able to set up value date using this customizing in FBZP you need to tick the box “Payment per due date” in the FBZP -> payment method in company code customizing.

    Regards,

    Ondrej

    (0) 
      1. Ondrej Zatopek

        So did I. But it really started to work for me only after I ticked the box. I did not test the grouping itself with this but I suppose that once you tick the box Single payment, there wont be any grouping.

        Regards,

        Ondrej

        (0) 
    1. Richard Yao

      Hi Ondrej,

      Wondering if tick the ‘Payment per due day’, the baseline date of the value date calculation will  be the due date no matter what was set in OBBA?

      (0) 
  4. Subhasish Dey

    Hi Vinod,

    One question that I want to ask here. Are both C1 and C2 creation and assignment mandatory for all payment methods?

    C1 = Country>Company Code specific Factory Calender which enables in calculating the Value date

    Can I not assign the same Calendar as C1 in C2 and then allow the system to identify the Alternative Rule based configuration to make payment if the Value Date = Public Holiday.

    Please correct me if I am going wrong here.

    Best REgards

    Subhasish

    (0) 
  5. Richard Yao

    Calendar 1 is to avoid the baseline date of value date not to drop into a holiday.

    Calendar 2 is to avoid the value date itself being calculated not to be a holiday.

    Is this true?

    (0) 

Leave a Reply