Found more data in table


there is just one row in sales invoice

Hi,

Can you elaborate more? What are your setup and access rights?

If the user has permission to only one sales Invoice, they can only see that record in report, while database may contain other records which user doesn’t have permission.

Thanks,

Divyesh Mangroliya

@mangroliya thanks for your response
i am the administrator so i have all permissions
i delete all the sales invoice and just stay one record

You must make sure that you have deleted the invoices items data, not just the invoices.

https://discuss.frappe.io/uploads/default/original/3X/c/3/c32aee5fb04148b45e495a7847e1546322bda066.png

This data pertains to the sales invoice items associated with the invoices you deleted.

how?
i delete the sales invoice from here
this must delete all the links like invoices items data