Former Member
October 5, 2012 Less than a 1 minute read
Logic For Calculating Net Due Date with payment term and baseline date
007,559
Instead of using a Function Module for calculating the Net due date, the following logic could be used. For a few requirements where you don’t want to consider t052-zfael and t052-zmona while calculating the net due date this logic could be used. For example for payement term FB00 the calender days for baseline date(zfael) and additional months(zmona) are ‘0’ . But for FO10 , zfael = 10, zmona = 2, so when your baseline date is 05.10.2012 your net date would become 10.12.2012.
SELECT *INTO w_t052
FROM t052
UP TO 1 ROWS
WHERE zterm EQ bsad-zterm.
ENDSELECT.IF w_t052-ztag3 GT 0.
w_zfbdt = bsad-zfbdt + w_t052-ztag3.
ELSEIF w_t052-ztag2 GT 0.
w_zfbdt = bsad-zfbdt + w_t052-ztag2.
ELSEIF w_t052-ztag1 GT 0.
w_zfbdt = bsad-zfbdt + w_t052-ztag1.
ELSE.
MOVE bsad-zfbdt TO w_zfbdt.
ENDIFIF w_zfbdt GT sy-datum AND
bsad-shkzg EQ c_credit AND
t001-land1 NE ‘XX’.
MOVE sy-datum TO w_zfbdt.
ENDIFFollowLikeRSS Feed
1759365
1759365 - Credit memo with the Net due date incorrect
Symptom
Even with the payment term set in the credit memo document, the net due date is still incorrect. It is equal to the baseline date.
Environment
Financial Accounting (FI)
SAP ERP
SAP enhancement package for SAP ERP
SAP S/4HANA
SAP enhancement package for SAP ERP, version for SAP HANA
SAP S/4HANA Finance
Reproducing the Issue
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Post a credit memo directly in a ENJOY transaction, like FB65, FB75, FB60, with a payment term set and no invoice reference. The net due date is equal to the baseline date.
Cause
For the Credit Memo without Reference to an Invoice, the default in SAP system is Due Date for Net Payment (RFPOS-FAEDT) is identical to the Baseline Date for Payment (BSEG-ZFBDT).
The Period for Net Term or the Term of Payment is not taken into account.
Resolution
If you want to use the payment term days, you must enter the Indicator "V" in the Credit Memo field BSEG-REBZG "Invoice Ref", in addition to the specified Payment Method.
You can also modify this Field for the Credit Memos already posted. Manual filling of the Field can take place during the Entry of the Credit Memo, or in a Document Change Transaction:
Run transaction FB02 to call up the Credit Memos. Drill down to Customer Line Item. Here, you should be able to see the Field "Invoice ref.' (BSEG-REBZG). Place a 'V' in this Field. With this, the Credit Memo is due based on the Payment Terms.
Credit Memo with Invoice Reference have the same Terms of Payment and Baseline Date as the Invoice.
The check for indicator 'V' takes place in
Include LFDCBFI0
FORM invoice_referenceNow that the invoice reference is updated with indicator 'V', calculation of net due date takes place in FM DETERMINE_DUE_DATE.
See Also
1703735 - Error message F5220 raised in transactions FB65 or FB75
17410 - Posting credit memos; payments and dunning
Keywords
Credit memo, LFB1-GUZTE, FAEDT, KNB1-GUZTE, ZTERM, due date
Products
2873609 - Credit Memo Net Due Date
SAP Knowledge Base Article, Version: 1, Released On: 13.12.2019
ComponentFI-FIO-AR
PriorityNormal
CategoryProblem
Release StatusReleased to Customer
(0 people)
Quality Rating
Symptom
Even with the payment term set in the credit memo document, the Net Due Date is equal to the Baseline Date.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
S/4 HANA CLOUD
Reproducing the Issue
In App Create Incoming Invoice (App ID FB60)
Select Transaction Credit Memo
Enter details including Payment Terms
The Baseline Date and Due on Date are the same which is not expected.
Cause
As Per the F1 help on Field inv. Ref
Document No. of the Invoice to Which the Transaction Belongs
For line items which are related to another line item , this field contains the number of the partner document.
Use
Credit memos that refer to a particular invoice item
Subsequent invoices for an invoice item
Partial payments for an invoice item
Partial clearings of down payments
In the first two cases mentioned, the terms of payment terms of payment are copied from the cross-referenced invoice item into the item currently being processed. This ensures that items due on the same date are paid together by automatic payment.
A special rule applies to credit memos that contain a "V" in this field. The due date is determined in the same way as for an invoice. If the field is empty (containing neither a document number nor a "V") the due date is the baseline date for payment.
Resolution
For the credit memo without reference invoice the baseline date is considered as the due date of this credit memo for the payment processing.
Enter in Invoice Reference the terms of payment terms of payment are copied from the cross-referenced invoice item into the item currently being processed
If you want use the payment term days, you must enter the Indicator "V" in Inv. Ref, in addition to the specified Payment Term
Keywords
FB60, FB70, Create Outgoing Invoice, Create Incoming Invoice, Customer Credit Memo, Supplier Create Memo, Vendor, Due Date, Base Line Date, BSEG-ZFBDT, RFPOS-FAEDT, Invoice Reference, Manage Supplier Line Items, F0712, Manage Customer Line Items, F0711
2873609 - Credit Memo Net Due Date
Symptom
Even with the payment term set in the credit memo document, the Net Due Date is equal to the Baseline Date.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
S/4 HANA CLOUD
Reproducing the Issue
In App Create Incoming Invoice (App ID FB60)
Select Transaction Credit Memo
Enter details including Payment Terms
The Baseline Date and Due on Date are the same which is not expected.
Cause
As Per the F1 help on Field inv. Ref
Document No. of the Invoice to Which the Transaction Belongs
For line items which are related to another line item , this field contains the number of the partner document.
Use
Credit memos that refer to a particular invoice item
Subsequent invoices for an invoice item
Partial payments for an invoice item
Partial clearings of down payments
In the first two cases mentioned, the terms of payment terms of payment are copied from the cross-referenced invoice item into the item currently being processed. This ensures that items due on the same date are paid together by automatic payment.
A special rule applies to credit memos that contain a "V" in this field. The due date is determined in the same way as for an invoice. If the field is empty (containing neither a document number nor a "V") the due date is the baseline date for payment.
Resolution
For the credit memo without reference invoice the baseline date is considered as the due date of this credit memo for the payment processing.
Enter in Invoice Reference the terms of payment terms of payment are copied from the cross-referenced invoice item into the item currently being processed
If you want use the payment term days, you must enter the Indicator "V" in Inv. Ref, in addition to the specified Payment Term
Keywords