Hello All,
We are presently using batch and FIFO method of valuation.
We are having problems getting an exact gross profit. When we select a batch, it should also select the cost associated with that batch, but it does not, it selects the FIFO cost. Does anyone know a way that we can get the cost based on the selected batch and not on a FIFO method. I know that standard will not work nor will Moving average.
Here is an example
Batch 1 - ABC @ 10$
Batch 2 - ABC @ 20$
When I make an Invoice for item ABC, select Batch 2, my cost should be 20 not 10. Right now it will go and retrieve the Batch 1 cost even if I select that the items come from Batch 2.
Thanks in advance.
Sophie