erpnext
erpnext copied to clipboard
frappe
Incorrect Profit and Loss Report when filtered by date range
Information about bug
Financial Year Set to Apr-Mar Cycle
But when profit loss statement fetched for Jan-Dec, the report is incorrect when periodicity set to "Yearly". But when set to "Monthly" the report is correct.
PFB the related screenshots
When set to "Yearly"
When set to "Monthly" - This matches with the GL
Module
accounts
Version
Frappe Framework: v13.35.1 (version-13) ERPNext: v13.35.2 (version-13)
Installation method
easy-install
Relevant log output / Stack trace / Full Error Message.
No response
@nadarvinod In the first screen shot you are looking at the total income. In the second screen shot you are looking at "Profit for the year" that would be total income - total expenses. That is why those two values don't match.
In the first screen shot, if you scroll all the way to the bottom of the report, you will see "Profit for the year" this figure should match the value circled in the second screenshot.
Can you please check that?
As per screenshot it seems , Total is not calculated correctly
First row is only taken into account while calculating total
@nadarvinod In the first screen shot you are looking at the total income. In the second screen shot you are looking at "Profit for the year" that would be total income - total expenses. That is why those two values don't match.
In the first screen shot, if you scroll all the way to the bottom of the report, you will see "Profit for the year" this figure should match the value circled in the second screenshot.
Can you please check that?
Its Not Income - Expense, its only Income. Please see below
As per screenshot it seems , Total is not calculated correctly First row is only taken into account while calculating total
The first row is a group, so the first row is same as last row. Its not an issue.
I am not able to send screenshot of full table, that is creating confusion.
Can't reproduce locally. There is a high chance that this is data related issue. You can cross verify month wise totals with general ledger to locate the discrepancy.
