Oracle Analytics Publisher Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hiding the Zero Amount transactions from Create Customer Statements Seeded Report

41
Views
2
Comments
Ganesh Assuru
Ganesh Assuru Rank 1 - Community Starter

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

2
2 votes

Submitted · Last Updated

Comments

  • LJD2705
    LJD2705 Rank 1 - Community Starter

    Hi - did you manage to resolve this as we are having the same issue?

    Many thanks

  • Binod Kumar
    Binod Kumar Rank 2 - Community Beginner

    you can put <?if:AMOUNT_DUE!= 0?> condition in rtf after GLC group loop tag (<?for-each:G_LINE_CLUSTER?>)