Skip to main content
Question

Report Rule needs to resolve to true only once for customer invoice

  • March 5, 2026
  • 2 replies
  • 10 views
P
Do Gooder (Customer)
Forum|alt.badge.img+7

I have a report rule for the report CUSTOMER_ORDER_IVC_REP. It is used to email the invoice to the customer and send a pdf to a folder on the file server. It all works as designed except for one thing. When the invoice is printed within IFS the rule resolves to True and the actions occur. If someone then goes to Report Archive and prints the report, the rule then resolves to True again and I end up with a duplicate pdf and a second email. I cannot find any difference between the two reports to prevent the second occurrence. The below conditions prevent the rule from resolving to True when a duplicate invoice is created but not when the original is printed from report archive.

 

    2 replies

    NickPorter
    Superhero (Customer)
    Forum|alt.badge.img+18
    • NickPorter
    • Superhero (Customer)
    • March 5, 2026

    In Apps10 and earlier versions the easiest way to do this is based on the standard PDF_REPORT_CREATED event, which can have action to send the email out.  When that is reprinted from report archive it doesn’t generate another PDF so it doesn’t trigger again.

    I’m not sure if this could be used the same in IFS Cloud.

    You didn’t specify which version so I don’t know if this will help or not… but it might

    Nick

    P
    Do Gooder (Customer)
    Forum|alt.badge.img+7
    • pshields
    • Author
    • Do Gooder (Customer)
    • March 6, 2026

    I need it to be in a report rule for a couple of reasons. I think I have a solution. I am using the below in a condition and if the below is less then 15 seconds then rule will resolve to true. So any other method of printing the invoice after it is created and printed will resolve to false

    select (sysdate - date_entered) * 24 * 60 * 60 
    from ifsapp.cust_order_invoice_hist
    where message_text = 'Invoice Created' and invoice_id = [@CUSTOMER_ORDER_IVC_REP/INVOICE_ID_STR]

    Terms & ConditionsCookie settingsAccessibility statement