Blocking the Cleared items From Fi Documents

[SrihariNerella]

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

[SrihariNerella]

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

[Former Member]

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

[SrihariNerella]

I am closing this thread.