Customer/Vendor Ledger Reports

[Former Member]

Hi Experts,

The client wants the customer and vendor ledger reports. The FBL1N and FBL5N shows the correct balance. But the problem is that it does not show the DR and CR balance separately. Is it possible in standard itself to divide the 'Amount in local currency' in two different balances as debit and credit.

I would request the experts to guide me as how can I show the total debit and credit balance of a particular customer/vendor in a particular date? Or should I have to create a customized one from the scratch?

Regards

Mani

[Former Member]

Hi Experts,

The client wants the customer and vendor ledger reports. The FBL1N and FBL5N shows the correct balance. But the problem is that it does not show the DR and CR balance separately. Is it possible in standard itself to divide the 'Amount in local currency' in two different balances as debit and credit.

I would request the experts to guide me as how can I show the total debit and credit balance of a particular customer/vendor in a particular date? Or should I have to create a customized one from the scratch?

Regards

Mani

[madhu_vadlamani]

Hi Mani,

As i know it is not possible to get this in standard report. You need to go for a custom one.

Regards,

Madhu.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hi Mani,

Copy the standard reports and modify as needed or write a program and submit it to this report

and read the alv table from memory.

Details

Then display it as required.

I hope it helps.

Regards

[Former Member]

Hi Yakub,

Thanks for the reply. Let me copy it to a zreport and divide that field into dr and cr. I will get back to you.

Regards

Mani

[Former Member]

I am not sure if the below solution can be applied, u can give a try.

Create two custom fields (debit and credit) using BTE's available for the standard transactions. U can write your logic for filling these fields in the BTE function modules.

[Former Member]

Hi Maju,

I don't what are are BTE's but still I'll do some study and try to make changes in the standard one. Still waiting for more alternates?

Regards

Mani

[RaymondGiuseppi]

Search and display BTE documentation in BERE (Publish&Subscribe) and BERP (Process) you will see a sample FM that you have to copy. Then in FIBF create a product, and attach your copied FM to BTE and project. If project is active, FM will be called.

But here better use BAdI.

Regards,

Raymond

[arindam_m]

Hi,

Your Tables of Interest:

lfa1, lfb1, bsik, bsid, kna1. May be get the logic and just write up a report.

Cheers,

Arindam

[RaymondGiuseppi]

Yes you can, just define DB and CR columns/fields in an append of RFPOS / RFPOSX structures, execute report RFPOSXEXT to regenerate the FBL*N displayed structure.

Then either use BTE 00001650 or BAdI FI_ITEMS_CH_DATA (the BAdI is usually better for performance, but here as no database access are required, that don't matter much)

In the implementation just move amount field(s) to correct DB/CR field(s) using SHKZG.

Also execute BALVBUFDEL before testing.

For SAP reference on how to add information to FI item reports, read Note 984305 - Line item: Definition of special fields (T021S) and Note 1323512 - Line items: BADI FI_ITEMS_CH_DATA.

Regards,

Raymond

[Former Member]

Hi Mani,

Add your custom fields in RFPOS structure and RFPOSX structure and do the code changes in BAdI FI_ITEMS_CH_DATA to pass the data.

Please find the step by step document  which I have posted in the below link  for adding fields in FBL*N transaction .

http://scn.sap.com/docs/DOC-44226

Regards,

Priya Chinnasamy

[Former Member]

Hi Priya,

FI_ITEMS_CH_DATA, there is no BADI by this name. What BADI should I use?

Regards

Mani

[RaymondGiuseppi]

What is your SAP version, for oldest version the BAdI was not yet delivered, so use the good old BTE. (check minimal version required in the link to Note 1323512 - Line items: BADI FI_ITEMS_CH_DATA I already provided -> ECC 5 (2004) or ECC 6)

But the BTE works only on a call per record, and special fields are not available, structure RFPOS and not RFPOSXEXT.

Regards,

Raymond

[Former Member]

Thank you for the overwhelming responses. I will see to it and get back to you soon with further issues

Thanks again

Mani

[Former Member]

Hi,

I am working on it. I have appended the structures and implementing BADI on it. Meanwhile the client wants to see all the records except for the ones with the tcode FBA8. How to remove the records with the tcode FBA8. I mean where to do the code? Please check the following screenshot:

Regards

Mani

[Former Member]

Hi Mani,

In Badi FI_ITEMS_CH_DATA, for that particular document ( ct_items-belnr) check in BKPF table for that document - BKPF- TCODE is FBA8. if yes then delete that record in table CT_ITEMS.

Regards,

Priya

[Former Member]

Hi,

Thank you for the reply. It says there no such BADI exists.

Regards

Mani

[RaymondGiuseppi]

You could add in customizing of special fields BKPF-TCODE, then in the BADI delete records based on field U_TCODE. (or access BKPF in BAdI then deleter records)

But, why would the user not filter this in free selection at start of transaction ?

Regards,

Raymond

[vinod_vemuru2]

Hi,

Doesn't FK10N and FD10N serve the purpose? Initial report shows period wise. Double clicking on balance of a period shows respective line items(Credit/Debit/Credit+debit(Cumulative)). Then you can use filter to filter out the required data.

Thanks,

Vinod.