1. Objective and Scope

1.1. Objective of this Operation

This document describes how to book accrued logistic cost (transportation and warehousing) for China companies.

1.2. Scope

This procedure is applicable to the following company codes:

• 5876: SSCL (SOLVAY (SHANGHAI) CO., LTD.) 
• 5991: SSPC (SOLVAY SPECIALTY POLYMERS (CHANGSHU) CO., LTD.)

2. Definitions

See Finance Glossary:

• ERP
• GL
• PO
  
  

3. Tasks description

3.1. Responsibilities

Local:

• Logistic team will send GBS MASU  Bangkok the TPT files on D-3.

GBS MASU  Bangkok:

• After receiving the files from Frances Wang, the team will prepared the file for posting in ERP. Within Day+1 and reverse corresponding earlier accruals.

3.2. Periodicity

This procedure is performed each period in monthly closure on D+1.

3.3. I prepare and submit the monthly billing for logistic cost (please confirm this title)

Principles: This procedure is applied to the China companies that don't have logistic module. These companies have to post accrued logistic cost due to invoices will be received after the costs occur around 1-2 months.

Some notes:

• Inbound cost occurs due to the company ships inventories to warehouse
• Outbound cost occurs due to the company ships inventories to customers. 
  
  
• TPT: Transportation costs related to sales from plant/warehouse to customers

1. 1. proportional to sales
   2.  in ZFC-R12910, above contribution margin 

• Depot: Warehousing costs related to purchasing from our vendors to plant/warehouse

1. 1. non proportional
   2. in ZFC-R25510 , btw contribution margin and gross margin

3.3.1. I download the files in shared drive (please confirm this title)

Save files in shared drive >> X:\G3S\CTB\CHINA\TPT_DEPOT

3.3.2. I extract the necessary information

Find out for the Material, Plant, Destination from DO or PO in file as below steps:

1) Outbound Delivery Report

Use transaction code : VL06F

• • Fill company code in Sale organization field.
  • Fill document create range in Created on field (Maximum is one year).
  • Execute.

• • Choose Item View.

• • Change layout to VL06F_REPORT that consists of Delivery numbers, Material numbers, Plants and Destinations.

2) Outbound Delivery by Item

Use transaction code: VL03N

• • Fill outbound delivery number in Outbound Delivery field.
  • Click Overview  or Press Enter.

• • Find Material number and Plant.

Plant Material

Besides finding Material and Plant. We can find destination also as below:

• • Click Heading Details  from Outbound Delivery Display.
  • Click Partner tab.
  • Double click ship-to party line.

• • Find Destination in country field.

Destination

3) Purchase order by Item

Use transaction code : ME23N

• • Click Other Purchase Order 
  • Fill Purchase order number in Pur. Order field.
  • Enter or Press Other Document will find Material Number and Destination.

Destination Other Purchase Order

• • Double click as Material field will find Material and Plant.

4) Standard Order by Item

Use transaction code: VA03

• • Fill Stand order number in order field
  • Click Search or Press Enter

• • Find Material and Plant as detail below

Material Plant

Besides finding Material and Plant. We can find destination also as below:

• • Click Display Doc. Heading Details  from Standard Order Overview.
  • Click Partner tab.
  • Double click ship-to party line.

• • Find Destination in country field.

Destination

5) PO. Detail

• • Run transaction SQ00
  • Go to Environment in menu tab,
  • Choose Query area and choose Global Area (Cross-client).

• • Select MEPO and Execute

• • Fill 999999 in the Max. no. of hits field
  • Fill company code and Purchase Document range field and then execute.

• • Click ALV layout

• • Change layout that consists of purchasing documents, material numbers, plants and destinations.

• • Export the data as .XML

• • Apply VLOOKUP for looking for material numbers, plant and destination by using the PO and DO number as reference.

• • Create pivot table by using the red-flame as picture above

 



By the way, For DGF HK file or Other file if not local currency should be convert Hong Kong Dollar currency (HKD) to Yuan Renminbi (CNY) currency. 

3.3.3. I prepare the posting

To prepare the posting Depot/TPT have different costs types and wish to separate them by different G/L accounts following as GL detail table below: 

Example

• Dr. 6144008610 xxxxx
• Cr. 2330000000 xxxxx 

GL detail Table : 

End of document.