cancel
Showing results for 
Search instead for 
Did you mean: 

To Calc Bill Discount,LC amount,Deposits,Cheque issue amt based on Bank key

Former Member
0 Kudos

Hi,

I have a requirement where in I have to develop a report to display bank balance chart with the following details in the output.They are :

1. Posting Date

2. Bill Discount (BD)

3. Letter of Credit(LC)

4. Cheque Amount may be cheque issued.

5. Deposits.

Above are the information which i have to display based on Posting Date range , Company Code and Bank Key present in the selection-screen.

Below are my few observations:

1. To retrieve the Bill Discount, I am first fetching the data from BKPF table by checking the document types 'DZ' ,'KZ', Company code and Posting Date Range. Then using document number,company code present in these entries along with Posting key = 39 and special GL indicator = 'W' retrieving the data like DMBTR,WRBTR from BSEG.

2. Similarly for Letter of Credit amount retrieving the data in the same way as mentioned above except special GL indicator will be 'Y'.

Now please correct me if my approach is wrong. Request you all to throw some light as I am Technical Consultant and humbly looking forward to all your help.

Also, request to let me know the logic or process how one can calculate fourth point as well as Fifth point as mentioned above.

Regards,

Raghavendra Kulkarni.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I have a requirement where in I have to develop a report to display bank balance chart with the following details in the output.They are :

1. Posting Date

2. Bill Discount (BD)

3. Letter of Credit(LC)

4. Cheque Amount may be cheque issued.

5. Deposits.

Above are the information which i have to display based on Posting Date range , Company Code and Bank Key present in the selection-screen.

Below are my few observations:

1. To retrieve the Bill Discount, I am first fetching the data from BKPF table by checking the document types 'DZ' ,'KZ', Company code and Posting Date Range. Then using document number,company code present in these entries along with Posting key = 39 and special GL indicator = 'W' retrieving the data like DMBTR,WRBTR from BSEG.

2. Similarly for Letter of Credit amount retrieving the data in the same way as mentioned above except special GL indicator will be 'Y'.

Now please correct me if my approach is wrong. Request you all to throw some light as I am Technical Consultant and humbly looking forward to all your help.

Also, request to let me know the logic or process how one can calculate fourth point as well as Fifth point as mentioned above.

Edited by Raghavendra Kulkarni.

I am just looking for flow of data/process flow/standard transactions through which I can see these above mentioned things which can help me in building the logic. At least a general approach to this will be appreciated highly.

Regards,

Raghavendra Kulkarni.

Former Member
0 Kudos

This is the Asset Accounting forum. Please post your question in the appropriate forum.

Former Member
0 Kudos

Thank you. will do the same.