Product Query:
How to know who performed the End of Day (EOD) process?
Resolution:
To identify the user who performed the End of Day (Till Closing) process, please follow the below steps:
Option 1: Using Report (Recommended)
From HO Management Console:
HO MC → Reports → Till Management → Till Closing Report
This report will display the Till Closing details, including the user who performed the End of Day process.
Option 2: Using SQL Query
You may also verify the details directly from the database using the below queries:
Select * from TilTillMaster
To check specific Till details:
SELECT MasterTillKey, Id, Description, Modified, ModifiedBy
FROM TilTillMaster
WHERE MasterTillKey = '7a91d338-63d5-4953-93d6-12ed9cb007b0'
To identify the username corresponding to the ModifiedBy SecurityUserKey:
Select * from SecSecurityUser
where SecurityUserKey = 'a45448d2-f97f-48d9-9b37-8f2dcf584b46'

The ModifiedBy field in TilTillMaster will provide the SecurityUserKey, which can be mapped in the SecSecurityUser table to identify the user who performed the End of Day process.