topic Re: Customer/Vendor Ledger Reports in Application Development and Automation Discussions

Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 05:55:28 GMT

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

Re: Customer/Vendor Ledger Reports

madhu_vadlamani — Wed, 11 Sep 2013 06:37:45 GMT

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.

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 06:46:25 GMT

This message was moderated.

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 06:46:41 GMT

This message was moderated.

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 06:47:04 GMT

This message was moderated.

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 07:04:32 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 07:09:17 GMT

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.

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 07:19:32 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 07:20:57 GMT

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

Re: Customer/Vendor Ledger Reports

arindam_m — Wed, 11 Sep 2013 07:22:50 GMT

Hi,

Your Tables of Interest:

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

Cheers,

Arindam

Re: Customer/Vendor Ledger Reports

RaymondGiuseppi — Wed, 11 Sep 2013 08:48:58 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 10:49:54 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Wed, 11 Sep 2013 12:00:47 GMT

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

Thanks again

Mani

Re: Customer/Vendor Ledger Reports

RaymondGiuseppi — Wed, 11 Sep 2013 14:55:09 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Thu, 12 Sep 2013 06:07:27 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Thu, 12 Sep 2013 07:28:43 GMT

Hi Priya,

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

Regards

Mani

Re: Customer/Vendor Ledger Reports

Former Member — Thu, 12 Sep 2013 09:02:51 GMT

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

Re: Customer/Vendor Ledger Reports

Former Member — Thu, 12 Sep 2013 10:31:59 GMT

Hi,

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

Regards

Mani

Re: Customer/Vendor Ledger Reports

vinod_vemuru2 — Thu, 12 Sep 2013 11:47:56 GMT

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.

Re: Customer/Vendor Ledger Reports

RaymondGiuseppi — Thu, 12 Sep 2013 11:58:33 GMT

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