Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

"Total expenses and...
 
Notifications
Clear all

"Total expenses and costs per month" report problem

10 Posts
3 Users
0 Reactions
1,794 Views
(@jlacroixg1)
Posts: 17
Active Member
Topic starter
 
[#9822]

Hello,

I don't figure out why there is a difference between what the charges and cost of my project table shows (811 181,67€, which for me seems right) and what the "Total expenses and costs per month" report calculate (874 834,52€, which for me is wrong).

I have spent hours looking for a solution by searching in the "Activities" section. I know the problem is located within the "planned hours" cell : the total should be 50 797,5€ (like on the project table) and not 114 450.15€ (calcul). By the way all the activities related to this project are "in progress".

My question is : why is the "Total expenses and costs per month" report wrong ? Is there something I've forgotten ?

Thank's in advance,

JL


 
Posted : 18 Apr 2025 20H02
Maxca
(@maxime)
Posts: 274
Active Member Admin
 

Hello,
Which version are you on? You can look at the activity expenses if that's where the difference comes from.
The 422 912.04 eur corresponds to the planned cost, this number is calculated in but not displayed on the project.
 


 
Posted : 22 Apr 2025 13H08
(@jlacroixg1)
Posts: 17
Active Member
Topic starter
 

Hello,

The version I'm working with is the 11.4.4.

The difference doesn’t come from the « activity expenses » as I’ve verified all the numbers in this section. So I’m pretty sure it comes from the cost of the « planned hours » section.

The thing is that in the charges and cost of my project table, the displayed cost of the « planned hours » section is 50 797.5€, which for me is right (I’ve verified it in adding all the planned costs from all the activities of the project).

So why is the "Total expenses and costs per month" report calculating 114 450.15€ instead of 50 797.5€ ? Or maybe shouldn’t the total of charges and cost of my project table (811 181,67€) and the "Total expenses and costs per month" (874 834,52€) be equal ?

JL


 
Posted : 22 Apr 2025 13H54
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,
Difficult to analyse the situation with just few screenshots.
Differences seems to be on the planned values, but I cannot find out more.
I would need access to data to understand (but this is out of scope of this free support)


 
Posted : 23 Apr 2025 13H38
(@jlacroixg1)
Posts: 17
Active Member
Topic starter
 

I've found the origin of the problem but still didn't solved it.

The 114 450.15€ calculated by the "Total expenses and costs per month" report was the amount assigned on one activity. This raises several questions :
- Why was the total of the planned cost on the report made by adding the planned activity expenses (308 461.89€) + assigned hours cost (114 450.15€) (=422 912.04€), instead of the planned activity expenses (308 461.89€) + planned hours cost (50 797.5€) (=359 259.39€) like on the the charges and cost of the project table ?
- Why did the report took the assigned hours cost of only one activity (114 450.15€) instead of all the activities (438 981.81€) ?

After this observation, I've decided to delete the activity causing the problem and make a copy of it to see what could happen. Here is the result : now, the total of the planned cost on the report is perfectly equal to the planned activity expenses (308 461.89€), which means that it seems not to include the planned hours cost.

So is this how this report is supposed to work ?

JL
 


 
Posted : 23 Apr 2025 14H11
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

The report "Total expenses and costs per month" exoects to sum Expenses and Costs.
Expenses summed are Project expenses, Individual expenses and Activity expenses.
Costs are costs of resources, from assignment. To get this, resources must have a cost defined (through the function on assignment)
 
Note that as Activity Expenses have been added recently, some reports may not take them into account correctly.
Don't hesitate to point out any issue on this point.

For your specific issue, could you please try and reproduce the case on Demo so that we have a use case to understand ?


 
Posted : 03 May 2025 14H41
(@jlacroixg1)
Posts: 17
Active Member
Topic starter
 

What do you mean by saying "could you please try and reproduce the case on Demo" ?


 
Posted : 05 May 2025 19H47
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

What do you mean by saying "could you please try and reproduce the case on Demo" ?

Reproduce use case on our demo instance : https://demo.projeqtor.org


 
Posted : 15 May 2025 11H36
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Note that we found an issue (fixed on V12.1.2) that, in some cases, erases field `scope` on talbe `expense`
So look for lines where scope is null in table expense, set set it to correct value : 'ProjectExpense' if it is project expense, 'ActivityExpense' if it is activity expense, 'IndividualExpense' is it is individual expense.


 
Posted : 15 May 2025 11H40
(@jlacroixg1)
Posts: 17
Active Member
Topic starter
 

Hello,

I reproduced my example in the demo, "Manager" section.

The project is called TEST_"Total expenses and costs per month" report. It includes one activity, with one resource assigned for 10 days: Analyst A (€300/day), or 300 × 10 = €3,000 assigned.

In the Monitoring tab, I added 10 actual days for Analyst A, for a total actual cost of €3,000.

However, when you edit the "Total expenses and costs per month" report, it appears that only the cost of actual days is counted (€3,000), not the cost of assigned hours (which is shown as €0).


 
Posted : 15 May 2025 15H51
Share:

Scroll to Top