uat template standard reports mm
DESCRIPTION
MMTRANSCRIPT
![Page 1: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/1.jpg)
BO Report name Inputs - BO TypeMM_Average_Delivery_Time_Material Calendar month/year Optional
Plant OptionalMaterial OptionalVendor Number Optional
Average delivery time Average weighted delivery timeCompression Connector_RG6 85 21
Rubber Seal (Corning And PPC)Compr tools VT 150 - PPCBlades For RG-6 & RG-11 Prep Tools 177
![Page 2: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/2.jpg)
NatureRangeRangeRangeRange
![Page 3: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/3.jpg)
BO Report name Inputs - BO Type NatureMM_Country_compariCalendar month/year Optional Range
Plant Optional RangeMaterial Optional Range
Value of goods received in local currencyAE CN DE DK ES FR
Sum 0 0 0 0 0 0
![Page 4: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/4.jpg)
Value of goods received in local currencyGB HK IN IT KP KR MY PT SG
0 0 0 0 0 0 0 0 0
![Page 5: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/5.jpg)
Value of goods received in local currency SumTW US Not assi Sum
0 0 0 0
![Page 6: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/6.jpg)
BO Report name Inputs - BO TypeMM_Extraction_Query_To_Create_Vendor_Export_File_For_D&B No parameters
Order value Invoice amount (PD)John mezzalingua Associates 89663676.95 115342554.58
CommScope 518293148.14 628680897.97
Corning Gilbert-USA 6308200.44 7886915.59
Humax Co Ltd 1479911755.9 1295041667.64
NDS Limited 1835854948.9 1916889318.54
![Page 7: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/7.jpg)
Nature
![Page 8: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/8.jpg)
BO Report name Inputs - BO TypeMM_Fulfillment_Rate_Deliveries Calendar month/year Optional
Purchasing Organization OptionalPlant OptionalMaterial OptionalVendor Number Optional
Fulfillment rate - deliveries Quantity of goods receivedTele System Electronic (M) SDN BHD 0
P.R Packagings Ltd 100 4720
Not assigned 0
![Page 9: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/9.jpg)
NatureRangeRangeRangeRangeRange
Order quantity0
47200
![Page 10: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/10.jpg)
BO Report name Inputs - BO Type NatureMM_Average_Delivery_Time_Vendors Calendar month/year Optional Range
Plant Optional RangeMaterial Optional RangeVendor Number Optional Range
Average delivery time Average weighted delivery timeJohn mezzalingua Associates 146 5
CommScope 44 7
![Page 11: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/11.jpg)
BO Report name Inputs - BO Type NatureMM_Number_Of_Vendors_Per_Material Calendar month/year Optional Range
Day Interval Optional Range
Purchase Order Value Number of VendorsISOCABL006 : Coaxial Cable - RG6 6828439.99 1
ISOCONN006 : Compression Connecto 1555651.02 1
ISODISH006 : Dish 60 6073.5 1
![Page 12: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/12.jpg)
BO Report name Inputs - BOMM_Order_Values Calendar month/year
PlantMaterial
Purchase Order ValueDUMMY ITEM WITHOUT BATCH/VALUATION TYPE 153989.65
Dish 60 15654555.5
![Page 13: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/13.jpg)
Type NatureOptional RangeOptional RangeOptional Range
![Page 14: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/14.jpg)
BO Report name Inputs - BO Type NatureMM_Ordering_Activities Calendar month/year Optional Range
Plant Optional RangeMaterial Optional RangeVendor Number Optional Range
Number of purchase orNumber of rNumber of Number of Number of Total itemsDUMMY ITEM WITHOU 1 0 0 0 0 1
![Page 15: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/15.jpg)
Number of dDeliveries as proportion of aggregate items5 5
![Page 16: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/16.jpg)
BO Report name Inputs - BOMM_Overall_And_Mean_Purchase_Order_Value Calendar month/year
PlantMaterialVendor NumberMaterial GroupPurchasing Organization
Purchase Order ValueDUMMY ITEM WITHOUT BATCH/VALUATION T 137795.65
![Page 17: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/17.jpg)
Type NatureOptional RangeOptional RangeOptional RangeOptional RangeOptional RangeOptional Range
Mean Purchase Order Value137796
![Page 18: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/18.jpg)
BO Report name Inputs - BO TypeMM_Price_Trends_Over_Last_Three_Months Purchasing Organization Optional
Material OptionalPlant OptionalLast 3 months including current month OptionalMaterial group OptionalVendor Number Optional
PriceJUN 2009
IT - Others IT [email protected]%IT - EDP Consumables IT VAT@4% 1100
IT - RAM IT VAT@4% 1355.48
IT - Hard Disk IT VAT@4%IT - Laptop Battery IT VAT@4% 4406.35
IT - Others IT VAT@4%
![Page 19: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/19.jpg)
NatureRangeRangeRangeRangeRangeRange
Price SumJUL 2009 AUG 2009 Sum
1828.13 1828.131716 2816
1598.83 2954.312824.92 2824.924412.57 8818.92
600.36 600.36
![Page 20: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/20.jpg)
BO Report name Inputs - BO TypeMM_Purchase_Order_Quantities Calendar month/year Optional
Plant OptionalMaterial OptionalVendor Number Optional
Order quantity Quantity of goods receivedDUMMY ITEM WITHOUT BATCH 4720 4720
Dish 60 0 0
Amplifier Power supply 1.2 A 0 0
![Page 21: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/21.jpg)
NatureRangeRangeRangeRange
Difference between PO quantity and GR quantity Invoice receipt quantity as at posting date0 00 00 0
![Page 22: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/22.jpg)
GR quantity as proportion of ordered quantity Invoiced quantity as proportion of ordered quantity100 0
![Page 23: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/23.jpg)
BO Report name Inputs - BO TypeMM_Quantities_PO_Delivery_Invoice Calendar month/year Optional
Plant OptionalMaterial OptionalVendor Number Optional
Order quantity Actual goods receipt quantityTele System Electronic (M) SDN BHD 0 0
P.R Packagings Ltd 4720 4720
Not assigned 0 0
![Page 24: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/24.jpg)
NatureRangeRangeRangeRange
Invoiced quantity Open PO Quantity Open invoice quantity0 0
4720 0 00 0 0
![Page 25: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/25.jpg)
BO Report name Inputs - BO TypeMM_Values_Purchase_Order_Delivery_Invoice Calendar month/year Optional
Plant OptionalMaterial OptionalVendor Number Optional
Purchase Order Value Value of goods receivedTele System Electronic (M) SDN BHD 0 0
P.R Packagings Ltd 137795.65 137795.65
Not assigned 0 0
![Page 26: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/26.jpg)
NatureRangeRangeRangeRange
Invoice Value0
137631.60
![Page 27: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/27.jpg)
BO Report name Inputs - BO TypeMM_Variance_Goods_Receipt Calendar month/year Optional
Plant OptionalMaterial OptionalVendor Number OptionalPurchasing Organization Optional
Price variance, GR value Quantity variance, GR valueTele System Electronic (M) SDN BHDP.R Packagings Ltd 0 0
Not assigned
![Page 28: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/28.jpg)
NatureRangeRangeRangeRangeRange
Purchase Order Value Value of goods received in local currency0 0
137795.65 137795.650 0
![Page 29: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/29.jpg)
BO Report name Inputs - BO Type NatureMM_Purchasing_Group_Analysis Calendar month/year Optional Range
Vendor Number Optional RangePurchasing Organization Optional RangePurchasing Group Optional Range
Number of requests for quoNumber ofNumber oNumber of Number of SPG 0 0 0 5 6
Sum 0 0 0 5 6
![Page 30: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/30.jpg)
No. of PurcNumber of Number of Number of Number of Number of Number of dEffective p Invoice amount4 0 0 0 0 0 3 17782390 241035754 0 0 0 0 0 3 17782390 24103575
![Page 31: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/31.jpg)
Invoice amount
![Page 32: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/32.jpg)
BO Report name Inputs - BO Type NatureMM_Vendor_Comparison Calendar month/year Optional Range
Vendor Number Optional RangePurchasing Organization Optional RangeMaterial Group Optional Range
Order quantity Purchase Order Value Invoice ValueP.R Packagings Ltd 4720 137795.65 137631.6
![Page 33: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/33.jpg)
Delivery Value Invoice Value (%) Open order value in made out invoice Received purchase order value (%)137795.65 100 164.05 100
![Page 34: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/34.jpg)
Received purchase order value (%)
![Page 35: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/35.jpg)
BO Report name Inputs - BO Type NatureMM_Purchasing_Group_analysis_quantities Purchasing Organization Optional Range
Purchasing Group Optional RangeCalendar month/year Optional Range
RFQs RFQ items Purchase oCPG JUL 2008 0 0 67
AUG 2008 0 0 77
Sub-total 0 0 144
SPG JUL 2008 0 0 3304
AUG 2008 0 0 3323
Sub-total 0 0 6627
![Page 36: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/36.jpg)
Purchase ORFQ items per purchase order item183 0277 0460 0
13806 015226 029032 0
![Page 37: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/37.jpg)
BO Report name Inputs - BO TypeMM_Purchasing_Group_analysis_values Purchasing Organization Optional
Purchasing Group OptionalCalendar month/year Optional
Purchase Order ValueCPG JUL 2008 196970033
AUG 2008 128606681.03
Sub-total 325576714.03
SPG JUL 2008 479917579.91
AUG 2008 572534657.34
Sub-total 1052452237.25
![Page 38: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/38.jpg)
NatureRangeRangeRange
Invoice amount Average purchase order value189707796.18 2939851.24122432712.62 1670216.64
312140508.8 2260949.4483940745.64 145253.5632502607.16 172294.511116443352.8 158812.77
![Page 39: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/39.jpg)
BO Report name Inputs - BO Type NatureMM_Average_stock_Value_Over_Time Date Optional Range
Plant Mandatory SingleCalendarYear/Week Optional RangeCalendarYear/Month Optional RangeMaterial Optional Range
Average Stock Value27.2008 95506067.23
28.2008 95531765.66
29.2008 95623164.48
30.2008 95628016.04
31.2008 95558703.69
32.2008 95506719.43
33.2008 95506719.43
34.2008 95506719.43
35.2008 95585459.8
Average 95550370.5766667
![Page 40: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/40.jpg)
BO Report name Inputs - BO TypeMM_Receipt_And_Issue_Quality_Inspection_stock NoParameters
Q stock Receipt Qty: QualityMW-Delhi 0 0
MW-Kanpur 0 0
MW-Mohali 0 0
MW-Kolkata 0 0
MW-Ahmedabad 0 0
MW-Bangalore 0 0
![Page 41: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/41.jpg)
Nature
Issue Qty: Quality000000
![Page 42: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/42.jpg)
BO Report name Inputs - BO Type NatureMM_Receipt_And_Issue_Stock_in_Transit No Parameters
Stock in TransReceipt QtyIssue Qty.: Stock in TransitMW-Delhi -2212653 250000 2212653
MW-Kanpur 0 0 0
MW-Mohali -1104 0 1104
MW-Kolkata -14870907 23482 15111044
MW-Ahmedabad -10813819 78336 12662051
![Page 43: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/43.jpg)
BO Report name Inputs - BO Type NatureMM_Scrap No parameters
Issue Value: Proportion Issue QuantProportion of Total Stock QuantityMW-Delhi 0 0 0 0
MW-Kolkata 200332.34 0.09296 24870 0.23448
MW-Ahmedabad 0 0 0 0
MW-Bangalore 0 0 0 0
MW-Chennai 4161476.08 1.30171 741533.2 13.31678
![Page 44: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/44.jpg)
BO ReportInputs - B Type NatureMM_Stock_INo Parameters
Q Stock Stock in QuStock of MaReturnable Packaging Stock at Customer in QMW-Delh 0 0
MW-Kanp 0 0
MW-Moha 0 0
MW-Kolk 0 0
MW-Ahm 0 0
![Page 45: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/45.jpg)
BO Report name Inputs - BO Type NatureMM_Stock_In_Transit No Parameters
Stock in TransitMW-Delhi -2212653
MW-Kanpur 0
MW-Mohali -1104
MW-Kolkata -14870907
MW-Ahmedabad -10813819
MW-Bangalore -103235
![Page 46: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/46.jpg)
BO Report name Inputs - BO Type NatureMM_Stock_Overview_Materials Date Optional Range
Plant Mandatory SingleCalendarYear/Week Optional RangeCalendarYear/Month Mandatory RangeMaterial Optional Range
Quantity Total StockDUMMY ITEM WITHOUT BATC 4720
Coaxial Cable - RG6 1751095
Compression Connector_RG6 0
D- CLAMP 24500
![Page 47: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/47.jpg)
BO Report name Inputs - BO Type NatureMM_Stock_Overview_Over_time Date Optional Range
Plant Mandatory SingleCalendarYear/Week Optional RangeCalendarYear/Month Optional RangeMaterial Optional Range
Quantity Total Stock27.2008 1745435
28.2008 1748935
29.2008 1750155
![Page 48: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/48.jpg)
BO Report name Inputs - BO TypeMM_Valuated_Stock(As Of 3.1 Content) No Parameters
Quantity Total Stock Valuated Stock QtyMW-Delhi 1995435 1995435
MW-Kanpur 8 8
MW-Mohali -994 -994
MW-Kolkata 10581750.835 10581750.835
![Page 49: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/49.jpg)
Nature
Receipt Quantity, Valuated Stock Issue Quantity, Valuated Stock Receipt Total Stock4922624 2677189 4922624
8 0 81120 2114 1120
52209234.885 37052460.55 52209234.885
![Page 50: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/50.jpg)
Issue Total Stock Value of Valuated Stock Receipt Value, Valuated Stock2677189 95673935.44 157741649.99
0 179376 1793762114 5406.85 488717.88
37052460.55 215291983.22 765221965.05
![Page 51: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/51.jpg)
Issue Value, Valuated Stock60964084.41
0482986.03
508867937.17
![Page 52: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/52.jpg)
BO Report name Inputs - BO TypeMM_Stock_Overview_as_of_3.1_Content No parameters
Quantity Total Stock Valuated Stock QtyMW-Delhi 1995435 1995435
MW-Kanpur 8 8
MW-Mohali -994 -994
MW-Kolkata 10581750.835 10581750.835
MW-Ahmedabad -6580888 -6580888
MW-Bangalore 86988 86988
![Page 53: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/53.jpg)
Nature
Value of Valuated Stock Q Stock Stock in Transit Blocked St Consignment Stock Qty95673935.44 0 -2212653 0 0
179376 0 0 0 05406.85 0 -1104 0 0
215291983.22 0 -14870907 100653 018480609.68 0 -10813819 25859 0
4119775.05 0 -103235 0 0
![Page 54: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/54.jpg)
BO Report name Inputs - BO Type NatureMM_STD_Inventory_AKey Date of The Query Mandatory Single
Material Range Optional Range
Material
DUMMY DUMMYCW-Bhandup 2006DEGILINK
DUMMY DUMMYCW-Kirti Nagar 2006DEGILINK
Plant
Calendar Year
Inventory Aging
![Page 55: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/55.jpg)
BO Report nam Inputs - BO Type NatureMM_Warehouse_SNo Parameters
Material Material Plant
DUMMYITEM1 MAR 2009 MW-Delhi 0.00 INR
ISOCABL006 Coaxial Cable - RG6 MAR 2009 MW-Delhi 12,440,147.91 INR
Calendar Year/Month
Value of valuated stock
Quantity Received into Valuated Stock
DUMMY ITEM WITHOUT BATCH/VALUATION TYPE
![Page 56: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/56.jpg)
0OBSOLETE_% 0OBSOLETEVAL
0.00 INR
100.00000% 12,440,147.91 INR
Quantity Issued from Valuated Stock
Value issued from valuated stock
Value Received into Valuated Stock
Variance : Quantity
Variance : Value
![Page 57: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/57.jpg)
BO Report name Inputs - BO Type NatureMM_STD_Days_Supply Key Date of The Query Mandatory Single
Material Range Optional Range
Material
CW-Bhandup Apr-06 0
Plant
Calendar Year/Mon
th
Material Range of Coverage in Days
DUMMY DUMMY DEGILINK
![Page 58: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/58.jpg)
BO Report name Inputs - BO Type NatureMM_Demand_Supply_Match No Prameters
ValIssValStock ValStckRecValue ValStockValue29.2009 140730968.23 158793784.54 -20000831.67
30.2009 210499996.7 1984632883.9 1754132055.53
31.2009 254267706.96 269780607.89 1769644956.46
32.2009 137715144.63 191024968.67 1822954780.5
![Page 59: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/59.jpg)
BO Report name Inputs - BO Type NatureMM_STD_Inventory_TurnKey Date of The Query Mandatory Single
Material Range Optional Range
Material Plant
DUMMYDIGI1 1400 2007 -1.07DUMMYDIGI1 9800 2007
Calendar
Year
Inventory Turnover
![Page 60: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/60.jpg)
BO ReportInputs - B Type NatureMM_Stock_Key Date Mandatory Single
Material Optional Single
Material
Apr-06 0 EA 0 EA 0 EA
Apr-06 -1,273 EA -2,407 EA 0 EA
Apr-06 5 EA 0 EA 0 EA
Apr-06 0 EA 0 EA 0 EA
Plant
Calendar Year/Mon
th
Quantity Total Stock
Blocked stock
Quantity of
consignment stock
Dish 60Corporate Plant
Dish 60CW-Bhandup
Dish 60
CW-Chandigarh
Dish 60CW-Vadodara
![Page 61: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/61.jpg)
0 EA 0 INR 0 EA
0 EA -565,296.06 INR 31,900 EA
0 EA 2,101.05 INR 0 EA
0 EA 0 INR 0 EA
Stock in quality
inspection
Value of valuated
stock
Stock in transit
![Page 62: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/62.jpg)
BO Report name Inputs - BO Type NatureMM_Stock_Overview_extended Calendar year Optional Range
Day interval Optional RangeMaterial Optional RangeMaterial type Optional RangePlant Optional RangeCalendar year/month Optional Single value
Plant Quantity Total Stock Q Stock
1001 1,746,485 * 95,506,719.43 INR 01002 8 EA 179,376 INR 01003 -994 EA 5,406.85 INR 01004 6,103,296.09 * 58,228,215.01 INR 0
ValStockValue
![Page 63: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/63.jpg)
EA -2,462,653 * 0 EA 0 EA ### *EA 0 EA 0 EA 0 EA 179,376 EAEA -1,104 EA 0 EA 0 EA 6,525.14 EAEA -13,264,603 * -37,832 * 0 EA ### *
Stock in Transit
Blocked Stock
Consignment Stock Qty
Average Stock Value
![Page 64: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/64.jpg)
5,834.88 1,301,097 * 3,059,683 *0 0 EA 0 EA
1,760.87 2,050 EA 1,050 EA90.3792 ### * ### *
Material Range of Coverage in Days
Issue Total Stock
Receipt Total Stock
![Page 65: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/65.jpg)
BO Report name Inputs - BOMM_Warehouse_Stock_Analytics_Inventory_turnover Current calendar year - 1
5800Material
ISOCABL006
ISOCONN006
ISODISH060
ISOULNB001
![Page 66: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/66.jpg)
Type NatureOptional Single Value
Inventory Turnover
Coaxial Cable - RG6 -2.2239
Compression Connector_RG6 3.2306
Dish 60 -1.9074
Single Universal LNB -2.9817
![Page 67: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/67.jpg)
BO Report name Inputs - BO Type NatureMM_Valuated_Stock Key Date Mandatory Single
Material Optional Single
Material Plant
ISODISH060 1001 4.2006 10 10 0 115,220.99 4,087.495.2006 122 112 0 161,302.14 46,081.156.2006 152 3,032.00 3,002.00 175,831.14 1,184,930.91
Calendar Year/Mon
th
Quantity Total Stock
Receipt Quantity
Total Stock
Issue Quantity
Total Stock
Value of valuated
stock
Value Received
into Valuated
Stock
![Page 68: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/68.jpg)
00
1,170,401.91
Value issued from
valuated stock
![Page 69: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/69.jpg)
Sr. No. Infoprovider11 0PUR_C011213141516171819202122232425 0PUR_C0426 0PUR_C0127 0PUR_C042851 0IC_C035253545556575875 0IC_C03767778 0IC-MP0486 0IC_C0387 0IC_C0388 0IC_C0389 0IC_C0390 0IC_C0391 0IC_C0392 0IC_C0393 0IC_C03
![Page 70: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/70.jpg)
Desc query
Average delivery time - material ZPUR_C01_Q0005Average delivery time - vendors ZPUR_C01_Q0001Country comparison - raw materials - GR value ZPUR_C01_Q0014Extraction query to create Vendor-Export file for D&B ZPUR_C01_DB_Q04Fulfillment rate - deliveries ZPUR_C01_Q0003Number of Vendors per Material ZPUR_C01_Q0021Order values ZPUR_C01_Q0015Ordering activities ZPUR_C01_Q0012Overall and Mean Purchase Order Value ZPUR_C01_Q0023Price trends over last three months ZPUR_C01_Q0019Purchase order quantities ZPUR_C01_Q0011Quantities: PO - delivery - invoice ZPUR_C01_Q0017Values: Purchase order - delivery - invoice ZPUR_C01_Q0004Variances, goods receipt ZPUR_C01_Q0018Purchasing group Analysis ZMMPUR_C04_Q01 Vendor comparison (purchasing values) ZPUR_C01_Q0013Purchasing group analysis - quantities ZPUR_C04_Q0003Purchasing group analysis - values ZPUR_C04_Q0002Average Stock Value Over Time 0IC_C03_Q0031Receipt and Issue Quality Inspection Stock 0IC_C03_Q0002Receipt and Issue Stock in Transit 0IC_C03_Q0004Scrap 0IC_C03_Q0020Stock in Quality Inspection 0IC_C03_Q0007Stock in Transit 0IC_C03_Q0008Stock Overview: Materials 0IC_C03_Q0030Stock Overview Over Time 0IC_C03_Q0032Warehouse Analytics - Obsolescence and Variance ZIC_C03_Q0025_BO
Valuated Stock (as of 3.1 Content) ZIC_C03_Q0015_BOStock Overview (as of 3.1 Content) ZIC_C03_Q0013_BO
Warehouse Analytics - Obsolescence and Variance ZIC_MP04_Q0004_BO
Inventory Aging 0IC_C03_Q0021Days' Supply 0IC_C03_Q0018Demand Supply Match 0IC_C03_Q0023Inventory Turnover 0IC_C03_Q0017Stock Overview 0IC_C03_Q0012Stock Overview - extended 0IC_C03_Q0022Warehouse Stock Analytics – Inventory Turnover ZIC_C03_Q0024_BOValuated Stock ZIC_C03_Q0006_BO
![Page 71: UAT Template Standard Reports MM](https://reader035.vdocuments.us/reader035/viewer/2022062301/55cf8f5c550346703b9b9169/html5/thumbnails/71.jpg)
ModuleMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM