Timecard=>Expense Line=>Rate card query

Shantharao
Kilo Sage

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

3 REPLIES 3

Saloni Suthar
Mega Sage
Mega Sage

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

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

Shantharao_0-1715242130006.png

 

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



Community Alums
Not applicable

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.