• Neo

Bot 4: InFlow Stock Adjust

Scenario

  • You received an email that requests to update the quantity of some items in stock. The email has excel attachments that contains info about these items.

  • The bot will be triggered, read the emails with Outlook and download the excel attachments to a folder.

  • The bot read data from the excel files in that folder and enter data to the InFlow app.

Benefits

  • Better stock adjust process for inventory management.

  • Improve team productivity by reducing time spent on manual data entry on InFlow.

How it works



The excel file template is as follow


NOTE: In the video, we run the bot manually from Auteros Agent. But you can schedule to run it by interval or at a specific time in day.


Techniques used

  • Email automation.

  • Excel automation.

  • Desktop app automation.

How to use

  • Download the bot package (.aupkg) here.

  • Open Auteros Studio. if you don't have Auteros Studio installed, you can get it here.

  • Open the Explorer tab, from the root Auteros Node, right click and then click Import Workflow Package, then point to the InFlow_StockAdjust.aupkg file.

  • Open the workflow StockAdjust_Main, change the value of the variable folderPath to the folder that you want to save the excel attachments.

21 views

Contact

+84 (90) 541-873

  • LinkedIn
  • Facebook
  • Twitter
  • YouTube

Copyright ©2020 by Auteros. All rights reserved.