question Error on task record after submitting the time card in timesheet portal. in SPM forum

Error on task record after submitting the time card in timesheet portal.

srikanthmee — Mon, 26 Aug 2024 16:39:35 GMT

Hello community,

We started using the timesheet portal in ServiceNow. We can select the task and submit time against the task. As we are doing that, I am running into an issue.

And here is the issue. On the timesheet portal, we are seeing ‘rate type’.

We don't want to rate where type on the portal. As of I know, if I uncheck ‘allow multiple rate types’ on that timesheet policy will remove the rate types from timesheet portal as I need.

But if I did that I'm getting an error on that task itself when I am trying to change anything in the record or put in a comment. Here is the error message.

Has anyone been in the same situation and how did you manage to come out.

Any tips and pointers might be helpful.

Re: Error on task record after submitting the time card in timesheet portal.

srikanthmee — Fri, 16 Aug 2024 17:25:22 GMT

Has anyone faced the similar issue??

Re: Error on task record after submitting the time card in timesheet portal.

srikanthmee — Mon, 26 Aug 2024 16:46:37 GMT

Has anyone faced the similar issue, All I want to do is remove the rate type column from the time sheet portal..

Re: Error on task record after submitting the time card in timesheet portal.

PaulaaO — Thu, 29 Aug 2024 09:28:30 GMT

Hi - were these time cards created when the time sheet policy allowed multiple rate type? usually in the Time Sheet space the records created follow the rule of the time sheet policy at the time; if the policy changes and you want to amend anything on time cards created on a previous time sheet policy it's likely to get this sort of message.

My advice is to try again with brand new time cards and see if you encounter the same behaviour. As for the existent time cards - recall them and re-submit so they follow the latest time sheet policy.

You can remove the Rate type column if you want to, however if that's out of the box I would suggest to not do that. We have customised ours and it caused quite a few problems, including issues with the functionality during upgrades/patches because any update to the components linked to the Time sheet portal would have been skipped due to our customisations.

If you still want to remove the column, then I'd advise you to look into the following widgets:

Go to sp_widget.list and find those with the following IDs -> tc-grid; timecard-portal-container; timecard-task-selector

There might be others, but these I am familiar with and the widget list should be a good starting point.

Hope this helps 🙂

Re: Error on task record after submitting the time card in timesheet portal.

srikanthmee — Fri, 30 Aug 2024 20:02:36 GMT

Hella @PaulaaO,

Thanks for responding to this post. I've just verified this and it is haapenning because I've added the worknotes on the records whose timesheets created with previous timesheet policy where ‘Allow Multiple Rate Types’ is checked.

So the follow up question since our time sheet policies is in PROD and people are using it. How should I introduce this new change. So I believe this should be changed on Friday or weekend after all existing time sheets are submitted. right? Also it is happening if they are coprying the timecards from previous, do you have an idea about how to deal with this.

Re: Error on task record after submitting the time card in timesheet portal.

PaulaaO — Mon, 02 Sep 2024 16:45:54 GMT

Well, the way I would proceed would be first with a communication around the change so users expect it; also advise them to not use the feature with the rate type (ask them to just ignore that part) whilst under the current policy so they can already get used to the idea and the change itself.

Then have a think if there are any changes you wish to apply to time cards created under the current policy so you can action them prior to changing the policy (as you stated above you needed to add some work notes).

If there are changes/additions on time cards you expect to be done by the users, instruct them to do so and give them a deadline.

We were actually in a similar position and a few weeks after updating the time sheet policy we had to recall some of the time cards in order to allow submission under the newest policy. Now depends how many time card users you have, but it should be a temporary inconvenience and then an ad-hoc request in case in a few month's time someone wants to amend a time card under the previous time sheet policy.

What I also did as an admin, for time cards in Pending or Submitted I cleared out any values in the Rate type field right after changing the time sheet policy (especially on time card records created recently) to save myself a headache later on; only because any change in State would have triggered an error message so wanted to be proactive on it.

As for the Q with copying the time cards, I cannot recall exactly if Rate type is picked up, though I would expect to; it is best to test this in a non prod or PDI if you haven't done so. If you have and it's picked up, then most you can do is just try to drive good user behaviour - advise your users to avoid using the functionality for that initial time card post policy change and also mention what would happen if they don't do that and how they can deal with the error themselves.

Hope this makes sense 🙂 Good luck!!

Re: Error on task record after submitting the time card in timesheet portal.

srikanthmee — Tue, 03 Sep 2024 17:04:08 GMT

thanks @PaulaaO

Re: Error on task record after submitting the time card in timesheet portal.

Damian Martinez — Wed, 04 Sep 2024 10:13:31 GMT

Hello @srikanthmee

I had to remove some other columns before from Time Sheet Portal and this article helped me to acomplish that.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0825556

Please give it a try and let me know if this helps.

Regards.