How to bulk upload Master Data Record?

How to bulk upload Master Data Record?

  • Navigate to the Master Data Section: Go to the Master Data section from the main menu.

  • Select the Dataset to Import Into: o to the Master Data section and choose the dataset where you want to add new records (e.g., Vendors, Items, Employees).

  • Download Import Template: Download the provided template for importing data.

  • Fill in the Template: Complete the template with the required data for the new records.

  • Upload the Template: Upload the filled template file into the system.

  • Check for Errors: Review the uploaded data for any errors. If errors are present, correct them based on the error messages provided. Once the data is error-free, it will be ready for submission.

Await Approval: The import request will be processed, and the records will be added only after approval from the designated authority.

Example:
If you're importing Vendor records, download the vendor import template, fill it with the necessary details (e.g., vendor name, address, and payment terms), then upload it for approval. After the import is approved, the new vendor records will be available for use in procurement workflows.
    • Related Articles

    • How to Submit a New Master Data Record

      Navigate to the Master Data Section: Go to the Master Data section from the main menu. Click on ‘Add New Record: Select the Add New Record option to open the form. Fill in the Required Fields: Enter the necessary details for the new record, such as ...
    • What permissions and capabilities do users have for Master Data, including workflows?

      Users can be provided with specific permissions to view, submit, edit, or bulk upload Master Data records through User Management. Additionally, users with the Configure Workflow permission for a specific Master Data type can set up and manage ...
    • How to View Master Data Records?

      Navigate to the Master Data Section: Go to the Master Data section from the side menu. Select the Desired Dataset: Choose the dataset you want to view, such as Vendors, Items, or Employees. View Records: The records within the selected dataset will ...
    • How to Edit an Existing Master Data Record

      Locate the Record to Edit: Search for and select the record you want to modify. Click on ‘Edit’: Click the Edit option to open the record for modification. Make Necessary Changes: Update the required fields with the new information. Review and ...
    • What is Master Data?

      Master Data refers to the core, consistent, and reusable information that forms the foundation for business processes within the organization. It includes critical entities and attributes essential for operations, decision-making, and reporting. In ...