CASE STUDY
Logistics Report Automation
We automated processes for our customer by creating a custom RPA bot that increases efficiency and accuracy by automating Daily Logistics Report creation. Raw data was fetched from SAP.
Industry
IT
Customer
Sanghi Cements
Technology
RPA – Automation Anywhere
Details
Reports Automation using RPA
Challenge
Automating the manual processes of preparing a daily Logistics Dispatch Report and understanding fulfillment, delays and pending orders, that have not reached their customers was a critical need for their business. It was a tedious and error-prone process involving calculations to subtract the Order date from today’s date, and renaming Packaging size details according to predefined conditions – all performed manually with files received from the SAP system and prepared in Excel. By automating this process, not only will it become significantly easier to prepare accurate reports quickly but the company can also focus its resources more productively on other business requirements.
Solution
We implemented an automated process, utilizing the capabilities of RPA and Automation Anywhere, to create Dispatch Reports. The bot logs into the SAP system and retrieves all active order records by entering the relevant information. Calculations are then performed to determine any differences between today’s date and the order date, while order numbers with delays in fulfillment were added to a new column titled “Delay”, and “Delay Days” with the number of delayed days. Fulfilled orders were added to the “Completed” column. Further steps are taken to rename packaging size details according to customer-defined parameters. Finally, after preparation is complete, the daily report is emailed to designated staff members.
