INF-12307: CM - Finalize Day/Insert Closing Changefund script for future doomsday scenarios

Hi team,
These are my notes from our meeting, to provide some more AC for this feature:

1. The scenario that we are trying to solve for, is when a store is closed, but the POS is still on line
   • In this case, EOD/SOD records are received from the POS, along with Opening Shift records for specific system users (Mobile Order Taker, Online Order Taker, etc)
2. In this instance, the record in Mx will be a 1
   • After discussing this, our goal state is to set the MxDay record to be 2, which is an ephemeral day
   • Note: When updating the MxDay record, is it possible to change the times in DayOpen and DayClose, to be some value that draws attention to them, and is different from Sundays, which are also marked as 2. Maybe 03:03:03 & 04:04:04
     • Something to help us differentiate between Sundays and HD Script closed days
   • Note 2: If a Sunday, or a day marked as Closed in Entity Manaager is included in the range that is being closed, do not update the MxDay record, leave it as it is
3. The script should only automatically mark days as closed when there are zero sales and zero paid in/out records
   • If there are sales (+ve or -ve), or if there is a paid in or paid out, the user should be prompted to complete the workflow for that day
4. Performance - Test against sandbox to ensure that the script is optimized, and provide benchmarks
5. Stacy supplied two scripts, to reference, which are used in the Training Environments to move days.
   • CFA 2017R5 HD qryMMS_HD_FRLRefresh_Execute.sql
   • JATesting Advance Financial and WorkflowR5.sql
   • Note: In the first script, data is inserted using CMOperator as the user, we would like to use a specific user as a part of this script, and this user should be inserted into the database as a part of the deployment. Colin Wyatt-Goodall, please ask if you have questions about this user
6. Workflow instances - Colin is going to look at the best way to solve for an Open workflow instance on the first day that is being closed (Delete it or move it)
7. Opening Change Fund - The Opening Change Fund comes from the Closing Change Fund of the previous day, Stacy Privalova is pretty sure that it's the previous calendar day, not the previous workflow day, although we somehow handle Sundays

Attendees: Stacy PrivalovaMarwa AbdelwahedCharles WheelerTristan StrongColin Wyatt-GoodallSharon Madihlaba