Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
hiddentrue

Page_title

Panel
bgColor#f2f2f2
titleColor#ffffff
borderWidth1
Process: Monthly costing and cost accounting closing
Panel
bgColor#f2f2f2
borderWidth1

Responsibility area: Perform product costing monthly closing

Info

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.

Panel
bgColor#f2f2f2
titleColor#ffffff
borderWidth1
Scope
Image Removed Image Removed PF1Image Removed
  PF2

Frequency
Image Removed
Monthly
References

 

Expand
titleSAP Transactions
Content by Label
showLabelsfalse
max30
spacesSAPCost
showSpacefalse
sorttitle
operatorAND
cqllabel = "op_118" and label = "sap_transaction" and space = "SAPCost"
Expand
titleCosting rules

Content by Label
showLabelsfalse
max30
spacesSAPCost
showSpacefalse
sorttitle
operatorAND
cqllabel = "op_118" and space = "CostFAQ"

Attachments  




Attachments  

 Detail plants with stock negative.xlsx


Panel
bgColor#f2f2f2
titleColor#ffffff
borderWidth1

xx  <<

Page_title
>> xx

 


Panel
bgColor#f2f2f2
titleColor#ffffff
borderWidth1

  Guideline  

Expand
titleI display the list of stocks value

 

Include Page
CostOP:MB5L - List of Stock Values: Balances
CostOP:MB5L - List of Stock Values: Balances
 

Expand
titleI analyze the Output

·         For

PF1

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

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

 


Expand
titleIn case of differences
Expand
titlePF1PF2

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

Expand
titleWP1WP2

Enter in Transaction S_ALR_87012277and 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.

Expand
titleIn case of no differences
  • For WP1 WP2 companies nothing to do.
  • For PF1 PF2 companies check also negative stocks

 

 



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


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

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 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.

Info
titleSend 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

Viewtracker
hidetrue