There is problem for every client.

Dear Experts,

There is problem for every client .....

Their inventory is valuated by FIFO method and they use Serial numbers on each and every transaction for their business.

As per the system the valuation at Delivery is taking by the FIFO method.

The customer has a requirement to get the inventory value based on the serial no. Is there any way to get out of this situation.

The Item FG001 is bought at 100 unit price with Qty 2 by having serial numbers Q1,Q2.

In the second transaction

The Item FG001 is bought at 120 unit price with Qty 2 by having serial numbers Q3,Q4.

As per the system if we create delivery document for the same item with qty 2 by giving serial number selection with qwe3 and qwe4, the system is taking the value for the items as 200.

But, my customer wants it to be as 240.

Is there any way to solve this.

Thanks & Regards

Manvendra Singh Niranjan

Edited by: Manvendra Singh Niranjan on May 6, 2009 1:28 PM