web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Adjusting time clock e...
Microsoft Dynamics RMS (Archived)

Adjusting time clock entries with sql commands?

(0) ShareShare
ReportReport
Posted on by Community Member

Is it possible to send SQL commands to SO to adjust a cashier time clock entries? If so what table would I need to be able to access time clock entries? Any direction would be greatly appreciated. I am using RMS 2.0155 SO and HQ 7 stores. I am looking to be able to setup a template sql command that would change and correct the wrong entries instead of giving Managers access to do it.

*This post is locked for comments

I have the same question (0)
  • Timesheet Profile Picture
    Timesheet 10 on at
    Re: Adjusting time clock entries with sql commands?

    BTW, which time clock are you talking about? Is it legal to edit the timesheet settings of a third party software without rights?

    I wouldn't try doing it to any software, moreover the time clock that we use gives all facilities to the users atleast in the admin access.

  • Community Member Profile Picture
    Community Member on at
    Re: Adjusting time clock entries with sql commands?

    update timeclock set TimeOut = '11/22/2008 4:04:47' where id = '16'

    This updates the SO database. As I am finding out there would be a lot a queries to find the exact record you need to adjust and maybe use a method of loging in remotely to change might be the better option for time saving. updating Hq might be the missing component.

  • Community Member Profile Picture
    Community Member on at
    Re: Adjusting time clock entries with sql commands?

    Ok Timeclock is the table.  

    select * from timeclock where cashierID = '5' and TimeIn = '11/17/2008 9:08:43 AM'

    I was trying to use the command to select the record I needed and it returns 0 rows. Is there something wrong with the syntax? No errors when I run it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans