Hi, I am trying to do pre dated inventory in Odoo 14 (Community) (Closing Dec'31, 2021). While updating the stock in inventory, i am stuck with same product purchased at different prices.

Example: 

A4 Paper from Company A at $3

A4 Paper from Company B at $2.75

Is there any way to ensure that the on hand stock by year end is correct in Inventory Valuation? Taking the average will affect Numbers.

P.S: I am new to Odoo.