Cancelled Invoices still appear in General ledger and P&L

ERPNext
1

Hi, I was generating financial reports for year 2020 & I found out that few of the invoices that have been cancelled still appear in the general ledger and the P&L… I have tried to delete them as a workaround but i cannot as they are linked to the corrected versions.

Appreciate your help please.

ERPNext: v12.11.1 (version-12)
Frappe Framework: v12.9.0 (version-12)

2

Some of the reports have a checkbox to handle Cancelled Entries like General Ledger does:

image
image1160×337 28.7 KB

for which report do you want to switch off the Cancelled Entries?

3

This option is not appearing unfortunately in my ledger… Also the repetition of the sales or return invoice is affectin the P&L report!! which is very critical for the business.

Below is a screenshot of one example

image
image1212×608 41.1 KB

4

It means you’re running an older version of ERPNext, I would recommend upgrading to v13, since this is the latest one, but you can choose to update to v12 as well, make sure to have a backup file before you choose to upgrade.

5

I am on v12

ERPNext: v12.11.1 (version-12)
Frappe Framework: v12.9.0 (version-12)

6

I am currently hosted on erpnext.com to avoid update issues, I am currently on this:
image

try frappe.cloud if you find it useful :slight_smile:

7

Can you do a search for GL Entries related to those documents? Anything unusual about them?

8

I have the same issue in Purchase Invoice.

When I look at the list view, the status is ‘Cancelled’, but when I open the document and check the status in the console, it shows as ‘Paid’.
It seems that when I cancel the invoice, the status is not updated properly.

Please ensure that the document status is set to ‘Cancelled’.