How to input only sales returns in UDC 40/AV to calculate WAC offline
Hi folks,
I need the calculation of the weighted average cost only for items with cost method=02 (in my company these are purchased items) on the following scenarios: receiving, amount inventory adjustments, inbount transfers between branches and sales returns, i.e. only for selected inventory inbound transactions.
So, I made the following:
1. Set the system to calculate weighted average cost off-line on system constants.
2. Change the UDC 40/AV to calculate weighted average cost for apropriate programs
3. Run R41811
As result the calculation was done not only for sales returns but also for items sold. I suppose the reason is because the program that processes sales orders and sales returns is the same: R42800 (I relieve inventory with R42800).