Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Domain: Country Accounting 1. Enter the Domain identified in OPD matrix (for Country specific operations, Domain = Country Accounting) |
Responsibility area: 2. Enter the responsibility area described in OPD matrix ("N/A" for Country Accounting Operations) |
WHY - Describe the objective of the operation
The purpose of this document is to explain how to prepare and validate the intercompany position for Chemplex 1430 company code.
BOIC team and the Chemplex controller needs to validate the intercompany position for Chemplex, the accounts payable and receivable by partner.
Detail the scope (legal entities, etc.)
This procedure is applicable for 1430 company code monthly.
It is done on D+2 in the morning.
Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary
See Finance Glossary:
WHAT and HOW - Main content of the operation
The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.
Select the level of heading in the "Paragraph" option.
There are 2 files that you need to receive.
The first one is the position of accounts receivable from the companies that have AR with Chemplex. This is shared by Intercompany Team through email on D+2 morning.
Normally it is one file for 7424 and other file for 4044, which shows the items already factored in 7424 to CICC.
Check the file and delete any line in headings that begin with L*. Then, it will only let the AR part in the file.
The second file is the AR and AP intercompany control in Chemplex side. This is shared by the Chemplex controller and also through email on D+2 morning and the file is named in Gdrive as "Chemplex Intercompany AR and AP".
AP position in Chemplex:

AR position in Chemplex:

Intercompany Sales in Chemplex:

With both files in your position, sum the total value in the AR files from 4044 and 7424 received from intercompany team and include in the Gdrive file "Chemplex Intercompany AR and AP" received from the Chemplex Controller. Include it in the AP part in yellow cell, normally C8.
This will show a difference between SAGE and SAP, which the Chemplex controller will book in SAGE to clear the difference. If this difference is too high as $2M adjustment, check the list of the AR from 4044 and 7424 and try to find what is causing this high difference. It can be one invoice not considered in SAGE or other things. If the difference is around or less than $500k, than it is ok.
After that, send an email or through the applicable tool to advise the Chemplex controller with the print screen of the adjustment value to be booked in SAGE (Chemplex side).
Include the CAM and the subject can be "Chemplex BOIC Position - MM.YYYY". This email is sent on D+2 as soon as you have the information.
With this, you validated the accounts payable intercompany position.
BOIC team does not have access in SAGE to extract the intercompany data to upload in BFC, so we need to send them a file with this information for AR and AP per partner.
Then, create an excel file to share it with intercompany team.
Include the AR position in the file and you can collect the information per partner from Chemplex Intercompany AR and AP AR part:
Chemplex AR (shared by Chemplex controller):

Include the AP position in the file and you can collect the information per partner from the files shared by intercompany team for 4044 and 7424.
Also, go to transaction FS10N - 57000400 in 7424, get the account balance and include in the Loan part of the excel file (below the AR Balance) against signal from 7424.
Below you see the excel file as it should be:

It can be found in Gdrive folder 1430 - Chemplex Prepare and Validate Intercompany Position
After that, send it by email or through the applicable tool to intercompany team, specifically who deal with Chemplex company code and US:
Juliano Neves (intercompany Specialist) - juliano.neves@solvay.com
Luiz Franco (intercompany Specialist) - luiz.franco@solvay.com
Ana Luisa Rafael (intercompany Team Leader) - analuisa.rafael@solvay.com
and the CAM;
the email subject can be "Chemplex 01430 Interco AR and AP for BOIC MM.YYYY"
With this, they can upload the information on the Chemplex package and the other companies packages that have AR and AP balances with Chemplex.
End of document.