| Anchor | ||||
|---|---|---|---|---|
|
Table Of Contents
| HTML |
|---|
<style> .toc-macro ul {display: block; counter-reset: item} .toc-macro li {list-style-type:none} .toc-macro li:before {content: counters (item, ".")". "; counter-increment: item} </style> |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Objective and Scope
Objective of this Procedure
This document describes the process to handle Customer Master Data to create, modify and extend a new/existing customer accounts in PRS (PF1_50) and RCS (WP1_400) environment and describes the roles and responsibilities of each actor in this process.
Scope
Data Operations Team based in Riga is responsible to handle all Technology Solutions, Composites, Novecare Customer Master Data for all regions and Intercompany extensions and Sales area data updates.
Requests for Intercompany customer record general data creation/general data modification are within Lisbon SBS team’s scope.
Definitions
Abbreviation | Description | Abbreviation | Description | Abbreviation | Description |
|---|---|---|---|---|---|
PRS | Permanent Reference System (PF1_50) | COA | Certificate of Analysis | IC | Intercompany |
RCS | Rhodia Core system (WP1_400) | MSDS | Material Safety Data Sheet | DBA | Doing Business As |
SBS | Solvay Business Services | NAM | North America | T/A | Trading as |
PO | Purchase Order | LAM | Latin America | C/O | Care of |
PO BOX | Postal Office Box | EMEA | Europe Middle East Africa | ||
WF / CWF | Customer Workflow | APAC | Asia Pacific | ||
SO | Sales Organization | TrZones / TZ | Transportation Zones | ||
CRM (a.k.a. SF) | Customer Relationship Management (Salesforce) | ||||
CSR | Customer Service Representative | FAO | For the attention of |
Roles & responsibilities of each actor
The initial requester - Requests for new customer creations and/or changes can be received through Service One as a ticket.
Data Operations Team (Part 1) - Every customer setup or maintenance request should be registered in Service One. Requests received through personal Mailbox should also be entered into Service One.
When initial requests are received, Data team member will perform required validation checks and will initiate/modify Salesforce workflow for new creation or modification in PRS. If only sales data is changed then changes will be performed directly in RCS.
Data Operations Riga & Lisbon - Data Operations team in Riga and Lisbon are responsible for validation of the submitted WF’s. This includes general data setup, duplicate check in PRS and establishing a link in Extra Master Data between RCS and PRS customer records as well as link between Payer (account group 0003) and Sold-to (account group 0001).
Data Operations Team (Part 2) - Completed WF returns to Data Team after approval of Data Controller with PRS customer reference number. It is under Data Team responsibility to check whether all the required information was provided to continue with customer set up in RCS. DM creates customer for respective SO/Distribution Channel/Division combination and forwards all setup related documentation to Credit Manager in order to have credit data completed.
Credit Manager - Credit Manager is responsible for credit data maintenance that includes payment terms and credit limit established for customer account in PI1. (PI1 synchronizes with PRS only once a day).
Process Flow
Technology Solutions & Novecare (New Setups)
Aerospace (New Setups)
Systems overview
In Solvay customer master data is being maintained in four systems – PF1_050, PF1_020, WP1_400, PI_020.
CRM - (Customer Relationship Management Tool) - used to manage a company's interaction with current and potential customers. Salesforce (SF) is the CRM tool used at Solvay.
Salesforce request is initiated in CRM by Customer Service. Once customer general data is completed by Customer Service Representative, created prospect can be converted into SAP account. It happens through Customer Workflow, which is created automatically once request for conversion is submitted.
Customer Workflow functionality is used in PRS to request customer creation and changes. Data Management team modifies and approves Workflows initiated by CRM or submits Workflows manually in PRS (PF1_50). After that the Workflow is routed for validation and as soon as it is approved, customer code is generated in the system. Data Operations Representative completes the setup in PRS (PF1_50) and RCS (WP1_400) and Credit Manager completes credit data in CICC (PI1_20).
PRS (PF1_050) – is used to maintain general data of the customer (name, address, registration number, general contact information, bank details). This information is automatically distributed to the rest of the systems (WP1, PI1, PF1_020 ).
RCS (WP1_400) – is used to maintain customer company code and sales organization information. Once customer general information has been changed in RCS (WP1_400) changes will appear in the CRM system.
PRS (PF1_020) – has similar functionality as RCS, but used by Solvay companies, which are not in Riga Data Operations scope.
CICC (PI1_20) - is used by Credit Management to set up and maintain customer credit data.
New creations and changes made in PRS will be distributed to one or both of the systems (WP1 and/or PF1_020).
Sales Area Data (sales organization) – created manually by DM Riga in WP1 (shipping information, partner functions etc.).
Company code data is created automatically in WP1 based on the sales organization for which customer was opened, if transaction ZWOC06T is used.
Customer account structure
Every regular customer consists of 4 roles:
| Customer Role | Setup | Usage |
|---|---|---|
| Sold-to | Can be used as sold-to and as ship-to | Sold-to is used to store information relevant to sales, shipping and billing. This is the account on which Sales Orders are created. |
| Payer | Always a separate record even if address matches with other parties as it is set up under specific account group. For records created before 2015, payer can have the same number as sold-to and therefore in case of changes/extension, we should leave the set up as it is without creating a separate Payer party. Payer can be used as Payer or Bill-to. Linked with sold-to. | Payer (Main Payer) is the single account where Credit Management team maintains financial/credit data for the customer. The links are kept in "Extra Master data - Solvay Cross Reference". Billing documents are created on this account. |
| Payer-bis | Used when payer already exists in SAP with a different address (same country). In such case Payer-bis is created and linked with the existing Payer (Main Payer). | Billing document is created on this account. Financial/credit data is maintained in Main Payer. |
| Ship-to | Created as separate record, if ship-to address differs from sold-to. Linked with sold-to. | Ship-to is used to indicate the address to which goods will be delivered. |
| Bill-to | Created as separate record, if bill-to address differs from payer. Linked with sold-to. | Bill-to is used to indicate the location to which invoice needs to be physically sent. |
Customer account group defines role of the customer and is chosen upon customer creation.
| Customer Role | Account Groups in PRS Only following account groups should be used | Corresponding account Groups in RCS (WP1) |
|---|---|---|
Ship-to | Z**2 | 0002 |
Payer | Z**4 | 0003 |
Payer Bis | Z**5 | 0003 |
Sold-to | Z**8 | 0001 |
Bill-to | Not maintained in PRS | 0004 (only maintained in WP1) |
Sold-to & payer - should not be used for new creations. "old" main payer all-in one (PY-SP-SH-BP) | Z**1 | 0001 |
| Note |
|---|
In case if checking for duplicates there is found an existing appropriate account in PRS 1st account account group, this account can be used:
|
Receiving a request
New customer creation (including new ship-to accounts) requests must be initiated only through CRM (SF) by CSR. Once request has been submitted in CRM, workflow will be created in PRS and DM Riga will receive automatically generated CRM request form which should include all necessary documentation.
Request for Account Conversion
This form should include all necessary general and sales data information. If mandatory information is missing, you must contact requester in order to receive it. Mandatory documentation and information depends on GBU.
[Production] - Request number
In case if in area Additional Ship-to Account is indicated data for separate ship-to creation, it means that WF number for ship-to creation has been generated, but has not been provided as notification from Salesforce.
In order to find this WF number use transaction Z1S_CWF_REQUEST in PF1_50 (field - Display or change existing request). Search by company name, WF creation date or requester name to find correct WF.
| Note |
|---|
In case of duplication, (existing account with matching information is found) - generated WF is not needed, that's why it needs to be rejected, but Sales Force IDs needs to be merged by submitting ticket to SF CRM Team. |
Prerequisites
Following checks need to be performed before proceeding with customer creation/change.
Duplicate check
| Note |
|---|
Duplicate check is mandatory before customer creation, name/address modification and extension. |
To check if the customer already exists in the system, execute transaction XD03. The check should be performed in both systems: PRS and RCS. Duplicate check in PRS is also done automatically by the workflow, but it’s not as specific, therefore manual duplicate check is mandatory.
It’s advised to use three types of searches:
- by Name (in combination with country code)
- by Address (postal code & country)
- by Tax Information
In order to access search enter transaction XD03 and click on the “search box”. In PRS/RCS you can choose several options on how to search for duplicates. It’s advised to use Customers (general), Customers by Address Attributes, Customers by Tax Information.
Remember to use “*” before and after the significant part of the customer's name to search for it, this will show all customers that have any character written after or before the name typed. This can be used for any search field in SAP.
If the customer is not created in the system, you can proceed with its creation. If it is already created, check for possible updates and forward the number to the requester.
In order to check, to which target system customer has been extended (WP1, PF1_20 or both) - the following check can be performed:
- Open customer view in PF1_50 through XD03
- Go to "Extras" → "Additional Data". Customer is transferred to
- PF1_020, if "Tft ERP Ch/Pl" is populated with "X"
- WP1, if "Attribute 3" is populated with:
- 01 - transferred to RCS as sold-to (0001)
- 02 - transferred to RCS as ship-to (0002)
- 03 - transferred to RCS as payer (0004)
Required documentation
Upon receiving request for customer creation, changes, extension, re-activation check whether mandatory documentation is attached.
All rules and document requirements depending on GBU can be found by following the links below:
Technology Solutions
Embedded Google Drive File docid 1HH_H9agUdpKe8bZryBqHt4ayFEOi_UZoDg1XsTVsMb0 height 595
Novecare, Aroma & Silica:
Embedded Google Drive File docid 1XWbgymxbMD5qG73MQsc1ZRPVF3AmFHR_p__mFEKM_IE
Aerospace:
| Embedded Google Drive File | ||||
|---|---|---|---|---|
|
Data Validation
In order to create customers correctly, there are mandatory data validation rules. Please follow this link to see validation WI with all the rules for specific systems and web pages where validation is performed.
For WP1 customers mandatory validation applies to:
- VAT numbers for EU customers
- TAX ID for Brazilian, Peruvian, Chilien, Canadian, Norwegen, Australian, India and Thailand customers
- DUNS number verification
Main rules for customer creation and modification
When creating a new WF request, there are some rules that must be strictly followed:
- All the information must be entered in UPPER CASE;
- No special characters and country specific alphabetical letters are allowed. Country specific alphabetical letters must be changed to English letters, for example, Está to ESTA, Pröll to PROLL, Associação to ASSOCIACAO.
“ | ‘ | ` | = | ( ) | [ ] | < > | # | * | ^ | \\\\ | /// | á | ö | ç | ã |
- Abbreviate as follows (if applicable):
Company | CO | Street | ST | Suite | STE |
Incorporated | INC | Road | RD | Building | BLDG |
Corporation | CORP | Drive | DR | Apartment | APT |
Manufacturing | MFG | Court | CT | South | S |
Limited | LTD | Avenue | AVE | South East | SE |
Limited Liability Corp | LLC | Boulevard | BLVD | East | E |
Limited Liability Partnership | LLP | Lane | LN | North East | NE |
Public Limited Company | PLC | Highway | HWY | North | N |
Place | PL | West | W | North West | NW |
Plaza | PLZ | South West | SW |
- No spaces are to be entered for company names with alphabetical abbreviation - example, ABC CO and not A B C CO
- For company business type, if it is written as : S.A.S., S.A. or S.A.S.U. no dots and spaces should be used - correct setup is SAS, SA and SASU.
- When customer has another name like a DBA (Doing Business As) / T/A (Trading as) is mentioned in the Credit Application/Purchase order, this name should be written in the second line with “DBA” in the beginning.
Customer creation via workflow
| Anchor | ||||
|---|---|---|---|---|
|
PRS (PF1) is the main system where all customer general data is stored. It’s connected with WP1 where data is transferred after submitting a Workflow.
Once logged you can access your Business Workplace (Workflows) by entering transaction Z1S_CWF_REQUEST.
There will be 3 options available:
| New customer creation | Used to create Workflow for new customer creation. To proceed populate customer name, city and country,
| ||
| Existing customer data modification | If customers general data needs updating, it should be changed through WF by entering PRS account code and modifying as requested. Both Payer and Sold-to should be updated accordingly. | ||
| Display or change an existing request | Used to display or modify WF. Workflow created in Salesforce has status - N-SAVED, therefore it’s not visible in WF inbox before Data Team modifies and saves it by using Display or change an existing request. |
Transaction Z1S_CWF_REQUEST_LIST can be used to review the list of requests and their current status.
If Salesforce generated WF for incorrect account group, or you want to create payer and sold-to in one WF, in order to avoid double work caused by separate account creations, you can use the steps described below:
- Use transaction Z1S_CWF_REQUEST
- Fill in search term, city and country, which exactly matches with information from Salesforce request for account conversion.
- Select new account group you need.
- In the result list click “Create from Request number “ and specify the request number received from Salesforce.
- Check if the account group has been changed correctly.
See below fields to be completed/verified in the Workflow:
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Company code, GBU, Name, Name 2, Name 3, Search Term 1, Preview, Street, House Number, Street 2, Street 3, Street 4, District, Postal Code, PO Box, PO Box Postal code, PO Box City, Payer to Sold-to, Thai, Korea, Japan & China, CRM, Postal Address, International Versions, VAT Reg. No., Tax Code, City code, DUNS data, Telephone, Fax number, E-Mail Address, Cred. Contr. Area, Bus. Credit Need, Currency, Est. Yrly Turnover, 1st Order value, Req Payment terms, Dunning procedure, Payer, Payer-bis, Distribution tab, Salesforce ID (SF ID), Reason absence SFID, Aerospace |
Save record:
Confirm Sold-to creation (if needed):
Once confirmed, workflow is submitted and will appear in the inbox of Data Operations teams. Once the record is reviewed and approved by Data Controller you will receive a notification to your e-mail containing sold-to/payer or ship-to number in PRS - for sold-to and payer you will receive two separate notifications to your personal mailbox with PRS account numbers provided.
Workflow approval
Open PF1_050 and select SAP Business Workplace
Double-click on Inbox – Workflow
A list of pending workflows will appear
| Note |
|---|
VWF are Vendor domain related. Do not open them. |
Find request number and open it by pressing Execute .
Request type will be displayed as below - either it is a new creation or modification of an existing account.
To be used for approving WF.
| |||
To be used for rejecting WF. If account already exists in PRS and/or RCS, or it is submitted in the incorrect account group, WF must be rejected. When you press reject, the system will ask to provide the reason of rejection. Do NOT skip this step as an explanation of rejection must be mentioned. | |||
To be used for modification of the data entered in the WF. Use to correct incorrectly entered information such as typos, special characters, address format etc. After necessary correction has been made, press save and proceed with approving the WF. | |||
To be used to see what exactly has been updated. In case this appears empty, check all tabs carefully. Sometimes Tax ID changes does not appear here. | |||
| To be used for returning WF back to the requester for modification. |
Customer creation in WP1 (RCS)
| Note |
|---|
New customer creation always needs to be started with PAYER party creation! |
After you have received system notification that a new PRS payer customer has been created, you can proceed with customer setup in WP1.
Transaction ZWOC06T - Customer management is used to create the required extension for Sales Organization/ Distribution Channel/ Division.
| Note |
|---|
For Payer and Sold-to extended to Aerospace sales areas, please always later review and update company code details. |
In notification received there is only PRS payer or sold-to account number mentioned, therefore you need to find corresponding RCS number. Click on search icon and select Customers by DUNS and Xref codes tab in order to find customer RCS number.
If customer data has been transferred to WP1, one record should appear in the search results:
Always check if account group is correct before you proceed. Double-click on the record and it will bring you back to the main screen.
Now you have to complete Sales Organization, Distribution channel, Division and account group information in order to create customer for the necessary sales area.
| Field | Description | ||
|---|---|---|---|
| Customer number | customer for which new sales area needs to be added | ||
| Sales organization | An organizational unit responsible for the sale of certain products or services. Sales organization is provided by requester. | ||
| Distribution channel | The way in which products or services reach the customer. Typical examples of distribution channels are wholesale, retail, or direct sales. Distribution channel is provided by requester. | ||
| Division | A way of grouping materials, products, or services. The system uses divisions to determine the sales areas and the business areas for a material, product, or service. Division is provided by requester. | ||
| Account group selection | According to the account group you are creating/extending.
|
For possible entries see Appendix - List of Sales Areas.
Once this information is completed press on icon or F8 to proceed.
Two information notifications will appear confirming that sales area is valid and does not exist for the customer. Press to proceed.
Then confirm that you want to create sales view for the given sales area information. Check if the combination of Sales organization, Distribution channel, Division is correct, and if it is correct, press Yes.
Before creation of sales data SAP will request to complete missing Transportation zone. This is the 1st step of the creation of each new party in RCS.
Transportation zone is part of Address fields in General data view.
Payer General view setup
| Anchor | ||||
|---|---|---|---|---|
|
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Address: International Versions, Transportation zone, Communication, Language change, Texts, Order. |
After going through all general data view screens press save and two more pop-up windows will appear - you can skip them by pressing enter or and yes.
Payer Sales view creation (extension)
For the initial creation in WP1 customer general view should be completed as described in Payer General view setup . But then customer should be extended to sales area by creating a sales view. Sales view creation is equal to extension.
In case if customer extension is requested, it means that existing customer account must be opened for new sales area. Company code will be generated automatically, if you perform extension by using transaction ZWOC06T.
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Sales: Exch. Rate Type, ERT, LAM, MX, CL, BR, PE, Mexico, Chile, Brazil, Peru |
Payer Company view creation (extension)
Company code view normally is created automatically upon sold-to and payer account extension to new sales area. In case company code has not been created automatically, you can create it manually via transaction XD01.
| Note |
|---|
For Aerospace you should always review and update company code as per the screens below. |
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Account Management: Recon. account, Reconciliation, Sort key |
Sold-to General view setup
| Anchor | ||||
|---|---|---|---|---|
|
Note that sold-to account general data has additional information to fill in on General data level which differs from Payer setup.
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Address: International version, Transportation zone, China, Communication, APAC, |
After going through all general data view screens press save and two more pop-up windows will appear - you can skip them by pressing enter or and yes.
Sold-to Sales view creation (extension)
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Sales: Sales Office, Sales Group, Sales Manager, Account owner, Currency, PP cust. proc., Cross Selling Products, Customer Group, Export Compliance, GBU Account Sub-type, Industry, Trade, Distributor, Service Provided, Exch. Rate Type, ERT, LAM, MX, CL, BR, PE, Cust.pric.proc., Cust.Stats.Grp, China, Aerospace |
Sold-to Company view creation (extension)
Company code view normally is created automatically upon sold-to and payer account extension to new sales area. In case company code has not been created automatically, you can create it manually via transaction XD01.
| Note |
|---|
For Aerospace you should always review and update company code as per the screens below. |
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Account Management: Recon. account, Reconciliation, Sort key |
Approval for creation
When all accounts - sold-to, payer, ship-to (if applicable) have been created in RCS (WP1), create a request to Credit department to complete credit information.
E-mail must include:
- Customer numbers in all systems:
PRS (PF1) Payer #, sold-to #
RCS (WP1) Payer #, sold-to # - All necessary setup documentation.
| Note |
|---|
Before sending email to Credit, make sure that customer links in Customer Extra Master Data → Solvay Cross Reference - have been corrected/added. PRS payer and main payer numbers must be populated for Payer and Sold to at the moment of the initial setup. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Subject: New customer for NEXEO SOLUTIONS LLC |
Ship-to General view setup
Ship-to general data maintenance is the same as for Sold-to.
In Contacts Tab For Technology Solutions is Mandatory to have MSDS contact
Ship-to Sales view creation (extension)
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Sales: Sales Office, Sales Group, Sales Manager, Account owner |
Bill-to creation
Separate bill-to party is created when bill-to address differs from Sold-to and Payer address. Bill-to party is created directly in WP1 under the account group 0004 and it should be extended to the corresponding sales organization/distribution channel/division as the sold-to party with which it will be linked.
In order to create new bill-to address, use transaction XD01 – Create Customer.
| Field | Description |
|---|---|
| Account group | 0004 Bill-to party |
| Sales organization | same as for the corresponding Sold-to |
| Distribution Channel | same as for the corresponding Sold-to |
| Division | same as for the corresponding Sold-to |
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Address : Name, Address, Communication fields, PO Box |
As soon as bill-to party is created it should be linked with corresponding sold-to party. Go to Sold-to party using transaction XD02 and update bill-to party number in the partner functions for required sales organization.
One time customers
One time customers are those whom we supply only once or rarely. These accounts are used for Free goods and Sample orders, meaning - there is no receivables expected from the customer.
We create a special One time customer record in account group Z004 where we do not store customer specific data in one time account, since this account is used for more than one customer. The customer specific entries such as name, address, bank details and sales data are entered when the document for the transaction is entered into the system by Customer Service.
Things to note:
- No documentation required;
- These One time customers are created directly into RCS;
- There must be only one account per country. Always check if there is no existing account;
- Account number range starting as 9999XX;
- Do not confuse this account group with regular one-time customers.
! The main difference between between One time customer (acc. group Z004) and regular One time customers is that the second is going to be set up as a regular customer and will pay for their order, even if it is one time purchase, while the first is receiving Free goods or Sample from Solvay.
Transaction used to create One time customer in RCS: XD01
Transaction to extend One time customer(open for sales view): ZWOC06T
| Note |
|---|
| Note that there is no documentation required in order to extend One time customer account. |
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sales Data view setup
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Keywords |
|---|
Initial screen: Customer number, Sales area selection, Z004, account group Sales: Sales office, Sales Group, 2EY, 2NL, 999, Cust. pric. proc. Cust.Stats.Grp. |
Intercompany account extension
| Note |
|---|
All intercompany (IC) general data creation requests should be received from APDM Team only. If request has been received from, e.g., Customer Service, Finance, this request needs to be transferred to Vendor team in Service One. |
There are few things to note prior extending IC accounts:
- There is no documentation required;
- Payer accounts must be extended first.
- Most IC accounts in RCS are set up under Sold-to account group (including payers) (Z**1 in PRS). The easiest way might be using RCS cross references to find the Payer & Bill-to account.
- Viviane Beraud - is contact for intercompany maintenance. You may contact her in case of complicated requests only!
IC account extension is performed by using transaction ZWOC06T.
| Note |
|---|
Riga Data Team can process intercompany extension requests only in case of urgency. Intercompany extensions are under Lisbon Data Team scope. Lisbon Data team extends and populates payment terms for intercompany account by themselves. Riga team needs to send extended records to credit management in order to get payment terms in the system. |
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Initial screen: Customer number, Sales area selection |
| Note |
|---|
Once the extension has been completed, send notification to the Credit Management Team just informing them that IC account has been extended. Mention that the default payment terms 0455 - 0d closing 5or10or15or20or 25 should be added. But no need to ask approval and wait for they reply. |
Returns Vendor and Subcontracting (Toller) creation for GBU Composite Materials
Returns Vendor
Returns vendors are set up in customer master in order to return material back to our supplier. They will always have corresponding vendor account already set up in the system. Requests for returns vendor setup will usually come from Purchasing teams.
No financial transactions are expected for Returns Vendor.
Requirements:
- No documentation is required. Address information can be seen in vendor account via XK03 transaction.
- Following details must be provided upon request:
- Vendor number
- Plant
- Shipping conditions (same as vendor, if not available must be provided)
- Incoterms (same as vendor, if not available must be provided)
| Note |
|---|
Existing customer account can be used as a returns vendor. |
Returns Vendor General view setup
If new customer needs to be created:
- Submit Customer Worklfow for sold-to and payer creation.
- General data maintenance is the same as for Sold-to and Payer accounts accordingly.
- Once created, please ask Data Operations Representative working with vendors, to add Returns Vendor flag in vendor master data.
| Note |
|---|
Make sure to indicate Vendor code in the Control Data tab of the sold-to. |
Subcontracting (Toller) Customer
Subcontracting customers are set up in order to deliver materials to our subcontractors. They should have corresponding vendor account already set up in the system. Requests for returns vendor setup will usually come from Purchasing teams.
No financial transactions are expected for Returns Vendor.
Requirements:
- No documentation is required. Address information can be seen in vendor account via XK03 transaction.
- Following details must be provided upon request:
- Vendor number
- Plant
- Shipping conditions (same as vendor, if not available must be provided)
- Incoterms (same as vendor, if not available must be provided)
| Note |
|---|
Existing sold-to customer cannot be used as a subcontracting customer. |
Subcontracting (Toller) Customer General view setup
If Payer account already exists:
- create only Sold-to with name “SOLVAY “CYTEC CO… (legal name)”
- extend existing Payer to the necessary sales area and link with the created Sold-to;
If a Customer doesn’t exist:
create Payer with the legal customer name;
create Sold-to with name “SOLVAY name “CYTEC CO… (legal name)”
NOTE: C/O (Care of) companies should be populated in C/O field (and not in Name 2)
Other than the Sold-to name general data maintenance is the same as for Sold-to and Payer accounts accordingly.
| Note |
|---|
Make sure to precede the sold-to customer name with "SOLVAY COCYTEC" Make sure to indicate Vendor code in the Control Data tab of the sold-to. |
Returns Vendor and Subcontracting (Toller) Sales Area
Sales area for both Returns Vendor and Subcontracting customers should be added based on plant code provided.
| Note |
|---|
For Aerospace distribution channel will always be 0A. |
It can be found in SE16 transaction, table T001W
Populate the number of the requested plant and press
On the right side of the resulting table you will find Sales area details - Sales Organization (SOrg), Distribution Channel (DstCh) and Division (Div).
Returns Vendor and Subcontracting (Toller) Payer Sales view creation (extension)
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Billing Documents: Rebate, Price determin, Terms of payment, Payment terms, Taxes |
Returns Vendor and Subcontracting (Toller) Sold-to Sales view creation (extension)
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Sales: Sales office, Sales Group, Intra-group, Currency, Cust. pric. proc. Cust.Stats.Grp. |
| Note |
|---|
Final steps for Returns vendor creation:
|
1. Modify ticket subject to :
URGENT - Customer xxxxxx name/address change
xxxxxx states for customer RCS number, if customer is distributed also to PF1_20, in the subject must be mentioned PRS & RCS codes
2. Go to your private mail and write an email to all involved CSRs with the following subject:
Re: Ticket ID [#zzzzzzz] URGENT - Customer xxxxxx name/address change
zzzzzzz states for FD ticket number, 2nd part of the subject is same as subject of FD ticket
3. Email should be addressed to all involved CSRs, which used the account within the last 24 months
4. Attach all supporting documentation and mention that if no response/ out of office notification is received within 48 hours it will be considered as confirmation, that changes can be applied.
*If email will be sent out from Freshdesk, Out of Office notification will not be received. That's why private mail is the only way to request this type of approval.
*If you receive an OOO email, the same email should be sent to backup CSR working under the same GBU/manager of CSR, who is out of office.
Customer changes
Approvals table
Before proceeding with any changes for the customer, make sure to obtain all necessary approvals (usually for Sold-to & Payer parties).
| Embedded Google Drive File | ||
|---|---|---|
|
Changing general data
General data: name change, address change, registration numbers addition or typo correction, generic contact information, international translations.
Before changing general data:
- Check documents provided that the requests corresponds to information on documents (e.g. copy of PO). If VAT confirms the new name there is no need to wait for Official letter but it would be good to have any supporting documentation.
- Perform the necessary validations - validate VAT number/registration number if possible, check if DUNS numbers has changed.
- Perform duplicate check directly in WP1 with the new information as there might be another account already existing. Or more accounts to be updated if it is a name change.
- Once all the checks has been performed, you can submit workflow for the modification.
REMEMBER! If it is a shared customer and it had sales in other sales areas in the past 2 years - you need to contact other CSRs and wait for their confirmation of the change requested. - After changes are done, inform the responsible Credit Management team about changes performed (applicable to name and registration number changes). No need to inform them about address changes.
Via Workflow
Customer general data changes are being processed via Workflow (Z1S_CWF_REQUEST) in PRS system.
| Note |
|---|
When you modify sold-to address check if Payer needs modification as well! When you submit WF to change customer, it will put an order block on customer, so in this period customer will be BLOCKED for order creation until Data Controller releases the record. |
In the workflow indicate PRS customer number which needs adjustments
Make necessary changes and save the Workflow
Via transaction XD02
Customer general data should be modified via XD02 only in those cases when the information that needs to be changed cannot be modified through the Workflows. For example, cross references, Additional data, Blocks, Deletion flags, Text notes etc).
Attribute 7 - Multi currency customer
Once in a while we might receive requests from Customer Service Representatives to add or remove multi-currency customer check-mark.
Whenever an order is entered with different currencies on header & item level, CSRs would get a soft warning. This warning will not prevent order from being processed.
This field is maintained in WP1 on General data level.
Go to General data - Extras - Additional data - Attribute 7
| Note |
|---|
If someone requests to add Attribute 7 and customer account is opened also for other GBU's, proceed with the change and inform the requester that the change will impact other sales areas because the change is made on General data level that contains shared information between different sales areas. It is not a mandatory requirement but they should inform other CSR's dealing with the same account on such change. |
Changing sales or company code data
Changes in company code or sales area data are managed in WP1. For more information regarding fields please see chapters on company code or sales area creation (extension).
Customer sales data changes are processed via transaction ZWOC07T
| Field | Description |
|---|---|
| Customer number | Customer for which the change needs to be made |
| Sales organization | An organizational unit responsible for the sale of certain products or services. Sales organization is provided by requester. |
| Distribution channel | The way in which products or services reach the customer. Typical examples of distribution channels are wholesale, retail, or direct sales. Distribution channel is provided by requester. |
| Division | A way of grouping materials, products, or services. The system uses divisions to determine the sales areas and the business areas for a material, product, or service. Division is provided by requester. |
You can see sales areas available for the chosen customer, by clicking on
Otherwise changes can be applied using transaction XD02
| Field | Description |
|---|---|
| Customer number | Customer for which the change needs to be made |
| Company code | The company code is an organizational unit within financial accounting. Company code is provided by requester. |
| Sales organization | An organizational unit responsible for the sale of certain products or services. Sales organization is provided by requester. |
| Distribution channel | The way in which products or services reach the customer. Typical examples of distribution channels are wholesale, retail, or direct sales. Distribution channel is provided by requester. |
| Division | A way of grouping materials, products, or services. The system uses divisions to determine the sales areas and the business areas for a material, product, or service. Division is provided by requester. |
You can see sales areas available for the chosen customer, by clicking on
Customer Text Notes
Customer text notes can be added on a ship-to and/or sold-to level for required sales organization through Sales area - Extras - Texts.
- Choose the line where the text needs to be added.
- Select language in drop-down list
- Insert a text, press save and then select Go to - Change Editor
Check if text is divided correctly and no information is cut off.
Maintain every line with " * " instead of "/", this will ensure that CS can edit Notes on order level.
Account upgrade
Account group upgrade is mostly used to change existing Ship-to or Prospect customer to a Sold-to customer.
Before upgrade make sure that:
- Customer is not linked to other sold-to accounts in both WP1 and PF1_020
- Data matches the request
To change Account Group of a customer use transaction XD07 – Change Customer Account Group.
| Note |
|---|
Account group upgrade needs to be performed in all systems customer is created in following order:
|
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Account upgrade in RCS: Account group |
Customer inactivation & reactivation
A customer master record can be blocked whenever there is a need to temporarily stop all or part of business relations with a customer.
| Note |
|---|
|
Once all confirmations and approvals are received proceed with the following steps (for inactivation all below mentioned blocks and deletion flags must be set, but for reactivation the same flags and blocks must be removed, search term corrected).
PRS - Customer Block/Unblock and Flag for Deletion
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
PRS - Customer Block/Unblock: XD05, Blocking Data, Posting Block, All Company Codes, Order Block, All Sales Areas, Delivery Block, Billing Block, Block Sales Support. |
To proceed with the inactivation following steps must be perfomed:
Through XD02 transaction change search term to one of the options below.
Search term Description ****INACTIVE if customer has been inactivated due to no sales in past 18 months ****DUPLICATE if customer has been inactivated due duplication ****INVALID if customer has been inactivated due invalid/incorrect registration number ****DO NOT USE rarely to be used for setups which is not possible to fix in any way - In Extra Master Data delete DUNS codes and change Reason for the absence of DUNS to DEL.
- Apply blocking/deletion steps in the target systems WP1 (RCS) and/or PF1_020.
RCS - Customer Block/Unblock and Flag for Deletion
It is possible for a customer to be blocked/marked for deletion in all company codes and sales areas as well as only selected ones.
| Note |
|---|
|
| SP Horizontal nav group | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
PRS - Customer Block/Unblock: XD05, Blocking Data, Posting Block, All Company Codes, Order Block, All Sales Areas, Delivery Block, Billing Block, Block Sales Support. |
Once completed add Text note indicating the reason for deletion General Data – Extras – Texts – Internal note.
note indicating the reason for deletion General Data – Extras – Texts – Internal note.
| Note |
|---|
NOTE! If customer blocking and marking for deletion flag is performed through transaction ZWOC07T, customer will appear in Lisbon Data Teams database as request for Sales area validation. |
Specific Situations of Block And Unblock - End Of TSA (Transitional Services Agreement)
When Intercompany codes (or codes link to them) are in a TSA situation, it could happen to have duplicate customers since the old "Intercompany" can not be used for new orders but need to close all items and need to be created new "regular" codes in order to keep the business ongoing.
In these peculiar situations the Search Term should be define **END OF TSA and in Name 4 Field add "DO NOT USE FOR NEW ORDERS"
And in the Specific Sales Areas only for the orders:
That way we can check if this client can be used to not or advise any other team (CSR, Credit, etc)
.
Review of the status of invoices
To check the payment status for assigned documents, we can use Z3F_FA_DOC_FLOW in WP1.
| Field | Description |
|---|---|
| Selection process | Select by partner |
| Company code | Company code corresponding to sales organization |
| Fiscal year | Select range needed |
| Customer | RCS payer number |
Hit F8 to run the transaction.
Under the Payment status column you will be able to check if payment has arrived or not.
Appendix - List of Sales Area combinations
| Anchor | ||||
|---|---|---|---|---|
|
List of Sales area combinations
Embedded Google Drive File docid 1jpOg8FWwITF-8JxRHUNuNDu1cMCteqV1PlP6ChdHRno
| Note |
|---|
This is NOT a comprehensive list of all the sales organizations in Data Operations Riga scope. If you receive request for Sales area of GBU within our scope, but it is not yet listed here:
|
List of Distribution Channels
Embedded Google Drive File docid 1T2rFeZ1FKJCXkuDyT7j6VE6B5UgQg1_tXcqImjmMmJE
| Note |
|---|
This is NOT a comprehensive list of all the Distribution Channels of the GBU in Data Operations Riga scope. If you receive request for Sales area of GBU within our scope, but it is not yet listed here: *proceed with the request; |
Asia Model
Situation | Sales Area |
|---|---|
CEM China selling to customer located in China in USD | US37/CN36 |
CEM China selling to customer located in China in CNY (RMB) | CN41/CN36 |
CEM China selling to customer outside China | CN41 |
CEM US/EU selling to customer located in China | US37/CN36 |
CEM US/EU selling to customers located in APAC* | US32 |
*APAC countries to which this is applicable: India, Indonesia, Malaysia, S. Korea, Philippines, Singapore, Taiwan, Thailand, Vietnam
NOT applicable to: China, Japan, Australia. For these countries other Sales Areas can be used, e.g., DE13, GB40.
Appendix – List of transactions
System | Transaction | Use |
PRS | Z1S_CWF_REQUEST | Create customer Workflows |
PRS | Z1S_CWF_REQUEST_LIST | View customer workflow list |
PRS/RCS | XD01 | Customer creation |
PRS/RCS | XD02 / VD02 | Customer data change |
PRS/RCS | XD03 / VD03 | Customer display |
PRS/RCS | FI01 / FI02 / FI03 / FI06 | Create bank data / Change / Display / Delete |
PRS/RCS | SU01D | View user data per its username |
RCS | ZWOC06T | Create customer sales data |
RCS | ZWOC07T | Modify customer sales data |
RCS | XD04 | Display customer changes |
RCS | XD05 / VD05 | Block customer / Block customer (sales) |
RCS | XD06 / VD06 | Mark customer for deletion / Only sales view |
RCS | VA03 | Display sales order |
RCS | VA05 | List of sales orders (activity) |
RCS | VD51 | Maintain Customer-Material Info |
RCS | VD52 | Maintain Cust-Mat.Info w/Select.Scrn |
RCS | SQ00 | Querie's |
RCS | Z3F_FA_DOC_FLOW | Status of invoices |
RCS | ZWOC65A | Report for texts extraction |
RCS | ZZF_LOG_OF_CHANGES | Transaction ZZF_LOG_OF_CHANGES |
RCS/PI1 | FD33 | Customer Credit Management Display |
Appendix – Example of forms & documents
Example of documents for Chinese customers
| SP Horizontal nav group | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
|
Appendix – Credit Control Representatives
| Anchor | ||||
|---|---|---|---|---|
|
Credit department can be contacted by creating a Service One ticket:
Appendix – Parties to be notified
| GBU & Region | Type of change (process and sub-process) | Notes | Parties to be notified & E-mail |
|---|---|---|---|
| Technology Solutions - ALL | Sold-to customer: creation, extension, inactivation, re-activation Ship-to customer: creation, extension, inactivation, re-activation Sales manager assignment | Add tag Technology Solutions for all type of requests, except contact creations/changes. If tag is added, automatic notification will be sent to notify parties. Please specify in the ticket customer number, name, sales area (if applicable) and what has been done. For inactivation requests - mention accounts inactivated and their replacements, if applicable. | Pricing Team: gmupricing@solvay.com Global Demand Team: CytecGlobalDemandTeam@solvay.com |
| Novecare - EMEA | Sold-to customer: creation, extension, inactivation, re-activation Ship-to customer: creation, extension, inactivation, re-activation | Add tag NOVECARE EMEA for all type of requests, except contact creations/changes. If tag is added, automatic notification will be sent to notify parties. Please specify in the ticket customer number, name, sales area (if applicable) and what has been done. For inactivation requests - mention accounts inactivated and their replacements, if applicable. | Patricia Serra: Data-ecommerce-Specialist-NovecareCS.PT@solvay.com |
| Novecare - NAM | Sold-to customer: creation, extension, inactivation, re-activation Ship-to customer: creation, extension, inactivation, re-activation | Add tag NOVECARE US for all type of requests, except contact creations/changes. If tag is added, automatic notification will be sent to notify parties. Please specify in the ticket customer number, name, sales area (if applicable) and what has been done. For inactivation requests - mention accounts inactivated and their replacements, if applicable. | Novecare NAM Customer Service: novgeneralcustserv.na-us@solvay.com Patricia Serra: Data-ecommerce-Specialist-NovecareCS.PT@solvay.com |
| Aerospace | Sold-to customer: inactivation Ship-to customer: inactivation | When inactivate add the following information to resolution email: *Customer number *Sales area (Sales Organization/Division/Distribution channel) *Replacement account(s) (if such is available) | Global Demand Team for Aerospace (all 4 people MUST be notified): kp.nagabhushana@solvay.com |
| Useful contacts | |||
| Tax Department | New Sold-to or Ship-to creation, re-activation Sold-to or Ship-to (if customer extended to another Solvay entity) In the email subject mention Sold-to or Ship-to customer number and company code | SAP PF1 - company code 3384 (Solvay Fluorides, LLC) | Maria, taxnewcust.na-us@solvay.com and Tax administration team in copy, tax.certificates@solvay.com |
SAP PF1 - company code 4290 (Solvay Chemicals, INC) | |||
| SAP PF1 - company code 5782 (Solvay Specialty Polymers USA, LLC) | |||
| SAP WP1 - company code 7424 (Solvay USA, INC) | Maria, taxnewcust.na-us@solvay.com and Tax administration team in copy, tax.certificates@solvay.com | ||
SAP WP1 - company code 7008 (Cytec Industries, INC) SAP WP1 - company code 7180 (Cytec Engineered Materials Inc / CEM US) | Carolyn, na-us.cytectaxdept@solvay.com and Tax administration team in copy, tax.certificates@solvay.com | ||
Appendix – Queries
To extract data from SAP you can use two transactions:
- SE16 - used to extract data directly from data tables (instructions can be found in Miscellaneous Tasks)
- SQ00 - predefined queries, used to extract data. These queries have different tables already combined. Please see details below.
To start using SQ00 queries please switch to Standard query area: Environment → Query Areas
To view specific query, double click on the query name in the list. When its name appears in Query field, run the report by pressing .
To see details on what information will be returned by the query, use .
There are multiple user groups with different queries available. To switch between them use . Please see below list of some useful queries.
| FUSION | |
|---|---|
| Address list |
|
| Sales Area data and Partners | FUSION_CU_VEN2 |
| Company Code data | FUSION_CU_SOC |
| Contact persons | FUSION_DB_CON2 |
| Partner functions | FUSION_CU_PART |
| Credit data |
|
| Customer – Material Info records | FUSION_FIV |
| Extra Master data links | FUSION_CU_BASE |
| NOVACARE_EDA | |
| Sales Office x Sales Group | OFFICE_X_GROUP |
| Contact partners per sales organization with emails | CUSREQDTA2 |
Appendix – Contact Persons & Partner Functions
| Anchor | ||||
|---|---|---|---|---|
|
There are two types of contact persons:
- Based on the contact information (MSDS & COA receiver, Invoices receiver)
- Based on the physical address information (Notify partner, Consignee etc.)
Partner functions numbers can be set up as:
- Contact persons (Invoices receiver; COA & MSDS receiver etc.)
- An actual customer/vendor accounts (Ship-to, Bill-to, Vendor etc.)
| Note |
|---|
The list of contact persons and partner functions listed below is not complete. Below is the most commonly used ones. |
Contact persons based on the contact information
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
In all: Contact person, Function, Last name, Remarks, Language, Telephone, Mobile, Fax, Email, E-mail, Method |
Contact persons based on the address information
| SP Horizontal nav group | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
In all: Contact person, Function, Last name, Remarks, Language, Telephone, Mobile, Fax, Email, E-mail, Method, Address |
Other partner functions
Existing customer and vendor accounts can be added in partner functions.
| Partner function | Name | Description | Can be linked to |
|---|---|---|---|
| CR | Forwarding agent | Carrier or forwarder used to deliver goods to the customer. For Aerospace sales areas:
If new customer carrier is requested, create ticket to DM vendor team* to set up customer carrier. Provide customer checklist along with the request. *In order to create a Task to DM Vendor Team these are the steps: and classified the Task like this : | Sold-to, ship-to |
| SB | Spec. stock partner | Consignment customer (SB) is used if Consignment inventory is monitored at the ship to location level. Meaning at sold-to level it is OK not to have SB partner, since it means the inventory will go at the ship-to level. SB partner number = SAP code of the same sold-to or ship-to identified as consignment. | Sold-to, ship-to |
| ZI | Int. CSR Contact | ZI is Internal Customer Service Representatives personal number. Its creation is performed by IS-CGI-L3-OTC | Sold-to, ship-to |
| ZN | Int. CSR Contact | ZN is the same as ZI internal contact but for more logistical monitoring and intercompany replenishment orders. Most commonly used by APAC Customer Service Representatives. | Sold-to |
| ZL & ZA | 1°Commissioned agent 2°Commissioned agent | Beneficiaries of commissions are partners (ZL or ZA) associated with a sold-to party.
Commissioned agencies are recorded as vendors with account group ZXAG. Search "8: Vendor by account group, country, bank datas" can be used. | Sold-to |
Appendix - Requirements for Tax Numbers
| Anchor | ||||
|---|---|---|---|---|
|
| Embedded Google Drive File | ||||||
|---|---|---|---|---|---|---|
|
Appendix - Customer credit status and credit limit check in PI1
It is possible to check, whether credit limit has been already assigned to the customer and whether there are no credit blocks, which prevent order creation (order goes on block).
Credit limit and credit status can be checked in system PI1 through transaction FD33.
| Field | Description |
|---|---|
| Customer | PRS payer number |
| Credit Control Area | always 'SOLV' |
| Field | Description |
|---|---|
| Credit limit | Upper limit for the total receivables and the foreseeable receivables from the customer. The total receivables results from the open items (invoices minus credit memos and payments) plus selected special G/L transactions (for example, down payments) |
| Cred.rep.grp. | A customer can be allocated to a credit representative group for credit control. This credit representative group is copied into the order and can be used as a selection criteria for evaluations and release functions. |
Credit status must be 001, otherwise order will go on block. Status changes to Inactive if 12 months with no orders.
Appendix – Existing SAP customer creation in CRM and merging of existing CRM accounts
When extending sold-to and/or ship-to to sales areas belonging to GBUs that use CRM, check whether SalesForce ID is present.
You can check for SalesForce CRM Customer ID in customers Extra Master Data. If the customer does not have this ID, we need to ask for it to be established.
To create Salesforce ID submit request to CRM team
| Field | Description |
|---|---|
| Request type | IS Request |
| Subject | Salesforce ID creation |
| Process | Salesforce CRM (OtC) |
| Application | CRM - Salesforce |
| Description | Could you please create SalesForce ID for (Sold-to/Ship-to) PRS ####/RCS ####? |
There are some cases when we will have two SalesForce accounts for the same customer:
- Duplicate customer creation requested through SalesForce. Even if we reject the workflow a new SalesForce ID is generated;
- Duplicate customers exist in SAP.
In such cases we should request merge of the SalesForce accounts.
| Field | Description |
|---|---|
| Subject | Core CRM - Accounts to merge |
| Assign to | IS-CGI-L2-OTC |
| Type | IS Request |
| Subtype | Support |
| Functional Area | Salesforce CRM (OtC) |
| IS-Process | IS OtC |
| IS-Subprocess | CRM |
| IS-Category | SFDC - Account and Contact |
| Application | CRM - Salesforce |
| Description | Could you please merge these SF accounts? Customer INTEL ELECTRONICS LTD
Thank you |
When SFDC ID has been created, Data Management must add the ID in PRS & RCS, if it has not been populated by the system automatically.
| Note |
|---|
Please note that Payer & Bill-to accounts will not have SF ID, as these account groups are not maintained in CRM (except accounts that has the double function as sold-to and payer). |
Appendix – Miscellaneous tasks outside DMO Riga scope
| Anchor | ||||
|---|---|---|---|---|
|
Reference data and link maintenance
APDM team creates and maintains following reference data:
- Link between Sales group and Sales office
- Link between Sales office and Sales organization
- Link between Plant and Sales organization/Distribution channel
- City codes
- Payment terms
- Transportation zone
- etc.
You can see, that reference data or link is missing, if there is an error informing of a missing link or if you cannot find requested value among available selections.
In this case ticket to APDM team has to be created.
Bank details maintenance
Bank details maintenance is outside of DMO Riga scope and whenever we are requested to add bank details or we have to do it for China (mandatory requirement) follow the steps below:
Country | Comment |
|---|---|
China | CSRs provide bank details in PDF containing customer name, bank name, account number with a stamp on it. When Payer code is generated in PRS an email should be sent to the indicated email. |
Japan | Japanese customers are automatically by a program enriched with virtual bank accounts. For invoice, the customer must have the pledging indicator 'FA' to indicate it is 'factoring allowed'. Then the system is set-up to retrieve the virtual account for the bank data on invoice. |
Other countries | Customer sends confirmation regarding bank details directly to Lisbon team. Bank details additional usually is requested by AR/Collections. |
For RIBA / cash-in and direct debit the process is different – everyone can require the update of bank details (mentioning one of those 3 payment methods) and bank details are added immediately, without any confirmation from customer (no risk, money is cashed-in).
If bank details should be added by APAC data team, duplicate your ticket, change description and assign to their group.
Service customer accounts
When receiving a request to create Service customer account from Finance team (RtR) - ticket needs to be transferred to RtR Intercompany group (they will validate, provide guidance, which template needs to be filled, since it differs from ordinary customer setup template) and then request will be completed by Data team in Lisbon. No additional action should be made from Riga Data side.
Service customer accounts are made to issue Invoices only, therefore no Sales data are maintained nor orders will be created. In SAP these accounts can be without Sales area extensions and only as Payers. If while searching for duplicates such accounts are found, please check with Credit management if there’s any credit history or invoices in order for this account to be used further or if any other changes can be made.'
In case if sales area data needs to be created - request can be processed by Riga Data Team (Novecare, TS, Composites) or by Customer Service (all the rest of GBU).
Appendix – Display changes made in sales order
Transaction VA03
Search by order number or sold-to customer
























































































































































