Net Due Date for FI documents

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi

U should check the Terms of payment (BSEG-ZTERM), becasue the due data is calculate in according to them.

Max

[Former Member]

Hi Max,

But then how do we take that into picture. I am not sure how to calculate the Due Date based on Baseline date and Payment Terms.

Actually here I want to put the reverse logic where in i can calculate the BASELINE DATE based on Payment terms, New Due Date and Discount Days1 .

Rgds

Kaushal

[Former Member]

Hi

Try to see how the Payment terms is setted in customizing:

trx Spro:

Financial Accounting->Accounts Receivable and Accounts Payable->Business Transactions->Incoming Invoice/credit Memos->Maintain Terms of Payment

Perhaps the term used is setted to place the due date on 10 of next year, so the due date can be only: 10/12/2007.

and if you change the baseline the system'll change Cash discount days 1 to obtain 10/12/2007 again.

U need to change Payment terms too.

Max

[Former Member]

to add on you can just check programatically the net due date with DETERMINE_DUE_DATE but if your input date from file does not match the output from this FM then you will not be able to change the date as calculations are based from config setting which gets added to table t052.