Skip to Content
0
Former Member
Sep 25, 2008 at 11:49 PM

Batches and Cost

50 Views

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