problem with cash discount in billing

[Former Member]

Dear all,

I am facing a problem in billing.

When we go and create an invoice in VF01. The accounting document looks as follows

Account Description Amount

210000 Sundry Debtors 1,307.00

700000 Sales Domestic 1,320.00-

870205 Special Discount 66.00

610111 Vat Output @ 4% 52.80-

850631 Rounded Off Sales 0.20-

The Customer Qualifies for a cash Discount of 2%. Hence the amount he should be finally paying should be (1307- 26.14) =1280.86.

After we receive a payment and look at the document in FB03 we can see the following details:-

Account Description Amount

210000 Sundry Debtors 1,307.00-

870201 Cash Disc. Allowed 1.32-

870201 Cash Disc. Allowed 27.46

220026 HDFC Bank Chq Pay 1,280.86

.

Now what is happening here is that the system is calculating the Cash Discount two times

First time it calculates a Cash Discount of 2% on the Special discount 66.00, which comes out as 1.32 i.e. 2% of 66= 1.32-

Second time it calculates a Cash Discount of 2% on the Sundry Debtors 1,307 and adds 1.32 to it to make it 27.46. i.e. 2% of 13071.32= 26.141.32= 27.46

In totality the entry is correct as the customer is paying 1,280.86 the same amount we had deduced previously

But what is troubling me here is, why are two line items being generated for cash discount allowed in FB03?

In my opinion the system should have only one entry for cash discount allowed for an amount of 26.14 calculated at the rate of 2% on 1307.00

Can anybody explain why this is happening? Are there any settings at the configuration level which I have skipped?

Regards

Deepak

[Former Member · Accepted solution]

hello, friend.

one of the reasons is that the cash discount applies to items posted to different GL accounts. however, i will try to look for the standard FI logic and post again.

regards.

[Former Member · Accepted solution]

Thanks for the reply Jonathan,, would be great if you could help me out with this one... am waiting for your reply.

Regards

Deepak

[rasikm_waghela]

Dear Deepak,

Please check if you have given cash dicount use condition type SKTO fro the same.

When you give cash discount condition type SKTO calculates the discount and appears in pricing.

Just check your pricing procedure whether twao condition types are there for cash discount.

If there are two system will give have two entries for CD.

Regards

Rasik Waghela