1. Objective and Scope

1.1. Objective of this Operation

This procedure explains how to extract the report to be sent to the controllers after Standard Cost Estimate.

1.2. Scope

This procedure applies to company 7523.

2. Definitions

See Finance Glossary:

• SCE

3. Tasks description

3.1. I extract the information

After executing SCE (Standard Cost Estimate), go to transaction CK40N and get the spool of it.

Extract it to Excel.

Save it with the name:

• "RTR.IAC01.02 LOG CCCC YYYY-MM-DD".

Where CCCC is the company code

           YYYY is the current year

           MM is the current month

           DD is the day

Go to transaction "S_P99_41000111".

• Variant : 7523 SCE.

Check if the date is correct.

E.g.: For June Cost Estimate which is executed in the end of May, the date must be 01.05.2016 to 31.12.2016.

Execute it.

Extract it to Excel - delete the columns/lines in blank, copy all data and paste in the file "RTR.IAC01.03 CK40N YYYY-MM"  in tab "Dados" column C3 if it is the first running (for the second running, insert it after the last cell with information).

turn columns A and B into numbers, change column E from bar to point and delete the column P.

Delete all lines in blank and let only the lines which begin with material number.

Go to the file "RTR.IAC01.03 CK40N YYYY-MM" in tab "Dados" column C3 and paste the extracted information, if it is the first running insert number 1 in column R (for the other Runnings always insert 2), if it is the second running go to the last cell with information, let one line in blank and paste the information.

For the columns A,B and S always check if the formulas are until the end.

Go to tab "Plan 1", select the 2 months that appear in the cell B1 and update the pivot table.

In tab "Plan 1", you will find the information for the company (7523).

Copy the data from columns B and C from the company and paste in the correspondent tab - paste only values from cell B5 onward.

Press F9 to update the information.

In the cell B2, insert the information regarding the Cost Estimate executed.

Update the months in cells C1 and C2, considering C1 for the current month and C2 for the next one.

In the cell D2, inform the date and time of the execution of the report "S_P99_41000111".

Check if column J contains errors, if so, go to transaction SQ00 and extract the following report.

Go to transaction SQ00 - Query Group  Query"ZWBR_100".

Insert the material numbers which were not found and execute.

Extract it to Excel and paste in tab "CL" after the last line with information in column B.

In column A, check if the formula is until the end of the information.

After filling tab "CL", go to tab "7523" (company code) and update it again with F9.

Check if there are errors in column F.

Save the tab correspondent to the company code in another file with the name "RTR.IAC01.02 CK40N 7523 YYYY-MM-DD". 

3.2. E-mail Group to be sent:

• SCE_Report_fechamento_LAM@solvay.com
  

3.2.3. E-mail

Subject of the e-mail

"7523 - Validation until 27/05/2016 08:00 hs - 1st Standard Cost Monthly Review"

For the first execution sent in D-5.

Text in the email:

Follows the 1st calculation finished today

Please check and inform if there's is a need for the 2nd calculation according to the deadline describe in the title of this email.

Please consider the points below:

• There are materials funded with error (KF status), please check
• There are also materials with a derivation above 50 and some with high variation, please check these cases as well;
• Non-funded materials for April/2021 that are blocked with Z0 or Do not Cost in the masterdata were flagged in the comments column.

The error Log file is attached for verification.

End of document.