How payment terms control base line date, fix value date and updates in Accounting

[Anurag_Mehta]

In this blog post you will get to know about How payment terms control base line date, fix value date and updates in Accounting

Usually in sales process, billing is created the finally the revenue accounting documents is created, Payment terms are updated in document plays crucial role and controls the various updates, one of them is Base line date, it is observed that below are the common issues faced by many customers

Ø How to change the fix value date in Billing.

Ø Base line date to be updated as billing creation date.

Blog Applicability

SAP S/4HANA Cloud Release

2005

Target Audience

Business Users, Key Users, Consultants

Target Industry

Any

What is Base line date?

A baseline date for payment is the date for which the payment terms apply. It's the basis of the system to determine the cash discount taken (from vendor) or cash discount given (to customer).

What is Additional value and fix value date?

Suppose for the terms of payment is defined as 11 days and the Sales order is created on 01.07.2020 and on 11.07.2020 is the due date for payment

Additional value days if you give as 2 days then the system calculates 2 additional days for creation date

Example:

Order is created on 01.07.2020, 2 days are added, then from 03.07.2020 it calculates for 11 days and hence the due date for payment becomes 13.07.2020

That much additional days is given along with the no of days mentioned in payment terms

Fixed value date means that for a sales order created on 01.07.2020 then if you give the fixed value date as 04.07.2020 then from 4^th march the payment terms is calculated and accordingly 15.07.2020 becomes due date for payment

Note: If you give the fixed value date then there should not be any additional value days because it becomes meaningless

Business benefit

· Faster resolution of Billing related issue

· How system check/update the dates in billing

· Easy completion of sales process

Issue details

Ø How to change the fix value date

Fix value date : The date on which the terms of payment related to the sales document become effective.

Dependencies

If you enter a date in this field, you cannot enter a value in the additional value days field.

In Create Billing document app

How to change the Fix value date.

Solution

You can achieve the same by use of the data transfer cloud BAdI (SD_BIL_DATA_TRANSFER) to update the fixed value date in billing documents.

See an example about how to set the billing date in the following KBA:

2892513 - How to set billing date equal to billing creation date via copy control - SAP S/4HANA Cloud

2827738 - Custom Data Transfer for Billing Documents

Issue details

Ø Base line date to be updated as billing creation date.

Many countries have a requirement where in billing creation date is to be base line date and not the billing date.

Even though the SSCUI option is provided – 100073, it is not working as expected

Example:
Billing document 9xxxxxxxxx has been created today (30.06.2020)

And Billing date is 30.05.2020.

The Payment term is 001 Pay immediately w/o deduction.

Baseline date should be 30.06.2020. Payment is expected for today.

But system is considering bases line date as billing date only.

Solution

Configuring the baseline date for the entry date but it is using the billing date as the baseline date in the FI document.

To cater the same, knowledge base article "2892513 - How to set billing date equal to billing creation date via copy control".

The example is how to set the billing date, but in SAP Help you could see that you also have a field "FixedValueDate", which is used to set the baseline date.

For this specific requirement please implement the BAdI (SD_BIL_DATA_TRANSFER) for data transfer, only changing the FixedValueDate and leave the billing date as it is.

Related SAP Note / Links

2892513 - How to set billing date equal to billing creation date via copy control - SAP S/4HANA Cloud

2827738 - Custom Data Transfer for Billing Documents