I assume that if you drill down through Production in progress all the way to production order #14986, you will see something similar to what you saw for production order #8475, and that the final credit to zero that subaccount will be 29,040.32. That will mean that all of your current balance for inventory item #2770 was transferred from Production in progress.
So there are two “insufficient quantity” numbers to look at. One was the insufficient quantity shown for the two sales invoices in the drill-down of your second screen shot. But that is apparently not, as I thought originally, the source of your problem.
The other insufficient quantity (or quantities) was the one that resulted in the entries into the Production in progress account. That type stems not from insufficient quantities to fulfill a sales invoice, but from insufficient inventory items in a bill of materials to complete a production order. This type of insufficient quantity is not resolved by producing more finished items, but by purchasing more of the missing items on the bill of materials. See the Guide: https://www.manager.io/guides/29016.
So you will need to trace all the items on the bills of material for both production orders from original acquisition through consumption by production. I am puzzled by the fact that the two production orders for the same finished item (2770) have two different bills of material. But perhaps you have two different methods for producing the same finished item. Nevertheless, that will complicate your tracing actions.
The thing to remember is that no production order can be completed and its costs properly transferred until the average cost of all items on the bill of materials can be determined. So when you have overlapping purchases and production orders, especially including production via different methods, things are going to get complex.
Eventually, however, I believe you will find that you have a mistake on the purchasing side that left you with residual costs despite having no inventory left in stock.