question Need help on Expense Line created upon Time Card Approval in SPM forum

Need help on Expense Line created upon Time Card Approval

shaik_irfan — Tue, 03 Dec 2019 08:40:01 GMT

Hi,

We are currently in Madrid. Can anyone please help me in understanding how the Amount in Expense Line is getting calculated ?

I have Cost Plan created via a Resource Plan of type Group with the start & end date as 12/1 to 12/15. Now Resource Manager confirmed & allocated all the 20 hours to 1 resource.

====

Once the Resource filled the time card for 1 day which is 8 hours initially and submitted the time sheet & approved, 2 Expense line created 1 with empty Amount and another with $400 amount

Time Card:

1 Expense Line:

2 Expense Line:

Later after sometime i submitted the remaining 12 hours for 12/3 & 12/4 once it is approved it created another 2 Expense line 1 with empty and another with $6000 amount

Now my question is on what basis the Amount is calculated, i assumed it should fulfill the complete $10,000 as per the RP/Cost plan created.

As per my understanding initial Expense Line generated with $400 it took $50 X 8 hours which is default rate & and the next Expense Line generated based on the Rate Model defined rate $500 X 12 hours - $6000

Why it is taking Default rate sometime & rate model sometime

Re: Need help on Expense Line created upon Time Card Approval

yogesh41 — Wed, 04 Dec 2019 04:40:51 GMT

The expense lines amount for the Time Card refers the Rate Model defined ( if any ) on the Project against which time cards are logged.

If the Rate Model is not defined then system toys to find hourly rate from Labour Rates. At the end it falls back to default rate provided as system property.

The behaviour noticed in your instance is unexpected unless Rate Model reference has been updated/cleared from the respective project record.

- Yogesh

Re: Need help on Expense Line created upon Time Card Approval

shaik_irfan — Wed, 04 Dec 2019 05:50:21 GMT

Hi Sir,

Thank you for the response. I am doing in my PDI, let me tell you what i did. I Created a Rate Model and i added the attribute as Group and i created Rate Lines for two month (12/1/2019 - 1/1/2020) for a Group.

Later i created Resource Plan for 1/12/2019 to 15/12/2019 and assigned for a Group Architects and as i RM i confirmed & allocated only for Chandan Singh user.

And i filled first Time card for 8 hours on 12/2 which is Monday and i approved it captured only $400 in Expense Line Amount and later after 10 mins i filled another Time Card from 12 Hours on 12/3 & 12/4 and this time it captured $6000.

I havent done any customization except creating a new Rate Model. Please help me on this if i did anything wrong

Re: Need help on Expense Line created upon Time Card Approval

yogesh41 — Wed, 04 Dec 2019 08:39:52 GMT

As per above details, ideally 12/2 expense lines should haven also be taken Rate Model rate, i.e 500*8 = $4000.

It would be difficult to find root cause without having access to the instance, because I have verified in OOB instance it is working as expected.

You can start from fresh and test same scenarios or consult custom support if it impacting your business.

- Yogesh

Re: Need help on Expense Line created upon Time Card Approval

shaik_irfan — Fri, 06 Dec 2019 12:51:41 GMT

Not sure why but when i tested it back it worked. Sometimes it is not working 😞