Invalid energy values

Hi everyone,
I occasionally find negative values on the energy dashboard, especially following problems with the electricity network or other.
in these cases I go into the sensor statistics and remove or correct the detected value.

However, I found a value that has no counterpart in the statistics, and I wanted to understand how to find it and correct it.
I also looked in the DB (copied locally on the PC), but it is really complex to locate.

The negative value is very high
The sensor in question “sensor.consumption_38” comes from a fully functional zigbee socket.

Going into the statistics of that day, however, I only see correct values

Where could I look?

thanks for the help
Lorenzo