Collating past SCM data of purchase and Sale/Issues with Serial Nos in a specified XL template.
Use pre-defined utility and update legacy data tables in ERP system.
Coordinate with ERP Support.
Create validation/test cases in XL
Write Queries in SQL db to validate XL test cases.
Coordinate with ERP support to merge tables and DB.
Enable all queries for SCM reporting including legacy data.
Build an URL for Order visibility to Sales/Customers.