=======================================================================
| Table of Contents |
|---|
=======================================================================
==> Since mid-september 2020, the interface is PAUSED in BI4
(replaced by the new SAGE-BW interface)
Chemlogics sales are sent for Novecare, from a non-SAP source (Chemplex source is named SAGE)
They are related to legal entity "0143 - CHEMLOGICS"
Chemlogics sales are received in PPE only (finest detail by customer/material)
Our contacts on Chemlogics side for the interface are Mark Farrales & Kenneth Long
Customers :
File Transfer
Files are sent from SAGE (chemplex) to BI4 using NFS copy
This step is on Chemplex side
Once the file is created in Chemplex side, ,NFS copy files to exploit/arrivee
SAGE server
IP address for CHEMSQL 10.169.168.7
IP address for CHEMSQL 10.169.25.163 / server 150.251.116.33 → changed on 23/10/2019 due to VLAN migration
IP address for CHEMSQL 10.76.120.4 / server USCEKDB01 → from 15/11/2019
FTP access via ftp://10.76.120.4:21
Physical path is: \\uscekdb01\C$\inetpub\ftproot
Credentials: User : SolvayFTP; PW : *f\?CD?= (those can be changed if needed)
Customers
frequency : daily
received in PPS : /exploit/PR_PIL/PEP
...
source code in BI4 : CHEMPLEX20
In SAGE, Payer represents a master sales account, and Sold-To represents any of potentially numerous decentralized purchasing units per master account.
Because of this, Chemplex uses the Payer account to consolidate and monitor sales. It's the de facto equivalent of Sold To in SAP.
Then :
Sales :
SAGE-Payer=RCS-Sold-To=RCS-payer,
SAGE-Sold-To = RCS-Ship To.
Customer codes with letters (Master accounts) are like the distributor concept
Sales
frequency : daily
received in PPE : /exploit/PR_ECO/DW2
...
source code in BI4 : CHEMPLEX20
Sales and quantities are updated daily in SAGE ==> updated daily in BI4
But logistic costs are frozen and updated only once a month in SAGE (at end of month). nb : Logistic cost = R12910 in P&L
Materials
no file is received for new Chemplex materials
When sales are loaded, new materials are created in PE_DC :
And then transferred in PEPDBA.MARA → GBR_DC.GBR_PRODUCT
nb : by default all Chemplex materials are allocated to material division=UZ