cancel
Showing results for 
Search instead for 
Did you mean: 

PLD, Balance sheet report > exclude accounts with zero / no balances

somchitra_oun-anuiom
Participant
0 Kudos

In the standard B1 Balance Sheet report, how can I exclude accounts with no / zero balances ?

Using the checkbox 'account with balance of zero' seems to have no effect at all.

Please advice

Edited by: Somchitra Oun-anuiom on Oct 3, 2008 8:18 AM

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member187989
Active Contributor
0 Kudos

In Balance Sheet Print layout Desinger(PLD) Select Report Vertical Balance Sheet-Create a new template using

APA vertical Balance Sheet,Create a new formula field for ex.

Field_073 != 0.00 and detick visible &

Select Field_068 with system variable-264 & Link to Field_073.

It will eliminate zero values in Balance sheet print report.

Jeyakanthan.

Former Member
0 Kudos

How many of your accounts with 0 balance displayed? It might be 0.00XX balance but displayed as 0.00

Thanks,

Gordon

former_member187989
Active Contributor
0 Kudos

Raise a ticket to SAP in service market place www.service.sap.com

Jeyakanthan

Former Member
0 Kudos

Uncheck the checkbox 'account with balance of zero'

Check 'Display LC'

somchitra_oun-anuiom
Participant
0 Kudos

Like i mentioned earlier, I am doing just this, but I still have accounts showing as empty (no balances).

How do I get past this ?