Cash discount to a customer

[Former Member]

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

[Former Member]

Hi

Thanks for the update.

I checked FBL5N and found the cash discount figure and that figure is matching with the figure which i have taken from BSE_CLR.

What i am looking is to do a reconciliation of a customer account, I took the balance of a customer as on 31.12.2011 (i.e. opening balance for the next year) and added all the postings (all items) from FBL5n for the period 01.01.2012 to 31.08.2012 except the residual clearing documents (both open & cleared). Then deducted the cash discount figure and that will
become my closing balance. Ideally i should get the same balance what is getting in FBL5n open items as on 31.08.2012, but a huge difference.

thx & regds

[Former Member]

Hi

For the different you need to analyize it from tables (BSID,BSAD) except document type "DC"

total "DC" must be 0

If you cleared one line in AR doucment BSE_CLR will come Dr. or Cr. so the balance will not equal 0

Regards

[Former Member]

Hi

The only possibility of the difference as per my understanding is cash discount and rounding off adjustments, isn't? That is the reason i eliminated the clearing residual documents fully, so i got the actual postings (either invoices, debit/credit memos and incoming payments) and adjusted the derived cash discount figure.

thx & rgds

[Former Member]

The difference come from clearing or Special GL indicator

Regards

[Former Member]

Hi

There is no spl gl indicator posting in the customer account, purely the genuine transactions (invoices, debit/credit notes, incoming paymnets) and clearing documents, the only part hidden is the cash discount which is merged with clearing documents and posting the same to cash disc exp account. So theoratically if we exclude the clearing documents and deduct the derived cash discount, we will get the closing balance. how can i found out this.

thx & rgds  

[Former Member]

Hi Deep

You have to made query, specific layout in FBL5N, throw COPA or check the link

http://scn.sap.com/thread/1841855

Regards

[Former Member]

Hi

Thanks for the update.

I checked FBL5N and found the cash discount figure and that figure is matching with the figure which i have taken from BSE_CLR.

What i am looking is to do a reconciliation of a customer account, I took the balance of a customer as on 31.12.2011 (i.e. opening balance for the next year) and added all the postings (all items) from FBL5n for the period 01.01.2012 to 31.08.2012 except the residual clearing documents (both open & cleared). Then deducted the cash discount figure and that will become my closing balance. Ideally i should get the same balance what is getting in FBL5n open items as on 31.08.2012, but a huge difference.

thx & regds