============================================================

============================================================

Communication process for late RCS data (For PPS , PPE and ICARE )

Normal Case

In most of the case , we should receive the exploitation Emails of the 3 applications PPS, PPE and Icare before 9h00 Asian Time ( or before 10h00 if it's winter Time in Europe )

JBU Universes loading schedules

Asia Pacific Non-RCS data loading & monitoring procedure ( AP SALES For Premier Economic PPE )

Introduction

Part of the sales data named Premier Pilotage Economics(PPE) Sale Data for 7 NON-RCS entities

Contacts of key users

Procedures

Material Creation

1. When local ERP system create a new material(saletable Material) AP Sale Entity will sent local material information to EDA request for a RCS material code.
2. EDA verify if local material code already exist in the RCS. If not existing, EDA will create new RCS material code.
3. Wait for new transaction flow into PPE.
4. When EDA created new RCS Material, and the new transaction is in PPE Ailin will map the code via QuikLoad.

PPE Markets and FC Comparison

After D4, When FC report is ready(closed), Finance controlling(Iris Hor for Novecare) will compare FC data with PPE in market leave for each entitise, if the data is not tie, She will request the accountant adjust the AP SALES data, and run the Manual Treatment load data into PPE again.

LOCK DATA 1. When PPE=FC, Iris will lock the data online on the link, after the data is locked, The previous month PPE reporting is closed.
2. http://frparboadm01.rhodia.rp/APSales/LockData/Default.aspx

Manual Treatment

Why need Manual Treatment in AP SALES?
AP SALES system is a semi-automatic system, Finance controlling request each of entities have accuracy data in PPE. For pervious month data, we will run Manual Treatment upload PPE data.

• Operating Access tool: Hands on* Verifying DATA:

For 4 APSALES Entities –BREC 6183, RSCI 6059, MANYAR 7378, RTH 6066 verify data in Market Level.

For Entities - WuXi 7737, Novacyl Thailand 7661 just verify the grand total.

1. Open Microsoft Access.
2. Save the countries zip file into own drive
3. Import
4. Summary
5. Important Note: Before D5, local user must verify QTY & Sales. After D5, Iris Hor must verify the CM.

TRANSFERRING DATA 1. Run Filezilla
2. Server : sgrapwb01
3. User:
4. Password:
5. Folder : china, Host sgrapbw01
6. Important note: India PPE_DATA_6059 DOES NOT has .txt, unlike the other 3 countries
7. For FEIXIANG: There is a different user/password folder

• User Id : *
• Password : *
• Folder : RFX
• Host : sgrapbw01
  
  

SEND EMAIL Send e_mail(the file) to CAZAUX-EXTERIEUR, Frederic, request run manual treatment at the other server

AD-HOC Troubleshoot: Missing File

Function of PPE_check.mdb
1. Upload the data flat file into to table PPE_DATA, and convert to PPE_SOURCE.
Enter the correct path and file name of the data flat file.
Press the button “Import” Access will Import the data from data flat to table PPE_DATA. And convert data into
table PPE_SOURCE.
There are same fields in table PPE_DATA & PPE_SOURCE. The different between them are, all the number field type in
PPE_DATA are text, but in PPE_SOURCE are double number.
2. Convert data between PPE_DATA & PPE_SOURCE.
In table PPE_DATA if you need to change a number field value, you have to use the special PPE format which define in
“Field definition.xls”, like -00000000000123123(-123.123), But in table PPE_SOURCE you not need to consider the data format.
So what you can do is change the figure in PPE_SOURCE and press button “Convert PPE_SOURCE to PPE_DATA
3. Summary by market.
It can verify whether the total of the data flat file is correct or not.
4. Export Data to Flat File.
The function can export the data in PPE_DATA into a text file, and the text file is in PPE format.

Monitoring of the AP Sales

1. In BO folder 93 schedule report : Every Tuesday & Friday, and every 5 working days at the end and first of the months;
around noon time, these report will be cast to end uer.

2. Total 5 reports:

• PPE Incomplete Transaction - BREC 6183, - PPE Incomplete Transaction - MANYAR 7378,
• PPE Incomplete Transaction - RTH 6066, - PPE Incomplete Transaction - RFX 6526, - PPE Incomplete Transaction - RSCI 6059

3. Check Market Tab: Whenever spot an error of market different between Local and RCS market, the local entities must change.

• RTH correct in Material,
• BREC correct in the Sale order, but RFX cannot change in their SOLD to.

4. Check Material Tab: Material name field is UNKNOW mean local code does not map into RCS code. Foo Ailin use QUICKLOAD
to correct the material mapping.
5. GENERAL Info: Tab: Explanation of ERROR IN REC /recycle tab. Case Study on Manyar dated 22/5/12
“not in GBRUSR.LIB_ENT/91BS021-2121-APSALES not in GBR_DC.GBR_PRODUCT/16-00-2012 not in GBR_DC.GBR_ORGANIZATION/”.
Division is wrong 00. Usually error occur on NEW Material.
6. Feixiang is special: CHECK MARKET tab is usually long. Almost 80%-90% of the common error comes from Material creation &
IERCA. Only 1 rule apply, which is the DC x DIVISION. Uses PPE DATA report to FC, instead of the local DATA.
7. DC : Control by the Local PPE application.

• RTH put DC into the Material.
• BREC put DC into the Sale Order.
• RFX put the DC into SOLD To.
• All the 3 local PPE applications are maintained by Jeff/Technical support. Manyar and India have their own IT team
  to maintain.
  8. DIVISION: Control by EDA/Enterprise Data Admin in RCS Material Division. AP SALES=LOCAL Data report to the FC.
  Feixiang=PPE Data report to the FC