To create vendors en masse, follow the steps below.
- Login to MDO with your assigned credentials.
- From the Homepage, select the My Profile icon on the top right corner.
- Scroll down to the Excel Connector section. Select Download Excel Connector Installer. Install the installer.
- Download the Excel Connector Template. For further details in Excel connect refer to the following link (Set up & Prerequisite)
- Excel Connect will open. Click on the Login button top left corner and log in with your MDO credentials.
- Click on Modules on the top and then click on Select Module. Select the Vendor module from the dropdown.
- Click on Select Template and select the template from the dropdown.
- Click on the Add Rows icon under the Actions section to add vendors.
- Enter the number of vendors you want to create.
- Enter the relevant information in the Excel Connect template.
- Scroll to the right of the template. There are hyperlinks (indicating hierarchies or grids) under the columns such as Company Code, Purchase Organization, etc.
- Click on the hyperlinks to enter the information required in these hierarchies or grids.
- Once all the data is entered, click on the Validate icon.
- If the status in the left column changes to Success, the data is validated successfully and can be exported to MDO. If the status is Error, then there is a problem with the data entered. Correct the data according to the message shown.
- Once the spreadsheet is validated, click on the Export icon to export the data to MDO.
- Once the data is exported, click on the Complete icon to trigger the workflow.
- The vendors are created in MDO and the creation workflow will be triggered.
- On completion of the workflow, the vendor records go to SAP for integration. Once the records are integrated with SAP, SAP numbers are received against each vendor record in MDO.