Categories
- All Categories
- 7 Oracle Analytics Sharing Center
- 13 Oracle Analytics Lounge
- 204 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 73 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hiding the Zero Amount transactions from Create Customer Statements Seeded Report

Organization Name
BURNCO Rock Products Ltd
Description
Hi ,
As of now "Generate Statement Report" seeded report is displaying the zero balance transaction(Amount Due).But is there a way to hide the transaction who has zero balance.?
scenario
-- IF we have Invoice(Invoice#: DIN-99) and it has zero balance .
-- We have created Credit memo against it with same amount (For Ex: $99)
-- For which it also displays 4 different lines.
Please find the report attached output for your reference.
We are expecting to hide the transaction who has zero balance. As the seeded report does not hold this functionality we are looking to have this as an enhancement request and also the engineer assigned to the SR which we raised for this issue had also advised to raise Enhancement request.
Please find the SR Details:
SR 3-21032067931 : Need to hide or compress the Zero balance(Amount Due) transaction from the report
As per the
Thanks
Dinesh
Use Case and Business Need
HI,
As of now "Generate Statement Report" seeded report is displaying the zero balance transaction(Amount Due).But is there a way to hide the transaction who has zero balance.
scenario
-- IF we have Invoice(Invoice#: DIN-99) and it has zero balance .
-- We have created Credit memo against it with same amount (For Ex: $99)
-- For which it also displays 4 different lines.
Business Need:
Business requires to hide or remove the transactions which are displaying 0..00(Zero) amount transactions.
Note:
Actually we have already customized the BI publisher template , as we have done too many customization on the custom layout we are unable to incorporate the Zero removal logic in the custom layout.
I believe it would be great if we have this zero balance removal in seeded layout itself, so that we can try in the custom as well by referring it. As the seeded report itself does not have the logic to remove zero balance transactions.
Thanks
Original Idea Number: 82c610f3de
Comments
-
Hi - did you manage to resolve this as we are having the same issue?
Many thanks
0 -
you can put <?if:AMOUNT_DUE!= 0?> condition in rtf after GLC group loop tag (<?for-each:G_LINE_CLUSTER?>)
0