I noticed that when a part is invoiced it will pull the [Avg Cost ] in the warehouse it is located and not the cost that is in selected bin.
This is showing major discrepancies on invoices
We buy a part at 20qty for $15 a piece and buy it again 2000qty for $5 piece.
On the invoice if we sold the 2000 pieces for $6 the cost carried over is averaged to $10 because the 20qty.
This shows us having a net loss of $4 per piece on said invoice.
Is there a way to have it only pull cost from the bin the inventory is being pulled from?