Due date falls on 80 days from base line date ........but end of that month

[Former Member]

Hi All

Can any one please guide me in creating a payment term

The Base Line Date would be 80 days from Posting date ........... But end of that month

Example

Posting date 01.01.2009 so the base line date would be on 21st March

01.01 ; 31.01 ; 31 Days

01.02 ; 28.02 ; 28 Days

01.03 ; 21.03 ; 21 Days 80 Days

But due date should fall on end of that month 31st of march

So irrespective of any day calculated as above in that month it will always take the baseline date as last day of the month

Its Picking up the posting day as Baseline date from Transaction VA01 -> Additional data tab -> ETD ( Festinated Time of Departure)

From this date it need to calculate the due date as above ( 80 day but last day of the month)

Please Guide

Many thanks in advance

Aadi

[Former Member · Accepted solution]

Hi Aditya,

You may have to create 2 payment terms using the day limit option to meet this requirement.

Follows the below steps -

T-code OBB8

Term 1

Payment terms = xxxx (as you wish)

Day limit = any number between 10-15 (you may fix an appropriate date as you think fit for your business)

Default for baseline date = Posting date

Payment terms/fixed date = 31

Payment terms/additional months = 2

Term 2

Payment terms = same name as above

Day limit = 31

Default for baseline date = Posting date

Payment terms/fixed date = 31

Payment terms/additional months = 3

Logic here is... for all invoices with posting date on or before 10th-15th of a month, 80th day will fall definitely on the 2nd month. Invoices with posting date after 15th, the 80th day will fall on the 3rd month.

You have to take a concious decision on the day limit number. Because 80 days will not exactly work for all the months.

Regards,

Mike

[Former Member · Accepted solution]

Hi Mike

How the calculation or day count would vary with change in Base line if I will change to .....

@ No Default

@ Document date

@ Posting date

@ Entry date

With My scenario Which one would be more accurate ?

Thanks in advance

Aadi

[Former Member · Accepted solution]

Hi,

You have said earlier that it should be 80 days from the posting date. If that is the case, you select POSTING DATE.

Else, if it should be invoice date, then select DOCUMENT DATE.

Regards,

Mike

[Former Member · Accepted solution]

Thanks MIke

A Quick Question !

How it need to be done if it is for 90 days with rest being same ( Same Condition of last day of month )

Best Regards

Aaditya