web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Timesheet Profile Picture
    Timesheet 10 on at

    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.

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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