@koko , your latest post sheds more light. You had not mentioned multi-stage production. That also complicates accounting for cost of goods. Because you had all those transactions on one day, you could have had and probably did have both insufficient quantity and production stage problems, all intermixed. So read and absorb this Guide: Manage production stages | Manager. Of course, Murphy’s Law ensured that the production stage concept was also introduced in 2020, after the transactions that are causing you problems.
In the end, accurate accounting will transfer the purchase cost of all raw materials, plus any non-inventory costs, from the Inventory on hand asset account to the Inventory - cost expense account (or whatever custom accounts you may have substituted for them) as inventory is sold. Purchase invoices, payments, and production orders can all be involved in originally establishing the value of inventory in Inventory on hand. But, because Manager uses an average cost inventory valuation scheme, those costs may temporarily be routed through Production in progress. And the final transfer to Inventory - cost may be held in abeyance until the proper quantity of material has been acquired and/or produced.
Before, I wrote that “Eventually, everything work[s] out…,” but eventually could—depending on exact circumstances—mean waiting until all items involved are not only sold, but depleted in quantity to zero. Of course, that could be unrealistic, because we want to obtain correct P&L figures for current accounting periods, when goods might be in various stages of acquisition or production. That is why those two big changes were introduced.
I’m not sure what you mean by this. How do you know what is “expected?” And what do you mean by your sales invoice being up in the air and year-end inventory value being incorrect? If you have resolved all insufficient quantity and production stage issues, Manager’s balance sheet and P&L will be correct, because the two problems that previously rendered them incorrect for interim periods have been resolved. You mentioned that you had left an insufficient quantity problem in place right up until today. That has to be solved, either through purchase, production, or both. Believe me, I know these can be thorny problems to trace. But you have to do it if want correct results.
No, and also unnecessary if you resolve problems of both types I have mentioned. If you do not fix them, you are just hiding problems that will resurface later.