Archived discussions are read-only. Learn more about Q&A or ask a question.

Return from customer movement type

Hello,

We use in our system 653 mov.type when we return goods from customer.

Usually we create the return order with reference to the original customer order and the original customer order is MTO (make to order) . When posting the 653 mov.type the system take the cost of the material (VPRS) from moving average price of unrestricted stock.

My question is : in cases that my return customer order is with reference to original customer order, is it possible to configure a movement type (or other way) that the system will take the cost from the original customer order and not from the cost in unrestricted stock and in advance it will affect the moving average price ??

I will try to explain by an example:

I have in stock 10 pieces each for 5 $,

My return order has 4 pieces that has cost of 8 $ in the original customer order.

The system behavior today after returning the stock with 653 mov type:

I have 14 pieces with cost of 5 $ - no change in moving average price and VPRS cost for profitability analysis is 5 $

The desirable behavior according to my expectations:

I will have 14 pieces with cost of (50+32)/14=5.8 u2013 the moving average will change according to cost in original customer order 8 $ and VPRS cost for profitability analysis is 8$.

I hope I made my self clear enough

Regards

Idit