erpnext
erpnext copied to clipboard
frappe
Gross and Net Profit Report Calculations are wrong
Information about bug
the gross and net profit is not calculating properly in the report
in the expense head it is taking overall expenses as total instead of selected ledgers
Gross Profit/Loss =(Revenue-COGS) Net Profit/Loss = (Revenue-Expenses)
Module
accounts
Version
ERPNext: v14.9.0 (HEAD)
Frappe Framework: v14.17.1 (HEAD)
Frappe HR: v1.0.0 (HEAD)
Payments: v0.0.1 (HEAD)
Also in V13
Installation method
FrappeCloud
Relevant log output / Stack trace / Full Error Message.
No response
check "include in gross" flag at COA
please make sure all child account must have same value "include in gross"
@thida-bcn i have only set of accounts tobe in Gross Profit. but the sysem is taking whole Expense Head and showing Wrong Gross profit and loss.
Below are the accounts i assigned for gross profit
Below is the GP and NP report at parent level
even you assign a child item, the system will show all items under same group you can create a new group and move that child to new group Thanks and Regards, Thida Business Development Director
Business Centric Network Company Limited +959 977 160 671 +959 254 677 192 @.*** https://businesscentricnetwork.com/
On Sat, Dec 10, 2022 at 12:40 PM maveezmh @.***> wrote:
@thida-bcn https://github.com/thida-bcn i have only set of accounts tobe in Gross Profit. but the sysem is taking whole Expense Head and showing Wrong Gross profit and loss.
Below are the accounts i assigned for gross profit
[image: image] https://user-images.githubusercontent.com/112148467/206835028-f8cb8da8-889c-4b95-9ba7-1ef560ea2461.png
Below is the GP and NP report at parent level
[image: Screenshot 2022-12-10 at 10-07-12 Gross and Net Profit Report] https://user-images.githubusercontent.com/112148467/206835004-e4dc5f6e-6edf-47c3-88ef-6bbefbd23f4f.png
— Reply to this email directly, view it on GitHub https://github.com/frappe/erpnext/issues/33249#issuecomment-1345151588, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOZ6VEFBVV33J3GFUGSX2KTWMQNHFANCNFSM6AAAAAASWSSO6Q . You are receiving this because you were mentioned.Message ID: @.***>
@thida-bcn
Gross Profit shouldn't show all the other expenses. it should only show the ledgers for which gross profit check box is enabled.
:tada: This issue has been resolved in version 14.26.0 :tada:
The release is available on GitHub release
Your semantic-release bot :package::rocket:
@deepeshgarg007 @dj12djdjs the report is working fine in V14. can we please backport it to V13?