This procedure describes the check between the Module Material Management (MM) and Module FI. 

The check is performed on a monthly basis, on D+2 after all postings are performed (when MMRV transaction is already close) and before the BFC stocks upload for both systems.

Scope

  PF2

Frequency

Monthly
References




Attachments  

 


xx  << I Control of FI-GL and FI-MM >> xx


  Guideline  

 


STEP 1

Enter transaction MB5L 








For PF2 and WP2




STEP 2

Please enter the following selections:

For PF2

Company Code : XXXX

Flag : Select balance, previous perio

Flag: Display Indiv. Matl Lines

Scope of List: Display indiv. matl lines

Layout : /BESTÄNDE (PF2)



 

 

 

 

For WP2

Company Code: XXXX

G/L account: 31000000 to 39999999

Period: Select balance, previous perio

Scope of List: Display indiv. matl lines

 





STEP 3

After press the bottom Execute  the following screen will appear


PF2









WP2



 

 

·         For PF2:

Once the report is displayed, check the values in column variance. If the amount is different to zero column this means that there is a difference between FI and MM. This check should be done for all stock accounts (check page down until the end or the report).

 In this example we have a difference in account 2000010000 of  99.331, 00 €.


  • For WP2:

In this example we have a difference in account 31000100 of -84.382,01€


Go to  report S_ALR_87012332 and use the following parameters:         

  • Select the variant 3S-FIMMCHECK;
  • Select the account(s) that is generating the difference;
  • The company code and execute.


Considering the previous example, the postings generating difference is from 2007:

Once the posting that is generating the difference is identified, report to Company Accounting Manager (in this case there were manual corrections done in FI but not in MM, therefore generating a difference between the two modules).

Enter in Transaction S_ALR_87012277 and select the Variant:

  •  SBS_STOCKS  - For all companies

 

Then enter the company code.



How to check the total amount of stocks?

 

Check if cumulative amount in the Stock accounts is the same as in Stock Module.

  • S_ALR_87012277

  • MB5L


Compare if the total amount in the accounts match with the total amount in Stocks.

Inform the Company Accounting Manager responsible that the check was done and include your analysis.

  • For WP2 companies nothing to do.
  • For PF2 companies check also negative stocks



  • In WP2, it is not allowed to have negative stocks.
  • In PF2, only some companies are allowed to have negative stocks (please check the attached file "Detail plants with stock negative").


In PF2, how to check negative stocks

Go to transaction MB5L and enter the following selections:

  • Company Code : XXXX
  • General Ledger Account : from 200000000 to 2199999999
  • Period: Select  Balance,  Previous Perio
  • Scope of List:  Check “Negative Stock”
  • Layout : /BESTÄNDE (PF2)

And press Execute

After press execute you will receive the following warning message and then press "Enter" to continue.

  • If you receive the message , it means that everything is ok.
  • If there are negative stocks the flowing screen will be displayed and you will find the inventory accounts with negative stock. 


  1. For each account that appears with values (highlighted in green or in red):


  2. Double click and check the materials with negative stocks (marked in red)

Additional Transactions for Support (for PF2)

You may also consider cross reference the material with negative stock with the following transaction:

Example of a negative stock in MB5L

The transaction MR51 allows a better overview of the material posting documents, filtering the period and material(s) in error.

You will receive a warning message

and you just press “Enter” to continue.

In the example above we can see there is an unmatched document that is probably missing a movement. This information can be shared when communicating errors.

Send Analysis to the Controller or CAM (in case of CBS Companies)

Inform the Controller or CAM (in case of CBS Companies) responsible and provide one explanation/analysis including:

  • Company Code
  • Account Code
  • Amount in FI-MM
  • Amount in FI-GL
  • Difference

 

1 Comment

  1. Hello Ana Gonçalves and ROLLIER, Charlotte !

    I had a look to this  OP and I  take the liberty of making some suggestions:

    • Step 3 under "Execute MB5L"  for WP1 : 
      As in step 2 it is indicated to flag the option "Scope of List: Display indiv. matl lines" I believe it is better to put a screencopy that shows the result of this report according to the option chosen ( as the current one doesn`t show the report by individual  mat lines). For instance:

     

    • Analyze Output : I would recommend  to replace  " For PF1 system or ERP Solvay " by "For PF1"   and  "For WP1 system or RCS" by "For WP1"

    • Check negative stock : As we specified  that  this chapter is only applicable to PF1 entities I believe we can suppress some redundancies  ( see in bold) : 

      • Layout : /BESTÄNDE (PF1)
      • Additional Transactions for Support (for PF1)


    The rest it looks ok for me!