Lot wise cost issue
Hi.
We create items with Lot enable of an Inventory Organization which is AVG-Costing.
Require to record item + lot based consumption instead of only item based.
Case- if Lot-1 of item-1 is reced 10 pcs. @ $100.- And the next Lot-2 of same Item-1 is received 10 Pcs. @ $105.- So the AVG cost of 20pcs. would be $102.5.
While move order transact for 5 pcs. from lot no. 1; currently the item consume with $ 102.5, even we require consumption should be made according to the cost of LOT being issued i.e. to the consumption need to change @$100.- not with 102.5
How this could be done; Please guide. Thanks
0