cancel
Showing results for 
Search instead for 
Did you mean: 

calendar date & net due date (FI) PAYMENT TERMS - OBB8 Vendor Invoice

Former Member
0 Kudos

I read many posts on SDN forum about the topic.

Anyway, I didn't find a simple solution for that.

My aim is is to calculate a net due date based on working days.

So, If I've got a 30 days document days payment term ("Deafult for baseline date" = Document date ; Additional Months = '2'), a Vendor Invoice (document date = 12.05.2011), by standard net due date will be 12.06.2011.

FROM 12.05.2011 to 12.06.2011 =

32 CALENDAR DAYS

22 WORKDAYS (32 minus 10 holyday - 2 weekends)

WORKDAYS PAYMENT TERMS Within 30 workdays Due net

Vendor Invoice document date = 12.05.2011

plus 30 workdays = DUE DATE 22.06.2011 (and not 12.06.2011)

Can I obtain that with a standard functionality?

Edited by: Roberto Buono on Jul 1, 2011 2:29 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Sadly this is not available as standard. As per your need the Net due date should be worked out by using a factory calendar; but what this does is it delinks the direct correlation between the number of days in the payment terms with the difference between the due date and baseline date. I hope you are aware that Net Due date is not stored but is a variable calculated during run time in reports.

There are four things you can try:

1. The simplest to do is: As the number of weekends are fixed; and if the intention is to give a 30 working day term, then add on the number of weekends and make the payment term effectively for say 40 days. There will be marginal variations over what you want. Best part here is that config remains standard.

2. All the receivable reports will use a function module (usually the same one) to calculate the net due date; enhance the FM and make it consider a factory calendar for calculating due date.

3. Enhance the accounting interface, and in runtime; modify the days that are coming from the payment term; based on a factory calendar, and update the accounting document. This delinks the days mentioned in the payment term and the accounting document and may not be palatable.

4. Enhance the accounting interface, and in runtime; calculate the due date and update the baseline date with it and make the payment term as "Immediate" yielding the desired due date. Not very elegant. Alternatively add to the baseline date days equivalent to holidays and weekends and keep the days from payment terms constant and update the accounting document. Better...

All four options have somes pros and cons. I do not see any other means of acheiving what you want. Maybe you could restrict users to a custom receivables/due date/ageing report which delivers what you want and lock the standard reports.

Cheers..

Former Member
0 Kudos

HI Neeraj Kukreti,

Could you clarify the difference between option 3. and option 4.?

Point 4. is clear (also in the two sub - options).

Point 3?

Many thanks

Roberto Buono

Edited by: Roberto Buono on Jul 1, 2011 4:36 PM

Former Member
0 Kudos

Hi,

In point 3, you modify the number of days in the accounting document defaulted from payment term definition; field BSEG-ZBDIT.

In 4; you modify the baseline date (BSEG-ZFBDT) in both sub options.

Net Due Date = Baseline Date + Days

Cheers.

Former Member
0 Kudos

Do you mean ZBD1T Cash Discount Days 1?

Former Member
0 Kudos

Yes.

Former Member
0 Kudos

Ok

Many thanks.

I'll have to implement an enhancement on MIRO & FB60 to calculate the baseline date ad net due date (my payment terms are only based on it).

I found the FM BKK_ADD_WORKINGDAY: it works accordingly the Fatctor Caledar you put in it.

EG:

I_DATE : 24.12.YYYY

I_DAYS: 1

The result is 27.12.YYYY (if it's not a satyurday or a sunday).

Bye

Roberto Buono

Edited by: Roberto Buono on Jul 6, 2011 2:50 PM

Answers (0)