MC.9 and Inventory GL balances Mis match problem / Error in inventory MC.9 / Negative stock value in MC.9 / fico inventory and gl balances problem

Please maintain the below mention check list for get good result.

Checklist:

1) Ensure offline backup finished.
2) Run the SAP system
3) lock all the sap users.
4) Hold the background jobs(using BTCTRNS1)
5) Run Progam RMCSISCP
6) Copy S032 000 version to 001 version
7) make sure data are coppied (check using SE16n)
8) Delete S032 000 version data
9) Ensure 000 version data deleted (using SE16n)
10) Run program RMCBNEUB to Setting up the inventory information structures
11) Run Program RMCBNEUA for Setting up the data from material documents
12) Run program RMCBNERP to setup accounting documents.
13) check the values of Mc.9 & FS10n
14) Release background jobs (Using BTCTRNS2)

15) Unlock the SAP users.


Before process.

From FS10N (GL - 131000- Raw Material) Balance 1,022,854,187.12

MC.9    balance 981,428,111.35






Differ = 1,022,854,187.12 - 981,428,111.35 = 41,426,075.77

As per Note 0000079083, we have followed this procedure.

     1.  Making a backup copy (Use program RMCSISCP)
      

   Below message appear in the screen.

   2.  Deleting the data in version '000' (Using program RMCSISCP)

    

   After processing below message appear.

3. Setting up the inventory information structures (Use program RMCBNEUB)

4. Setting up the data from material documents (movement information structures)

Using program RMCBNEUA

5. Setting up the data from accounting documents (movement information

structures)

After Process

Inventory Balance (T.code - MC.9) 1,022,835,257.82

GL – 131000 (T.code FS10N)  Raw Material Balance 1,022,854,187.12

Differ =1,022,854,187.12 - 1,022,835,257.82 = 18,929.3 only 18,929.3 differ 

Compare with cost run CK40N ( Standard price or Product cost ) and Plan price/ Ensuring accurate Standard pricing compare with Plan price

Menu Path	Accounting ® Controlling® Product Cost Controlling® Product Cost Planning ® Information system ®Summarized Analysis ®Analyze Costing Run ® S_ALR_87099930
Transaction Code	S_ALR_87099930

Before cost release or after cost run  we may verify with Materials predefined plan cost for get accurate price through Transaction code S_ALR_87099930

Update the following required and optional fields:

Field Name	Description	Values
Plant	Plant Code	2500
Costing Date	Select Costing Date, Valid from
No material Component.	Select “No material component” option
Comparison Value	Select “Comparison Value”  code	1
Threshold Red (Amount)	Threshold Red Value (%)	30
Threshold Yellow (Amount)	Threshold Yellow Value (%)	20
Display Positive and Negative variance	Click “Display Positive and Negative variance “ option
Material Master Price	Future Plan price	10
Layout	Select Layout	1SAP02
Cost Component View	Select “Cost of Goods Manufactured” option	1
Price unit in Material Master	Select “Price unit in Material Master “ option

Click the Execute  button.

The bellow mention Report will be appearing.

Transaction Code: MM03

Standard Price	Planned price 1	Planed Date
235.52	400	01.11.2011

Transaction Code: CK13N

After Cost run we may confirm that our estimate cost run/ Standard price is right or wrong compare with Plan price which is our targeted cost has been mentioned in material master. 

Variance:

Material Planned price	Cost Run Price/ Std. Price	Variance	Percentage
400	235.52	164.48	41.12 %

Foreign Exchange loss gain impact for MIGO (GR) and MIRO (IR) dollar (Foreign curr.) rate variance.

Rate = 1 Dollar

Quantity = 1000.

MIGO - Dollar Rate – 81.85 BDT.

MIGO

Stock value

MIRO - Dollar Rate - 82.00 BDT.

MIGO – Dollar Rate – 81.85 BDT.

Diff – 0.15 BDT.

Inventory update =1000 x 0.15 BDT=150 BDT.

MIRO

Inventory has been updated successfully.

For Partial issue (Raw material)

MIGO – Dollar Rate – 81.85 BDT

MIGO

Stock Value

Raw material issue - 250 PCs

FI entry 

After issue, Stock value

MIRO – Dollar Rate – 82.00 BDT

MIGO – Dollar Rate – 81.85 BDT

Diff – 0.15

MIRO

 

Stock value has been updated successfully. 

Inventory update (Residual quantity) =750 x 0.15 BDT              =   112.50 BDT.

GL 800200- F.E Gain (loss) – Realized                                     =     37.5   BDT.

                                                                                     Total : =   150      BDT.