verview

Who: SBS Support

What: Load an Excel template into Salesforce using Data Loader. To complete this process, GBU data steward must give:

  • Salesforce ID of the user to add
  • Salesforce ID of the accounts
  • Team member role
  • Access to accounts : Read OR write

 

 

Table of contents

 

identifies the Step-by-step

 

1

Open excel file provided by Aurelia . This file identifies, side by side, the records ID of SAP (sold-to code) and CRM ID

2Open this SFDC Report and download data in excel file (This report contains data on Account conversion to monitor)
3

From this SFDC Report, focus on column L : "SAP Number"

  1. the column is empty : this means the SAP creation has been cancelled and the record type should be modifed from "Account Creation Record type" to "Account record type"
  2. we have a number
    1. ex 4022221 (leading zeroes can be ignored) AND col J (SAP Account?) contains "Just created"
      1. Search 4022221 in Aurelia excel file (col B "Customer")
        1. not found : Email Aurelia and require record creation in corresponding table if relevant ( provide SAP Code

, 

 

 

Related articles

Can't find information?