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

  

Frequency


References




Attachments  

 


xx  << >> xx


  Guideline  

  

·         For PF1:


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 WP1:

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 WP1 companies nothing to do.
  • For PF1 companies check also negative stocks



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


In PF1, 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 (PF1)

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 PF1)

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.

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