You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamically Set 'Due Date' to Last Day of Month

edited Jun 30, 2020 3:09PM in Account Reconciliation 6 comments

Summary

Request is to have the final Reviewer 'Due Date' to *always* be the end of the month

Content

(Note: This is a tag-along to David's post here -> ARCS - 'Set Final day of Period' rule?)

Objective: The Reviewer’s End Date should always be the last day of the month (i.e. for Jan it’s Jan 31st, for Feb it’s Feb 28th or 29th, etc.)

  • Note: There is only 1 Reviewer level in this situation

Current Understanding of Functionality: Reviewer End Date calculates as follows:

"Start Date + Preparer Duration + Reviewer Duration"

  • Note: Reviewer End Date is always based off of the Preparer Duration set in the Profile, regardless of the Actual Date submitted.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!