Has anyone noticed the inconsistencies in Gross Profit on V12.
ERPNext: v12.18.0 (version-12)
Frappe Framework: v12.15.0 (version-12)
If filtered by Invoice then it is not considering return item value. I compared it with Item Code filtered report to find 4 units of 2 items returned but not recorded in Invoice filter report. Rest of the filtered reports are fine.
Gross Profit %in the
Total(bottom) is actually an average of all the rows. Hence its totally incorrect. The formula should be
(Selling Price - Buying Price)/Selling Pricejust like the formula in the rows. If you have anything more than one row in filter by Invoice, Warehouse, Item Code etc you have different gross profit % for the same total value. In my case I have only 1 of Warehouse, Customer, Customer Group & territory due to which % is accurate but rest to the above are multiple lines. Heck, I have Total Gross Profit from 14% to 35% depending on which filter I am choosing.
Total section of
Avg. Selling Rate&
Valuation Rateshould be blank. It cannot be average of total row, which is it currently. Why does it need to average out the rows and how does it help?
Heres a comparison. Note the huge difference in the Buying Amount. If total value of 4 units is 13.714 then how come the difference is 91.72. The selling amount matches which is fine.
If anyone has fixed this then please do let me know.