View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Real cost doesn't reflect Real Work - Page 3 - ProjeQtOr
 
 

Real cost doesn't reflect Real Work

More
26 Nov 2018 23:04 #13 by babynus
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)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 16:12 #14 by cnguyen
Hi,
We have executed the query (see attached file).
Real cost is still not what it should be (see attached file).

Best regards
Cyril
Attachments:

Please Log in or Create an account to join the conversation.

More
29 Nov 2018 19:10 #15 by babynus
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)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
30 Nov 2018 09:15 #16 by cnguyen
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

Please Log in or Create an account to join the conversation.

More
01 Dec 2018 17:21 #17 by babynus
We just identified issue : it seemsupdate cannot change cost of work on validated week.
Ticket recorded.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.040 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.