• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Stop date

sperron

Member
Hi,

I'm not a expert developper so I need some help.
What can I do with my very simple report for stopping de report and do the total, if the date of the document is higher than the user put in the PO ?

Sorry with my english but I'm french people.

Thanks for your help !!

Financial RDA
 

Christian Audet

Moderator
Staff member
Bonjour Suzanne,

In your report go to your main section, in the event rules go to initialize section event and put Event Rules similar to this :

jdDateToday = date_today()

if PO date > jdDateToday
Stop Batch Processing <--- (System Function)
endif

If you only need to stop one section and need the rest of the report to run then use "Stop Section Processing".

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

Sef

VIP Member
Bonjour Suzanne,

I am not exactly sure what your issue is, but unless I fully misinterpreted your question, it sounds like you wish to either prevent data selection based on a PO or output based on PO.

In the first case you can include in your data selection criteria (after attaching your Processing Option template) something like

Where 'BC Date for G/L' is less than or equal to 'PO Date'

In the second case you can include an Event rule similar to:

If 'BC Date for G/L' is less than or equal to 'PO Date'
Suppress Section Write
Endif

or

If 'BC Date for G/L' is less than or equal to 'PO Date'
Hide Object (RV xxx)
else
Show Object (RV xxx)
Endif

I hope this will help somewhat. If not, could you pls post a little bit more detail on your issue.

Bon chance,


Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT
 
Top