SAP Knowledge Base Article - Public

3429428 - Payment Due Date is Incorrect in Sales Documents

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

  1. Go to the customer invoicing - invoice documents view.
  2. Open the invoice request ABC. (ABC represents the ID of the invoice request)
  3. 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

Product

SAP Business ByDesign 2311