Cash Discount Calculation on Balance due Days

[Former Member]

Hi friends.

Please tell how can i calulate the cash discount for following Example.

Vendor Invoice Book : Rs. 10000 Dt. 01.06.2010

Due Date : 30.0.2010, Cash Discount 2%

Now if we pay to Vendor on 20.06.2010

then

the requirement is to calculate the Cash Discount 2% on 10 Days.

that is Net Amount paid to vendor will be

Invoice Amount : Rs. 10000

Less : Rs. 10000 * 2*10/30 ( As we are paying to vendor on 10 days before the Due Date)

Net Amount : Rs. 9933.33

In SAP Cash Discount is not calculating like this way.

Please help

[Oumayma_Akil64]

Hello, did you find any solution for this issue ?

[Former Member]

Wouldn't the calculation be as simple as

Amount X (1-% discount)

$10,000 X (1-.02)

$10,000 X .98 = $9,800

Have you looked at all details on the invoice?

[Former Member]

IN SAP Cash Discount is getting calculated on flat days,

like

MIRO Posting date : 01.01.2010

Due Date for Payment is 31.01.2010

Payment made on 19.01.2010

Cash Discount is terms are :

with in 10 days 3%

With in 20 days 2%

System will calculate 2 % flat discount on Invoice Amount,

THis is not required. The requirement is to calculate the Cash Discount on balance 11 days and provision is there to enter the cash discount rate at the time of making payment.

Thanks

Nitin Jindal