Cost Management - EBS (MOSC)

MOSC Banner

Since consigned item does not update the average cost of an item, we cannot calculate correct Sellin

edited Feb 25, 2014 12:00PM in Cost Management - EBS (MOSC) 1 commentAnswered

Let's say we bought/received 3 different phases;

1. Bought 10 qty at 6 USD - 1-Jan-14 (Not on Consignment) - Average Cost Price = 6

2. Bought 10 qty at 4 USD - 10-Jan-14 (Not on Consignment) - Average Cost Price = 5

3. Bought 40 qty at 2 USD - 25-Jan-14 (On Consignment) - Average Cost Price should become 3 but it will remain 5 only since we bought/received the last delivery on consignment.

We calculate our selling price as 30% above our system cost price. But because of enabling consignment feature our selling prices are incorrectly higher.

How do we make sure that our average cost price gets updated even for consigned items so that our selling price calculations are correct.

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