Kiwiplan - Automation of creating new store locations.pptx

KIWIplan ERP configuration

1. Situation Creation of Locations and stores in Kiwiplan MES ULT module when a new warehouse is added in GP infrastructure Behavior The plant analyst raises a ticket with details of Locations and respective stores. Kiwiplan MES admin adds the locations in Linux classic PCS, by manually entering the fields which consumes 2 mins of Man-hours for each location. Typically, the ticket contains about 150-200 locations depending on the store. The solution proposed and implemented is the updating of the backend SQL table of the Kiwiplan MAP database with file import function of MySQL workbench, where the admin only must feed the template filled from the user. Outcome It takes 2 mins to run the stored procedure for an indefinite amount of locations, hence saving an average of 200-300 mins of man-hours per ticket. We receive around 2 tickets per month hence saving 500-600 mins. Kiwiplan - Automation of creating new store locations

2. List of locations and details in a non-standard format Ticket to add locations We add the locations one by one filling all the fields in linux We add the same in VUE app

3. Ticket to add locations User fills the columns We add the #id column which is the primary key Dump it in MySQL servers Verify the location operations