Cutoff date logic using cmn_schedule
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Hello
I have a requirement that,
"Payroll has a monthly cut-off date defined in an annually updated calendar. Any pay element claims (such as overtime or allowances) submitted after the cut-off must still be accepted but will not be processed until the next payroll cycle. The system must read the official payroll cut-off calendar, validate submission dates, warn users submitting during the blackout period, hold such claims, and automatically send them via the payroll API once the blackout period ends."
The effective date for the element entry is set to the 1st of the relevant month, formatted as DD-MM-YYYY (01/01/2025).
This date is determined based on:
- The current date.
- Whether the payroll cut-off has passed at the time of approval or sending
So, how can I achieve this requirement using Schedule table (I don't want to create custom table).
Submitting a Record Producer, based on its Created Date, I have to find out cutoff date and setup the effective date in payload.
Thank you