As I said previously, you are misinterpreting the various categories. The behavior of the program changes depending on what inventory-related tabs you have enabled. Since you have Delivery Notes enabled, but not Goods Receipts, the
Qty on hand column is what is physically present—so far as Manager knows. Without Goods Receipts being enabled, the program assumes instant receipt of goods whenever you purchase them.
The Inventory Quantity by Location report tabulates goods physically present. You have the Delivery Notes tab enabled, so the program assumes nothing leaves the business until a delivery note is created. That is why you have such large quantities in the
Qty to deliver column. Based on what you have recorded, you are selling things but not delivering them.
Qty owned is not what is left on the warehouse floor. It is the count of unobligated goods in all locations. In the case of item RC1046, you have none. You have sold everything you have purchased or manufactured, but not recorded delivery of any of it.
As I said before, if you are not going to use delivery notes, you should disable that tab. All this is explained in the Guide series I linked to. It sounds like you did not read the three Guides.