topic Re: Blocking the Cleared items From Fi Documents in Application Development and Automation Discussions

Blocking the Cleared items From Fi Documents

SrihariNerella — Sat, 04 Apr 2009 12:08:13 GMT

Hi ,

I am creating fi report . In my report i do not want to display cleared items . Can you tell me based which table and which field we can remove clearing documents .

In my customer balance report i want to remove the reversal entries of customer and cleared entires of customer . Can you tell me based on which field can i remove those documents .

Regards

Nandan.N

Re: Blocking the Cleared items From Fi Documents

SrihariNerella — Mon, 06 Apr 2009 04:14:56 GMT

Hi,

Cleared Documents in fi and mm . How can we block in my report those cleared documents and reversal documents in sd .

Regards

Nandan.N

Re: Blocking the Cleared items From Fi Documents

Former Member — Mon, 06 Apr 2009 04:34:50 GMT

hi Srihari,

consider only open item tables , if u want to block cleared items.

Bsik : open item table for vendor related.

BSAK : Cleared item table for vendor.

similarly

bsid : open item table for customer

bsad : cleared item table for customer.

For developing customer ledger , i think u had to consider both open items and cleared items.

Its just like bank statement ( transactions both cleared and open ) .

If you developing outstanding report ,( balance repor) consider only bsid table.

Regards,

Hari priya

Edited by: Hari Priya on Apr 6, 2009 10:05 AM

Edited by: Hari Priya on Apr 6, 2009 10:07 AM

Re: Blocking the Cleared items From Fi Documents

SrihariNerella — Mon, 20 Apr 2009 13:23:01 GMT

I am closing this thread.