Marketplace logo
MarketplaceListingsTemplateData update tool for Infor Cloudsuite M3
Data update tool for Infor Cloudsuite M3

Data update tool for Infor Cloudsuite M3

by Lightning ERP (CFPM)

0

Template

0

back button
back button
next button
next button

Summary

Summary


Overview

Overview

What is it for:
Infor M3, as an ERP system, offers a web-based user interface and a direct server connection through its API. The API is about 100 times faster than manual entry for mass data updates and provides data downloading capabilities. The system supports many API transactions that assist users in creating, changing, updating, and downloading data. There are over 3,000 transactions available. Common use cases include creating and updating items, item settings, styles, equipment; managing and reporting manufacturing orders; administering purchase and sales prices; initiating purchase and customer orders; managing product structures; bill of materials; migrating stocks or financial data; reporting inventory; stock-taking, and much more. However, the free version is restricted to item-related functions, such as adding and modifying items in the warehouse, facility, units of measure, languages, etc.


How to use:
  1. Ask your management to download the Data update tool from UiPath Marketplace, install in your corporate environment, and publish it for you. Without any code adjustments, this Marketplace version is ready to use for free with all features needed for MMS functions, that is item-related uploads or downloads.
  2. Begin by using our sample Excel form. Adjust it to fit your business processes, like item numbering conventions. We can assist with its initial use at no cost if required. Alternatively, you can link your existing Excel forms to our sample datasheet using regular formulas.
  3. Share the file with other departments, to collaborate online and fill up relevant data.
  4. Once the form has been verified, open it within the UiPath automation, send the data to Infor M3, and verify the newly created item along with all related settings in just a few clicks.
  5. The result of the job is written back into the Excel file, ensuring you maintain complete control.

You might also reuse this sample file to mass upload i.e., thousands of items during one go. Simply bypass the form, prepare the datasheet with data ready for upload, and process the file in the usual manner.

Prerequisites:
- Infor M3 Cloud version 16
- Access to Infor M3 granted for external applications by API
- The HTTP server address you use in a browser

Features

Features

On each 100 items creation with the Data update tool, save a few dozen hours! It is about 100 times faster than with the browser.

Speed up also data gathering. Various departments can edit i.e., item creation forms in parallel SharePoint. You don’t have to send the form to multiple people.

You can use “list” and “get” to download data from M3. Sample use case – download old pricelist, make updates in Excel, update validity date, and upload as a new pricelist.

Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Publisher

Lightning ERP (CFPM)

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.2

Updated

Nov 21, 2023

Works with

Studio: 21.4 - 23.8

Certification

Silver Certified

Tags

excel
api
Infor
M3
Cloudsuite

Application

Infor
Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings