payment term
目录
Vinod Vemuru
Posted onSeptember 30, 2013 2 minute read
Fixed day payment terms – The magic behind due date determination!!!
FollowRSS feedLike
25 Likes 19,227 Views 43 Comments
Payment terms define the parameters to derive the due date for the payment of an invoice, cash discount terms and periods, installment terms, default payment block/method that can be set etc. Usually baseline date is defined and derived from payment terms which is in turn used as the base for calculation of due date for payment.
Fixed date payment terms are used when the due date for the payment is a fixed date.
E.G: Payment is due on 20th October of every year.
Usually this kind of payment terms are used in case of seasonal sales/purchases.
Many people might have a doubt, if the due date is a fixed day, why do we need payment terms at all?. Instead, can’t we enter the due date directly in invoice? Fixed day payment terms are used for better management of invoices/payments. We maintain the payment terms in master data of customer/vendor which is defaulted to invoice automatically. So, we don’t have to go through the pain of remembering each fixed date for every customer/vendor.
Definition of fixed day payment term is done with out any baseline date as shown below. Then, how does SAP derives due date?
There is no standard SAP logic which determines the due date for fixed day payment terms. It is left to customers to write their own logic through
BTE (Business transaction event) 1120.
Implicit enhancement can be done in the BTE function module OPEN_FI_PERFORM_00001120_P to write custom ABAP logic and update the field ZFBDT (Baseline date) of internal table t_bsegsub.
One of the flexible way is to maintain a TVARVC variable with the list of fixed day payment terms in the format YYYYMMDD where MMDD is already known.
Year can be replaced with current year/year from posting date through program logic.
In below screenshot, 15th January of every year is the fixed due date for the payment term 070. This TVARVC variable can be queried with the payment term as low value to identify the due date from high value. YYYY should be replaced with year from posting date/any other logic based on business requirement.
Above BTE is called for every FI document creation where due date determination is required (From sales, purchase etc). So, logic has to be restricted based on business requirement.
Your valuable comments/any other better approach if you know would be most welcome
Best regards,
Vinod Vemuru.
Former Member
Posted onSeptember 26, 2012 3 minute read
Controlling The Payment Due Date Calculation In SAP SD
FollowRSS feedLike
14 Likes 30,536 Views 11 Comments
Payment terms
In standard SAP system, billing documents are generated, against which customer makes payment to the business unit. However, on the basis of our relationship with our customer we may extend certain credit period to him.
For example, we may allow our customer to pay back to us within 30 days from the time of goods/service delivery to him. Alternately, we may allow him to pay back in monthly installment on a certain date of every month. We may also provide him a certain discount if he pays back to us within the stipulated time frame.
In SAP, this functionality can be controlled using payment terms. We will review that how we may control payment due date calculation using payment terms and what are the constraints in using the same.
Payment due date calculation
Payment due date is function of two different variables configured in SAP. First is baseline date and other is payment terms.
We may represent the relationship among these variables as below
Payment due date = Baseline Date + Payment terms
For example, if baseline date for a particular payment term is billing date (for example 28th May) of the document and payment term is 21 days, then payment due date will be calculated as 18th Jun ( 28th May+21 Days).
Baseline Date
There are four options available in transaction OBB8 (Customizing for payment terms) for configuring the baseline date:
Now let’s understand, what does each of this mean-
1) No default – There is no date is set as default; we need to enter the baseline date manually in the billing document.
2) Document date – This is the billing date in the invoice. For delivery related billing, it is copied from the actual goods issue date and for order related billing it flows from sales order billing date.
3) Posting date – It is the posting date of the accounting document. It may be different from the invoice entry date in the system.
For example, you received an invoice from 27.05.2012 but current system date is 02.06.2012 and accounting period for May is closed in FI, so we will post this invoice in June posting period as posting date as 02.06.2012. In this case the document date will be 27.05.2012 and posting date 02.06.2012.
4) Entry date- This date corresponds to the date when billing document is created in the system. There is a possibility that goods issue has been posted in the system but invoice is not created for a week. So when we create the invoice, its creation date will be the entry date and billing date will be flown from delivery document as actual goods issue date.
The flow of billing date information happened in SD-FI interface from invoice document to accounting document.
A very important note
From ECC version 4.6, SAP has revoked the functionality to use any date, as mentioned above, for baseline date. Now standard SAP considers billing date (document date) as the baseline date by default irrespective of the settings mentioned in the OBB8.
ECC V 4.6 onwards, the standard the billing date (VBRK-FKDAT) is set as baseline date
in FI. With note #180344 following coding has been introduced
[1]FORM CLEAR_TERMS_OF_PAYMENT (LV60BF0C)
…
form clear_terms_of_payment.
clear: xaccit-zterm,
xaccit-zbd1t,
xaccit-zbd1p,
xaccit-zbd2t,
xaccit-zbd2p,
xaccit-zbd3t.
endform. ” CLEAR_TERMS_OF_PAYMENT
It means that only the base line date is taken over from SD to FI and the payment terms will not be copied anymore.
Please refer to OSS note 180344 for more details on this change.
Information flow in SD-FI interface
When accounting document is posted for an invoice, baseline date and payment terms are passed on to FI from SD. The data in FI gets stored in table BSEG in the following fields:
BSEG-ZFBDT
BSEG-ZTERM
Payment due date can be calculated by calling any standard functional module such as:
J_1A_SD_CI_DUEDATE_CHECK
Importing parameters are
IV_VBELN: Billing document number
IV_ZTERM: Payment term
IV_RATNR: Sequential Number of Installment to be Paid (Applicable when payment terms is installment relevant)
It will return EV_NETDATE, which is net due date.
https://blogs.sap.com/2012/09/26/controlling-the-payment-due-date-calculation-in-sap-sd/
https://wiki.scn.sap.com/wiki/display/ERPFI/Terms+of+Payment+customizing
Terms of Payment customizing
Skip to end of metadata
Created by Joyce Ji on Mar 24, 2016
Go to start of metadata
Purpose
The purpose of this page is to share the information about “Terms of Payment”;
How to set the customizing;
How is baseline date determined;
How is net due date calculated, and the calculation logic.
Overview
Terms of Payment are conditions agreed between business partners for the payment of invoices. The conditions define the due date and the cash discount offered for payment of the invoice within a certain period.
Terms of payment enable the system to calculate a cash discount and invoice due date.
Creating Terms of Payment
Navigation: Transaction SPRO -> SAP Reference IMG -> Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Outgoing Invoices/Credit Memos -> Maintain Terms of Payment
Alternatively: Transaction code OBB8
Some terms of payment are predefined in the system, you can add new ones with “New Entries” button.
General data
Day limit is the calendar day to which the terms of payment are valid. Using the day limit, you can store single or multi-part terms of payment in a terms of payment key (terms of payment key JOY1 in this page).
The above terms of payment is valid until 15th of the month.
The above terms of payment is valid from 16th to the end of the month.
Basic data
Related Documents
SAP WIKI: Installment Payment Terms - Customizing
Related SAP Notes/KBAs
SAP Note 162885: - Behavior of terms of paymt when entering a doc
Other key words
Payment terms calculation; Baseline date calculation.
