Timecard=>Expense Line=>Rate card query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-08-2024 09:43 AM - edited ā05-09-2024 03:57 AM
Hi All,
How can we understand the expense line generation after the timecard processed
I am confused about the configurations behind, how expense lines are generated once the time card is processed.
Can someone explain the process how these are interrelated
Timecard=>Expense Line=>Rate card
what configurations we need to check in the servicenow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-08-2024 12:34 PM
Hi @Shantharao ,
Once the time cards are processed, below is the calculation:
Expense line amount = Total hours submitted in the time sheet x Rate from rate card of user.
Expense line amount = 40 x 24 = $960.
If you are looking for backend configuration, I believe TimeCardProcessHandler Script include would be a good one to start with.
If my response helped you, please click on "Accept as solution" and mark it as helpful.
- Saloni
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-09-2024 01:14 AM
Hi Saloni,
Thank you for the quick response, my query is that based on the time card processing expense lines are created but, how the system know for this timecard this expense line should generate,
Do we have any backend configurations mapped between the timecard and expense line?
I have seen a relationship between rate cards and expense lines like below but how this rate card is taged to expense, does it have static mapping or dynamically set from rate cards table
I am a bit confused about these relationships of Timecard=>Expense Line=>Rate card
1). How the expense lines are generated after the timecard is processed?
2). How to identify why only this expense line was generated for a specific time card?
3). How to identify why only this rate card is mapped to specific expense line
I want to know the process, we are going to implement in Timecard management and Project resource allocation to our clients
Thanks for your inputs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-13-2025 07:05 AM
Did you ever figure this out? I have a similar question - I'm trying to show (on the Expense Line) table the rate so we can see the full calculation - Hours from time sheet * Rate from rate card = Expense Line Amount. Any field that I've added via dot-walk that looks like it should be correct is blank.