Distribution - JDE1 (MOSC)

MOSC Banner

How to input only sales returns in UDC 40/AV to calculate WAC offline

edited Sep 29, 2016 5:01AM in Distribution - JDE1 (MOSC) 2 commentsAnswered

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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center