Skip to Content
Former Member
Sep 08, 2012 at 05:44 AM

Cash discount to a customer


Hi FI experts,

Is there any way to find out how much cash discount paid to a customer in a specific period. Is there any link between the expense account postings and customer.

Eg: the entry at the time of clearing as below:

(cash discount is 5%)

Invoice Dr 1000

Incoming Payment Cr -950

Clearing Cr -1000

Clearing Dr 950

Discount Exp Dr 50

Over a period of time this account grown up and lot of cash discounts, reversal and partial payments happened. Now I want to know how much cash discount debited in the expense account for a specific customer. I searched the documents in the table BSE_CLR, but the figure which i am getting from there is not matching..and not able to correlate with customer balance. Please advise is there any chance to find it out.

thx & regds