Skip to Content
0
Former Member
Dec 08, 2006 at 12:10 PM

Net Due Date for FI documents

2359 Views

Hi All,

I am presently working on a requirement where in the user wants to modify the net due date of FI documents open items.

To achieve this I tried modifying the

Baseline date = ( NEW net due date - Cash discount days 1 )

But for some of the document i am not getting correct results.

Instead of changing the Due date, the Cash discount days 1 field gets changed.

Example:

Existing Due date is 10-Dec-2007

Baseline Date is 13-Nov-2006

Days1 is 27

To modify the Net due to 12-Dec-2007

I am changing the Baseline Date to 15-Nov-2006

But then it modifies Cash discount days 1 to 25 keeping the net due date as

10-Dec-2007

I think one needs to take payments terms also into picture.

Could anyone suggest some pointer to solve this problem.