Add supplier inbound data in an Excel file

You can import supplier inbound table data in an Excel file.

Vorbereitungen

Role required: admin

Prozedur

1. Select All.
2. In the navigation filter, do one of the following:
   • To see the list of columns in the supplier location inbound table, enter sn_fcms_intg_supplier_location_inbound_list.do.
   • To see the list of columns in the supplier contact inbound table, enter sn_fcms_intg_supplier_contact_inbound_list.do.
   • To see the list of columns in the supplier payment inbound table, enter sn_fcms_intg_supplier_payment_inbound_stage_list.do.
   • To see the list of columns in the supplier payment inbound table, enter sn_fcms_intg_supplier_legal_entity_list.do.
3. Right-click any column heading and select Export > .xlsx.
4. Select Download to save the spreadsheet on your local system.

Ergebnisse

Depending on the supplier inbound table you selected, an Excel template is created with the mandatory columns for supplier location, supplier contacts, or supplier payment information. Use this Excel spreadsheet to enter the supplier data that you want to import and store into the SLO inbound staging tables.

Nächste Maßnahme

Load the supplier data from the excel template into the supplier inbound​ staging tables. For more information, see Load supplier data.

Zugehörige Tasks

• Load supplier data