Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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