1. Objective and Scope

1.1. Objective of this Operation

For the freight costs between Rhodia Polyamida plants or Rhodia companies, the invoices are manually done, not allowing the direct entry on the material (only in cost centers). In order to adjust these amounts for the correct IECRAs, it is used assessment cycle 752310.

1.2. Scope

This procedure applies to company 7523.

2. Definitions

See Finance Glossary:

• IECRA

3. Tasks description

3.1. I perform the assessment of freight costs subcontracting

For performing the assessment of freight costs subcontracting it is necessary to update the cycle 752310.

3.2. I extract the necessary information for updating the cycle 752310

Enter in transaction KSB1, use the variant "TRSP MANUAL"  and layout "/FREIGHT"

• Controlling area: Z025
• Fiscal Year: Current year
• From period: Current period
• To period: Current period
• Plan Version: 0
• Cost Center: 7523-7001 and 7523-9106
• Cost Element: 98120010, 98150970 and 99429900
• Posting date: Current period

Execute

Copy this information for the file LAM - Support Freight Costs Analysis and Allocations.

Add insets to sheet KSB1 in columns A through F.

Copy the information from column F into column G in yellow

Fixed all the formula on column H so it result the correctly shipment code.

For example:

In the text on column G the shipment code starts from the fifteenth character (4582347)

In the formula on column H the second criterion should be fifteen because the shipment code starts in the fifteenth character 

This way the formula will result in the correctly shipment code the contains seven digits and starts with 4

Fix all the lines in which the formulas on column H isn't returning the shipment code that starts with 4 

3.3. I identify the materials using transport code

The purpose of this report is identifying the materials using transport code.

Go to transaction "SQ00", click on "Environment", select "Query areas" and change it to "Standard".

After click on     and change group of Query to ZW_BR_OTC.

Select query TRANSP_2 and press .

Add column H value (transport) in the Shipment number on SQ00

Execute .

Select all the data, copy and paste in sheet SQ00_TRANSP_2, in support file.

 Paste the extraction into spreadsheet and turn it into numbers.

3.4. I verify which profit center is in accordance to the material by plant

Copy information from sheet KSB1 generated in column I - Material go to transaction ZWFAI052 - Use variante TRSP MANUAL

• Controlling area: Z025
• Current Date: Last day Current period
• Language Key: EN
• Plant: Add Informations from sheet KSBI - Column A
• Material: Add Informations from sheet KSBI - Column I
  
  

Execute 

Copy informations on sheet ZWFAI052.

After verify on the sheet KSB1 in column J - IECRA

Update pivotable from sheet 752310

This information will be used to update cycle 752310

3.5. I update the cycle 752310

After performing the steps above you should update the cycle, so that these values are properly allocated to each IECRA.

Go to transaction KEU2. For Operating concern, inform Z025.

 In the next screen fill in with cycle.

 Then press Enter after press overview segments

Select segment “7523-7001” and then the segment "7523-9106".

In tab “Receiver Tracing factor”.

Add value in the amount

Return to the file in tab "IECRA I" and check the IECRA and values to be updated.

And press save.

End of document.