Skip to Content
0
Former Member
Feb 18, 2009 at 04:44 PM

UOM conversion for quantity not possible

489 Views

Hi,

I have a query with the following output:

Rows:

Customer number

Customer name

Material

Material Description

Columns:

Todays Order Qty: Current Date u2013 0 (Delivery Date)

Start: Current Stock (total for specified Storage locations on selection screen)

Tomorrows Order Qty (current date +1 for Delivery Date)

End: 'Start' u2013 'tomorrows order qty'

Order 1: Current Date + 2 (Delivery Date)

Order 2: Current Date + 3 (Delivery Date)

Order 3: Current Date + 4 (Delivery Date)

My problem is that the order qtys need to be displayed in CARTONS while the Stock quantities come in Base UOM. I did a unit conversion from Base UOM to CARTONS however, when I run the report I get the following message for several materials:

Quantity unit of measure KAR in quantity DataStore object UOM0MATE not available

Characteristic 0MATERIAL, Characteristic Value

No quantity conversion possible

Characteristic 0MATERIAL, Characteristic Value 000000000000475320.... this line then repeats for several materials.

This suggest that the conversions for UOM 'KAR' i.e. CARTONS is not maintained for these materials in the material master. Initial analysis suggest that these materials may be purchasing related and not order related.

Is there away I can restrict to only materials that are order related?

Any pointers welcome.

Thanks,

Milind