STOCK REPORT
Process Overview
| Field | Details |
|---|---|
| Process Name | Stock Report |
| Segment | GSC – Global Supply Chain |
| Process Family | Lenovo India |
| Process Users | Wyzmindz Solutions Pvt Ltd |
| Process Purpose | Provides actionable insights, tracks performance, and supports Lenovo’s sales strategies |
Version History
| Version Tag | Prepared By | Date of Update | Validated By | Reviewed By | Approved By | Revision Details |
|---|---|---|---|---|---|---|
| V 1.0 | Goutham | 22-12-2025 | Navneeth | Sushruth Vasista | Vishwanath Mosale | SOP Document Creation |
Distribution & Access List
| Designation | Read | Write | Approval |
|---|---|---|---|
| Analyst | Yes | No | No |
| Team Lead | Yes | Yes | No |
| Manager | Yes | Yes | Yes |
1.1 Purpose
The purpose of this process is to generate, validate, and publish the daily Lenovo Stock Report by consolidating inputs from multiple data sources, performing required data cleansing, mapping, and validation, and ensuring accurate reporting to the concerned CC and business stakeholders. This process supports analytics, business planning, and operational decision-making.
1.2 Scope
- Geographic Scope: India.
- Business Segment: GSC
- Process Frequency: Daily
- Preparing daily CON, SMB, and ECOM summary sheets and cross-verifying them with the final outputs.
- Distributing the final validated Stock Report and associated summaries.
1.3 Business/Segment Overview
The stock data spans multiple product categories such as Notebooks, Desktops, Workstations, Tablets, Raw Materials, Services, and Refurb products. These are mapped to corresponding business segments including CON, SMB, WEB-CON, WEB-SMB, WEB-TAB, MFGRM, Services, and No-Map categories. The report output helps Lenovo track inventory position, distribution center (SLOC) attributes, DOA cases, commodity segmentation, and business classifications to support supply chain, sales, and operational teams.
1.4 Responsibility and authority
| Role | Name |
|---|---|
| Analyst | Gautham |
| Process Owner | Navaneeth |
| Process Manager | Dayanand |
| Escalation Manager | Sushruth Vasista |
| Approval Authority | Vishwanath Mosale |
1.5 Escalation Matrix
Escalation Matrix – WyzMindz Solutions Pvt Ltd (India)
| Sl. No | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Sushruth Vasista | Manager | sushruth.vasista@wyzmindz.com |
| 2 | Vishwanath Mosale | Director | vishwanath.mosale@wyzmindz.com |
Escalation Matrix – Lenovo India Pvt Ltd
| Sl. No | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Abhinav Tiwari | Mgr II, Order Fulfillment - AP CF Team | atiwari2@lenovo.com |
| 2 | Ananda M Lanka | Head - India Order Fulfilment & Order Center GSC - AP PC Customer Fulfillment & Logistics | analanka@lenovo.com |
1.6 RACI Matrix
RACI – WyzMindz Solutions Pvt Ltd (India)
| Report / Process | Responsible | Accountable | Consultation | Informed |
|---|---|---|---|---|
| Stock Report | Goutham | Goutham | Navaneeth K | Lenovo India Pvt Ltd, Wyzmindz – Lenovo Process Team |
1.7 Access Required
• Outlook & Webmail Access • Access to Ms Office Suite • Access to corporate website (Supporting Documents will be stored there in the future) Website: www.example.wyzminz
1.8 Overview of Tools
Overview of Tools
| Sl No | Tool Name | URL | Description |
|---|---|---|---|
| 1 | SAP | Application | It’s used to extract data for our usage using T code. |
1.9 Legends
- MTM - Machine Type Model (Product Number)
- NA: Not Available
- SAP :
1.10 Data Dependencies
- SAP application – Access to T-code (Mention the T-Code name).
1.11 Schedule of Reporting
- Frequency: Daily.
1.12 Process Flow Chart
1.13 Steps of Procedure
- Now take Stock Report and Closed Order Report and paste it in Server 1 Path: D:\i-Rainbow\StockClose.
- Now from open yesterday’s Stock File present in the folder and open today’s stock file
- In yesterday’s stock file leave 10 lines and delete all lines and paste today’s data and copy formats from yesterday’s data to today’s data and delete the 10 lines leaving header and rename the file to today’s date
- EX: Stock Report May-26 stock Report May-27
- Do the same process for closed Order Report
- And run the REL TO QVD qw present in the same folder and save and exit
- Now open present day’s CFOC dump and in distribution channel column select 31 and then in storage location select blanks and change it to L920
- And now remove filters and select IN5A in plant column and then in storage location column select blanks and change them to L90X
- Now remove filters once again and select blanks in storage location and change them to L908.
- Remove filters and save the file
- Now copy CFOC Dump and Stock Revenue file and paste it in server 2 path : C:\i-Rainbow\Input FF\Mapping and delete yesterday’s CFOC Dump and Stock Revenue and paste today’s files.
- Now run Stock Report_Shiva all v2 Sample.qvw from path: C:\Users\Reports GSCSI\Desktop\Stock Report Sample
- And now run the qw and check if the value shown in qw
- Should match the value of the sum of the below columns from Stock Report
| Unrestr. | Trans./Tfr | Qual.Insp. | Restricted | Blocked | Returns |
|---|---|---|---|---|---|
- Now in the qw scroll down to the last and then select the last table SR.Unrestricted and right click and press send to excel and save the file as Stock_Report_ddmmyyyy
- In the file remove SR. from headers
- Now select the last 3 table i.e RAW and then right right click and press send to excel and save the file as Raw month-DD
- Save both the files in Binary format XSLB
- Dollar value has to be updated at the first of every month and dollar value should be asked via mail to Arun Selvaraj.
- Now open the following files-today’s Stock Report-ddmmyyyy, yesterday’s Stock Report ddmmyyyy,FG aging file,Con base file,DOA(data extracted from FG AGING File),BOOK 4(contains MTM’s to be mapped to CON),Stock BIZ mapping file
- TO make DOA File, open FG file insert a column and then concat material and plant code and storage location and apply to the whole column
- Now search for DOA indicator column and select DOA from filter, now Copy 4 columns
| Material | Plant Code | Storage Location | Material | Brand | OH Product Segment |
|---|---|---|---|---|---|
- And paste it into a new workbook and save it as DOA
- FG file will be given every week by Prashant sir
- Copy brand and oh product segment and paste it next to material.
Steps for commodity mapping
- Now open Today’s Stock Report and insert a column next to commodity column and map it with material from stock report and FG aging file material with brand column and then break link
- Now select blank and #N/A from the inserted column and then map it with yesterday’s stock file using material and map commodity.
- Now remove filter and check for #N/A,if present see descriptions if its Desktop or DT map it as Desktop, if its NB WS map it as Workstation_NB, if Thinkstation map it as Workstation_DT, map rest NB to notebook,
- For other #N/A see storage location ,if L915 map to services and if plant is i210 and i220 map it to raw material, if its tablet map it to tablet
- For other #N/A refer yesterday’s stock file and MAP
- Now change the column name to commodity and delete the Original commodity column
Steps for stock biz mapping:
- Now insert 2 columns to the right of BIZ column
- In that column map biz using MTMPLANTSLOC from yesterdays stock file
- Break links
- Now filter down and select #N/A and in the second inserted column map using MTMPLANTSLOC from STOCK BIZ Mapping file(which needs to updated everyday from yesterday’s stock file, by pasting MTMPLANTSLOC, BIZ, Commodity and removing duplicates)
- Now break link and filter down and select every biz present one by one and map the #N/A to their respective mapped biz.
- Check mail there will be a mail from amit surve to tag no map cases to smb, map them to smb based on MTMPLANTSLOC
- Next from CON BASE File and BOOK 4 file map all the #N/A and NO Map cases to Con and Web-Con if SLOC is L920 based on Material
- Next remove filters
- Now select #N/A and see SLOC if L920 is there select it and map it to FG Aging file product segment using Material and map them to WEB SMB ,WEB CON, WEB TAB based on the mapping
- Now select L915 and Map to services
- In Plant select I210 and I220 and map them to MFGRM
- Map rest #N/A to no map if you don’t know storage location.
- Delete original biz column and name first inserted column as biz
- Now select no map from BIZ and in nature select DOA and map them from DOA File based on MTMPLANTSLOC
- In material DESC search for (Refurb and Re furb) and change the BIZ to REFURB.
Pivot Tables
- Copy pivot tables from yesterday stock file and paste it in today’s file and refresh the data
- Now in ECOM PIVOT sheet add sloc to Columns and select DCFS L908 and L90X
- Now in BIZ select CON and copy entire data and paste it in new sheet and rename as CON
- Now select SMB and deselect CON and entire data and paste it in new sheet and rename as SMB
- Now remove SLOC
- Select WEB-CON and WEB-SMB and paste it in new workbook
- Select WEB-TABLET and paste it adjacent to WEB-CON and WEB-SMB as shown below, rename it as ECOM.
- Now in CON sheet add blocked and unrestricted column and map them through Material from Blocked&Unrestricted sheet
- Now apply borders to CON,SMB and ECOM workbook sheet and align them and change the header colors as shown in image.
- Cross verify and flash the data.
- To cross verify check if the numbers from CON,SMB and ECOM are matching with FINAL SHEET.
1.14 Output Overview
The Stock Report output provides the validated daily inventory position across all product categories and storage locations. It includes updated commodity, BIZ, DOA, and ECOM mappings along with unrestricted, blocked, restricted, and other stock types. Segment-wise summaries (CON, SMB, ECOM) are generated for business visibility. Raw stock and final mapped files are also produced for supply chain and analytics use. All updated files are shared to designated servers for downstream reporting.
1.15 Validation checklist
- For SLoc L915 Biz and commodity should be services.
- For SLoc L920 Biz should be CON-WEB, SMB-WEB, TAB-WEB also NO MAP & Refurb can be present.
- FOR I1210 and I1220 it should be MFGRM.
1.16 Communication
A mail will be sent to below recipients. Stock Report-{ Aanchal Uppal auppal@lenovo.com; Abhinav Tiwari2 atiwari2@lenovo.com; Abhishek Chaudhary achaudhary@lenovo.com; Aditya Agarwal aagarwal@lenovo.com; Amisha Jain23 ajain23@lenovo.com; Amit Chatrath chatratham@lenovo.com; Amit E Surve amitsurv@lenovo.com; Amit Sundriyal as13@lenovo.com; Amrinder Sandhu asandhu@lenovo.com; Ananda M Lanka analanka@lenovo.com; Angel Prescilla Jeanpierre2 ajeanpierre2@lenovo.com; Anuraj R5 ar5@lenovo.com; Ashish Bhatnagar abhatnagar@lenovo.com; Athulya C6 ac6@lenovo.com; Charles Rabi crabi1@motorola.com; Debashish Bhadra dbhadra@lenovo.com; Dejo Mathew dmathew@lenovo.com; Dhruv Bansal1 dbansal1@lenovo.com; Donnel Varkey dvarkey@lenovo.com; 'fulfillment.c@wyzmindz.com'; Ganesh S gs@lenovo.com; Gopal Rotti grotti@lenovo.com; Hemanth Kumar S1 hs1@lenovo.com; Hiral Somaiya hsomaiya@lenovo.com; J Leslie jleslie@lenovo.com; Jubin Mahajan jmahajan@lenovo.com; Jyoti Deswal jdeswal@lenovo.com; Kalpesh Chande kchande@lenovo.com; Kuhel Chowdhury1 kchowdhury1@lenovo.com; Kumar Krishna kkrishna@lenovo.com; Lalit Kumar5 lkumar5@lenovo.com; Gayathri R3 gr3@lenovo.com; Gifty Boparai gboparai@lenovo.com; Lalit Sonvarrsa lsonvarsha@lenovo.com; Manisha Sharma12 msharma12@lenovo.com; Marlene Pinto mpinto4@lenovo.com; Megha Y1 my1@lenovo.com; Mithun Gosavi mgosavi@lenovo.com; Mohan Kumar P2 mp2@lenovo.com; Mohanraj Selvaraj mselvaraj1@lenovo.com; Mohhan KS mks@lenovo.com; Murali J mj@lenovo.com; Nakul Gola ngola@lenovo.com; Nanthini Muthukumar nmuthukumar@lenovo.com; Nikhil Narkhede nnarkhede@lenovo.com; Nishant Mittal nmittal@lenovo.com; Nithya Varun Kumar11 nkumar11@lenovo.com; Pankaj Gupta1 pgupta1@lenovo.com; Pondicherry Distribution Coordinator_India pondidis_in@lenovo.com; Pondicherry FG Coordinator_India pondfgco_in@lenovo.com; Prabhakaran Devaraj pdevaraj@lenovo.com; Mahaboob Dowla1 mdowla1@lenovo.com; Prasanth Govindan pgovindan@lenovo.com; Prashanth K R prashanthkr@lenovo.com; Puneet Garg1 pgarg1@lenovo.com; Punith Reddy5 preddy5@lenovo.com; Raja Manikandhan rmanikandha1@lenovo.com; Rajesh SN rsn@lenovo.com; Rajkumar Bhatt rbhatt@lenovo.com; Rakesh Sivaraman rsivaraman@lenovo.com; Ram Prasad Reddy mreddy2@lenovo.com; Ramesh R rameshr@lenovo.com; Ravikumar K Kanakarajan rkanakar@lenovo.com; Rini Jennifer G4 rg4@lenovo.com; Rishabh Rawat rrawat@lenovo.com; Rohit Deshkar rdeshkar@lenovo.com; Sampada Joshi sjoshi6@lenovo.com; Saqib Jameel sajameel@lenovo.com; Saurabh Mishra12 smishra12@lenovo.com; Subodh Deshpande sdeshpande@lenovo.com; Shanil Madollathil shamadol@lenovo.com; Shashi Bhushan sbhushan@lenovo.com; Shrihari R sr17@lenovo.com; Sorabh Goel Jain9 sjain9@lenovo.com; Sukhmit Singh Chawla schawla@motorola.com; Sunil Mir1 smir1@lenovo.com; Sushruth Vasista svasista@lenovo.com; Suyash Singh15 ssingh15@lenovo.com; T Renganathan trenganathan@lenovo.com; Tarun Sharma tsharma2@lenovo.com; Vaibhav Chitalia vchitalia@lenovo.com; Venkat Ramani R vr@lenovo.com; Vikas Malhotra vmalho@lenovo.com; Vikram Mulye vmulye@lenovo.com; Vishwanath B Kamath vkamath@lenovo.com; Yuthika Dagar1 ydagar1@lenovo.com; Akhilesh Kumar Jha akumarj@lenovo.com; Rajeshwari Subramanian rajesubr@lenovo.com; Amit Mehta8 amehta8@lenovo.com; Suma Hulloora shulloora@lenovo.com; GL RPA glrpa@lenovo.com; Lokesh N2 ln2@lenovo.com; Sunil S100 ss100@lenovo.com; Swati sagarika Sahoo8 ssahoo8@lenovo.com; Vikrant Sudhakar Dinde vdinde@lenovo.com; Rohit Mahajan3 rmahajan3@lenovo.com; Ramprasad M rm@lenovo.com; Mithun Kumar Naik mnaik@lenovo.com; Vinayak Sogi2 vsogi2@lenovo.com; Shobha rani Javaji sjavaji@lenovo.com; Venkatesh Srinivasan1 vsrinivasan1@lenovo.com; Ridhi Sawhney1 rsawhney1@lenovo.com; Navaneeth K nk@lenovo.com; Yash Patel1 ypatel1@lenovo.com; Kapil Bhatia kbhatia@lenovo.com; Pramodha M n6 pn6@lenovo.com; Jyoti Anand janand@lenovo.com; Gaurav Gupta2 gagupta2@lenovo.com; Gowdham Ramesh gramesh@lenovo.com; Aruna N12 an12@lenovo.com; ypatel3@lenovo.com; mpillai@lenovo.com; Maqdum Ashrafi mashrafi@lenovo.com; Lalit Kumar4 lkumar4@lenovo.com; Nishanth Nagaraju nnagaraju2@lenovo.com; Maniner Singh msingh31@lenovo.com; Siddharth Krishna4 skrishna4@lenovo.com; Bhavya G1 bg1@lenovo.com; Aman Goyal8 agoyal8@lenovo.com; Bhavyavani b V5 bv5@lenovo.com; Pratip Pradhan ppradhan@lenovo.com; Asha P7 ap7@lenovo.com}.
1.17 Repository Details
Note
Master File should be manually updated on daily basis based on exceptions.
Video Recordings : ..\KT\KT Recordings\KT 3(Comparison btw CON Manual & CSD DSR)