Forum

Real cost doesn't r...
 
Notifications
Clear all

Real cost doesn't reflect Real Work

17 Posts
2 Users
0 Reactions
8,960 Views
(@cnguyen)
Posts: 38
Active Member
Topic starter
 
[#5509]

Hi all,

I'm using Projeqtor 6.3.7

I've just done the following operations on a project.
3 resources on my project. Everyone has entered real work up to 31 october 2018.
On one of the resource, i have just entered a cost (C EUR) on the expert profile (This profile is the one my resource is assigned with for the projet / activity)
There was no other cost in the system for the resource.

On the project before entering the cost, real work was X days and real cost was 0 EUR
I saved the cost for the function of my resource on the project (Expert)
Back to the activity, the real cost is still 0 EUR.

Then I enter 1 day on the real wok allocation screen
Real work is now X+1
And real cost is now C EUR, which is the cost I have just allocated for the function.

Seems like real cost has not change for the already existing work.

Any idea ?
Thanks in advance.
Cyril


 
Posted : 28 Oct 2018 11H49
(@babynus)
Posts: 14952
Member Admin
 

Seems like real cost has not change for the already existing work.

It should, I think current code does.

Any idea ?

Migrate to latest stable (V7.2.6).
(there were some fixes on the subject on V6.5)

NB : we won't analyse issues on older versions our of Support Service


 
Posted : 28 Oct 2018 17H35
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

Hi babynus,
Just upgraded to 7.2.6 and the issue remains the same.

Could you help ?

Thanks in advance
Best regards,
Cyril.


 
Posted : 01 Nov 2018 16H59
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

Hi everyone,

@Babynus, we upgraded to 7.2.6 and real cost still doesn't reflect real work for already submitted "work".
We are a bit stuck with this and it's difficult to follow costs for these projects.

By the way : the upgrade to 7.2.6 has brought a lot of new functionalities for us that are really nice and helpful. Thanks for all the good work on Projeqtor 🙂

Thanks in advance for your help.
Best regards
Cyril


 
Posted : 13 Nov 2018 10H35
(@babynus)
Posts: 14952
Member Admin
 

@Babynus, we upgraded to 7.2.6 and real cost still doesn't reflect real work for already submitted "work".
We are a bit stuck with this and it's difficult to follow costs for these projects.

You need to have some resource cost change to update cost from work.
Try and delete cost for resource then recreate it.


 
Posted : 13 Nov 2018 10H56
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

As there is some real work assigned with this function, I can't delete the cost

Error message I get when I want to delete the cost assigned to the function.
Impossible to delete this element because of existing dependent elements
- Assignment (10)


 
Posted : 13 Nov 2018 18H50
(@babynus)
Posts: 14952
Member Admin
 

Try just to change the value.


 
Posted : 14 Nov 2018 11H54
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

I've changed the cost on the resource. Then back on the activity, real cost has not changed.
I changed again the cost to the old cost, no change.


 
Posted : 14 Nov 2018 12H08
(@babynus)
Posts: 14952
Member Admin
 

Hi,

I just did the test.
Resource with cost 100€/day

Assigned to activity with 5 assigned days, 1 real day, real cost of activity is 100€

Now update cost to 150€ / day

Real cost on activity is updated


 
Posted : 14 Nov 2018 13H52
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

The difference with our context is that at the beginning, my real cost is not ok (yours is 100 for 1 day, and after 150 for 1 day).
Everything is ok, even before changing the cost.
My context is :
a project on which real work was already entered. But no cost on the function for the resource.
Then add a cost and no change
Cyril


 
Posted : 14 Nov 2018 14H22
(@babynus)
Posts: 14952
Member Admin
 

New test in your context.
Resource with no cost

Assigned for 5 days, 1 real on activity : no cost

Add cost

Cost is updated on activity

All works fine.

Please post screenshots as I did to show your use case.


 
Posted : 16 Nov 2018 1H42
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

Hi,

The software is working well as you showed on the previous screenshot.
I can confirm that on project / activity that I have recently created or on which costs where added before real work allocation was saved in the tool.

My example is the following :
- ScreenShot 1 : On my project there is one activity that shows the following
210 days real work for my resource
Resource is assigned with expert function as you can see.
Real cost is 12 600 EUR

- Screenshot 2 : My resource cost is 504 EUR for Expert function.
Sorry you don't see the name of the resource on the screenshot but no doubt it's the resource that is assigned on the activity.

210 * 504 is 105 840 EUR, which is not 12 600 EUR.

So I don't understand why I get 12 600 EUR in real cost for the activity.

Best regards
Cyril


 
Posted : 26 Nov 2018 19H43
(@babynus)
Posts: 14952
Member Admin
 

I think it is due to old versions of ProjeQtOr storing null and not zero.
It was changed because of PHP 7.1 than could not sum null+not null.
So ever you can test with PHP 7.0 and it should work correctly,
or you need to update database

update work set cost=0 where cost=null;

(don't forget to backup database before executing SQL statement)


 
Posted : 27 Nov 2018 1H04
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

Hi,
We have executed the query (see attached file).
Real cost is still not what it should be (see attached file).

Best regards
Cyril


 
Posted : 29 Nov 2018 18H12
(@babynus)
Posts: 14952
Member Admin
 

Well, the upsate is not enough.
Now you have to change value for resource cost.
What would be best is to delete existing and create new one, but it won't be possible (you cannot delete resource cost if function is used on assignment)
What you can do is add new cost "far in the past" (for same function, with starty date before first day of real work)


 
Posted : 29 Nov 2018 21H10
(@cnguyen)
Posts: 38
Active Member
Topic starter
 

Hi,

Add a cost far away in the past.
I understand this must be done with a SQL Query.
Can you provide us with the query

Best regards
Cyril


 
Posted : 30 Nov 2018 11H15
(@babynus)
Posts: 14952
Member Admin
 

We just identified issue : it seemsupdate cannot change cost of work on validated week.
Ticket recorded.


 
Posted : 01 Dec 2018 19H21
Share:

Scroll to Top