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