- SAP Managed Tags:
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
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 4th 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
2 Comments
