Distribution - JDE1 (MOSC)

MOSC Banner

Dual UOM Cost Incorrect

edited Jun 19, 2018 10:15AM in Distribution - JDE1 (MOSC) 1 commentAnswered

1. Setup a dual-uom item, with primary UOM Grams, Secondary UOM Liters. Purchasing & Pricing UOM Liters.

2. Sales/Inventory Cost Method = 07 Standard. Enter cost as 0.0118. (This would be the equivalent of approximately 0.45/liter)

2. Setup item specific UOM conversion 1 liter = 38 grams.

3. Enter a purchase order for 1 liter (38 grams), with a cost of 0.5 / liter.

4. Receive the purchase order.

5. Check Item Ledger. Following transactions appear:

The entire amount is booked as a variance to the standard cost. The variance should have been 0.05, not .50.

When i try the same thing with significantly larger quantities, the difference is booked correctly. In the following image i tried 100 liters, with a price of 1/liter. The amounts are reflected correctly:

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