For late payments, we want to calculate or capture the duration an invoice takes between two process checkpoints and if it's over an expected duration, then we tag the entry with a reason label.
Example
If the duration between Vendor Creates Invoice + Scan FI Document is greater than 2 days
Then, add reason 'Late Submission / Missed in Inbox' into reason column
We have multiple statements to add for other checkpoints but the logic is the same.
Any help would be greatly appreciated
Thanks
Hi Jack,
Your reason column will look something like this
CASE WHEN CALC_THROUGHPUT ( FIRST_OCCURRENCE E 'Submit draft' ] TO FIRST_OCCURRENCE E 'Receive feedback for draft' ] , REMAP_TIMESTAMPS ( "Activity"."Event Time" , DAYS ) ) = 2
THEN 'Late Submission / Missed in Inbox'
WHEN CALC_THROUGHPUT ( FIRST_OCCURRENCE C 'Acivity1' ] TO FIRST_OCCURRENCE C 'Activity2' ] , REMAP_TIMESTAMPS ( "Activity"."Event Time" , DAYS ) ) = 2
THEN 'Late Submission / Missed in Inbox'
WHEN ........ (this is where you put the next condition )
END
You can also replace FIRST_OCCURRENCE to LAST_OCCURRENCE based on your requirement.
Hope this helps !
Thanks for the quick response and detailed explanation Abhishek. We will take a look 😀
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
