Gross Profit Reports Incorrect Total Amounts

[dj12djdjs]

Information about bug

In the image below, the green row represents the correct Gross Profit totals, the red row represents the ERPNext reported totals, and the last row represents the difference.

This is caused by ERPNext summing the total twice. The first time is the "header" for example:

The second time is the "details" for example:

Notice Somehow the duplication only happens on columns 4-6 which is also illustrated in the first image.

Secondly, the Total gross profit percentage is showing the average of all the gross profit percentages. Not the actual total

Module

accounts

Version

frappe develop erpnext develop

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response

[nihantra]

Hi @dj12djdjs,

Same issue in current version #34507

Please, Can you share with us the code line of the gross_profit.py file for the correct total shown in the report?

Thank You! NCP

[dj12djdjs]

Hi @nihantra,

I haven't been able to find a permanent solution for this issue. What my organization is doing in the mean time is exporting the Gross Profit report into excel. Removing the duplicate rows, then summing all the columns manually.

[moizsami]

Hi, any updates or workaround on this ? even my customers are complaining about the same. Since Im using frappe cloud, cannot provide any solution from my side also.

[ZahidMoideen]

is this issue solved ?

[quandm87]

@ruthra-kumar : hi, this issue doesn't seem to have been fixed; is there any way to resolve it?

[vudq]

We found a bug in https://github.com/frappe/frappe/blob/develop/frappe/desk/query_report.py#L484 of the Frappe Framework. The total is calculated from the child rows, but when dividing to calculate the percentage, it is applied to the entire grid's rows.

[dvdl16]

Can confirm, also an issue for us

Frappe CRM: v1.19.0
South Africa Customisations: v0.1.6
ERPNext: v15.34.2
Frappe Framework: v15.40.3
Helpdesk: v0.10.0
Frappe HR: v15.28.3