1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to explain how to check the variation in stock accounts (Balance sheet) compared to the consumptions in 6* accounts in the P&L for specific cases.

1.2. Scope

This procedure applies to all BE companies.

2. Definitions

See Finance Glossary:

• Add if necessary

3. Tasks description

3.1. Responsibilities

Responsibilities of SBS-BO(change BO):

• Check the variation of stock at D+6 in a monthly basis for all Belgium companies;
• Post the correspondent adjustment, in the last day of the closed period, to correct the variation of stocks on a monthly basis;
• Check if the variation of stock was corrected after the posting.

Responsibilities of Local Finance:

• Check if the adjustment posting done has been performed correctly.

3.2. I run the report S_ALR_87012284

Go to report S_ALR_87012284 and choose the variant below by clicking in 

In the report, fill as the example below for, choose your company code and execute 

Extract the outcome to Excel:  

• Export - Spreadsheet

1) Select - Excel (In Existing XXL Format)

2) Select - Table

3.3. I check the absolute difference

Timing defined in closing task list, after receiving the last commission croco invoices (invoice + cost imputation). (change croco)

• Stage 1

  We should check the absolute difference between the value that is cumulated until the month that we are analyzing and the total amount of the stock in beginning of the year (that is the amount in stock in the end of the previous year ) as the example for month 06 2008:

Look for the account  2010010000 Produits finis achetés-val acq MM

The value marked in red should be compared with the following 6* accounts from P&L by doing the sum as demonstrated:

200806

+   B: Var en-cours fabric, PF et cdes   71               +1.243.265,18
 

-    609400001 Variation ETC                                  -(-119.227,88)
 

+    2.Variation des stocks                                       +(-2.159.515,82)

+    6310000000 Stocks-réd val                              + 0
_______________________________________________________________ 

        Total Amount                                                   -797.022,76

Now we should compare the  Absolute difference in Stocks  with the  Total Amount :

786.513,39 + (-797.022,76) = - 10.509,37

This means that we have to do a posting to adjust the variation of stocks in 6* accounts according to the total variation in stock accounts (balance sheet).

Before doing this adjustment, check if the Croco Regul (change Croco) has run for all the Belgium companies in the closing month and if there are no pending movements with the concerned company.

Use variant 3S-BELGIUM (change 3S) to perform the check in transaction Z1F_CROCO_REGUL. (change CROCO)

This check is automatically done in the template file attached.

• Stage 2

Perform the following operations in posting file attached.

Copy the Excel extraction and paste it in sheet “Report”.

In sheet “Calculations” insert the report date on cell F3 with format DDMMYYYY (the last day of the closed month will be the posting date. Open the concerned accounts in OB52 for the closed period). Fill in the yellow field with the concerned company code in cell F10.

Save it and upload it through transaction ZZF_POSTING_FILE.

Attach the excel file extracted in report S_ALR_87012284 justifying the calculations made to the document posted via OAOR transaction and save it in M drive. (change M drive?)

3.4. I perform the ETC check

This check is done for company 0001.

We should check the absolute variation between the value that is cumulated until the month that we are analyzing and the total amount of ETC in the beginning of the year as the example below for month 06 2008.

Look for the cell with the account  B. Commandes en cours 37 :

2170000000-Commandes en cours d'exécution

2140000000-Stock ETC

2160000000-Acomptes verses s/achats sur stocks

The value marked in red should be compared with the following 6* account and 7* account from P&L by doing the sum as demonstrated.

+ 609400001 Variation ETC                             +(-119.227,88)

+ 7446400001 Acomptes sur ventes ETC        + 15.958,17
___________________________________________________________ 

Total Amount                                                    - 103.269,76

Now we should compare the two values of the Absolute Difference and Total Amount

103.269,76+ (-103.269,76) = 0

In this case the check is ok and there is no posting to do.

This check is automatically done in the template file  attached .

3.5. I perform the final check

After the posting we should check again as in the previous steps the report S_ALR_87012284 .
 

This check can be done manually as described before or it can be done with the support of the excel file as described in page 7.

In sheet “Calculations” the adjustment posting should be equal to:

3.6. Person to contact (please change the title according the methodology: I "do" something, e.g. I inform ...)

End of document.