Value Date calculation during Payment Run( F110 )

Prerequisite: Basic understanding of Automatic Payment Run

First let’s try to understand the term “Value date”. What is the Value Date?

Value Date is the date on which bank has to dispatch the money to payee account. This is different from the transaction date. It is the date when the cash or bank balance account affects.

Confused? it’s simple!

Have you wondered, if we make a payment on some holiday, when the payment will reach to the recipient? The answer to this is, the next working day. At least this is how the banking system works in normal circumstances.

Answering to the question, the transaction date is the date on which we make payment and the value date is the date on which the amount goes out of our bank account.

Such requirement or scenario can be addressed in SAP with the help of config. Next, we will check this.

Value Date configuration in SAP, TCode FBZP

In SAP, value date can be calculated in two different ways:

1. Without Bank Calendar
2. With Bank Calendar

By default Value date is same as posting date. So, we are not considering it under calculation logic.

Bank Calendar are used to record the holidays. During the payment run system refers these calendar to check if the date in picture is a holiday or not.

In-order for the complete functionality to work properly, the Bank Calendar should be updated.

1. Value date calculation without bank calendar

Tcode: FBZP, Next follow the below screenshot

Next, enter the company code in the pop-up screen

Next, you will land on following page, where you have to enter the logic/condition for the value date determination

In this screen, we can maintain condition based on Payment Method, House Bank, Account ID, Amount and Current. The number under “Day” column will be added to the Posting date. And the new date will become the value date if the condition is fulfilled.

2. VALUE DATE CALCULATION WITH BANK CALENDAR

Bank Calendar are used to record the holidays. During the payment run system refers these calendar to check if the date in picture is a holiday or not. In-order for the complete functionality to work properly, the Bank Calendar should be updated.

Tcode: FBZP. Calculation of Value date with Bank calendar has 2 steps:

1. Configuring value date rules and creating Transaction name
2. Assigning the transaction name to Payment method.

2.1 Configuring value date rules and creating Transaction name

Enter tcode FBZP, next select the “value date rule” option from the header menu, as shown in the below screenshot.

Next enter company code, and then you will land on the below screenshot.

In this screen, you will be creating the Transaction name, which will be used in the 2nd step to map the payment method to the logic defined here.

We have following field here:

• House Bank: Name of the House Bank under company code for which will be used for the value date logic
• Account ID: Name of the bank Account Id under the House Bank mentioned in the previous field
• Transaction Name: This is a free input field. Generally, we enter text same as payment method. Later this field is used to map the logic created here with payment method.
• Reference Date: By default value date is same as posting date. But under this logic, we have the option to set “Document Date/Posting Date/Due Date” as baseline date for the calculation of value date.
  Generally, posting date is taken as the baseline date for the calculation of value date.
• Calendar 1: This is the factory calendar ID used for calculating the value date. Factory holidays (and not Bank holidays, bank holidays are defined in C2 column) defined in this calendar are considered while calculating value date.
• + or – sign indicates weather the number of days mentioned in the next field is to be added/subtracted.
• 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.
• Calendar 2: This is the calendar where we define the Bank holidays. this calendar is different from Factory calendar.
• + or – sign indicates weather the number of days mentioned in the next field is to be added/subtracted.

Following condition can be created based on the two calendars.

Factory Calendar: EC	Bank Calendar: FA
Working	Working Day
Working Day	Holiday
Holiday	Working Day
Holiday	Holiday

Example, how SAP will calculate the value date:

If 1^st April is a factory holiday as per calendar EC, with the value date baseline is 02.04.2014.
then the calculated value date would be = value date base line + 2 days, which is 04.04.2014.
Here, we have considered 04.04.2014 is not a holiday as per the FA Calendar, which is our bank calendar.