Symptom
You have created a manual invoice request, and find the payment due date is not correct.
For example, the invoice date is 02.01.2024, payment term is "30 days from Invoice Date, End of month", you expect the payment due date should be the end of next month, 29.02.2024. But system gets the due date as 31.01.2024.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the customer invoicing - invoice documents view.
- Open the invoice request ABC. (ABC represents the ID of the invoice request)
- The invoice date is 02.01.2024, payment term is "30 days from Invoice Date, End of month" and due date is 31.01.2024.
You expect the payment due date should be 29.02.2024, as the invoice date 02.01.2024 +30 is bigger than the last date in Jan.
Cause
The payment "30 days from Invoice Date, End of month" contains the following parameters.
net price due: Number of Days After Invoice Date / Receipt Date (3) =30; Fixed Day of Month (3) =31; Additional Month (3) =0.
The count starts from the invoice date, so 30 days from 02.01.2024 is 31.01.2024, hence the due date is 31.01.2024.
As summary: for payment term "1028 - 30 days from Invoice Date, End of month":
If the invoice date is the first day of the month, the due date is always the last day of the current month. (except Feb).
If the invoice is the second day in odd moth (Jan, Mar, May, etc...), the 30 days from Invoice Date is 31st, so the due date is in current month.
Resolution
This is currently the designed behavior.
Keywords
Payment Term; "30 days from Invoice Date, End of month"; Due Date. , KBA , SRD-CRM-INV , Customer Invoicing , Problem