cancel
Showing results for 
Search instead for 
Did you mean: 

OPENING STOCK

Former Member
0 Kudos

HI

pls tell me regarding if we maintain operations focus and sap system simultationaly, if there is any difference in stock both the system, i want to update the opening stock as per the focus system, can we change the opening stock as per the focus system, is it possible.

with regards

mohan krishna

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear Mohan Krishna,

You would not have opening stock and closing stock at the end of the day in MM as you have opening balance and closing balance in FI. There you maintain transactions in Cash Journal and update the GL Account at the end of the day. Hence, you require opening and closing balance.

Here in MM you would upload the data from your legacy system at the time of cut-off. Consequently you would issue/receive stock with corresponding movement types. It is automatically added/substracted to/from stock whenever there is a corresponding goods movement.

However, you can post the differences as suggested by earlier reply. But, what is the frequency are you looking at to post these differences?

Are you expecting the system to post these differences automatically whenever there is a difference in the stock in Focus system and SAP system?

Regards,

Naveen.

Former Member
0 Kudos

In SAP, Initial Stock upload is done through MB1C. subsequently, the material will be taken in stock throught MIGO.

For Report purpose you can check the following T.Codes: MB5B, MB52 & MB53.

Regards,

Rajesh Banka

Reward suitable points.

  • How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

Former Member
0 Kudos

Hi,

I am not sure I fully understand your question.

If you mean a one-off opening stock the first time you start using SAP? This is done via the 561 movement type (additive) or 562 movement type (subtractive).

If you mean the opening stock at the beginnning of every month then you have two main options. Either make postings via movement types to consume the stock in SAP so that the end result matches the other system, or post a stock count at the start of every month via a batch run of transaction MI10 to simply correct the stock levels. The most important thing to get right is the financial impact and so the latter solution (via stock count) may well cause the financial postings to go to the wrong accounts. Where as the posting of consumption can be pointed at a specific account.

To achieve the correct consumption postings you would do something like this (by material). the current stock level on SAP minus the opening stock level that you want to have, is the quantity that you would use in a batch job that does a 201 (for instance) movement type to consume that stock to a specified GL account. This replicates a summary of the consumption in the other system.

This suggestion is based on the assumption that you are posting your consumption in the other system and want to reflect the stock effect in SAP

Steve B

Former Member
0 Kudos

what is focus system?

Former Member
0 Kudos

Dear Mohan,

Yes You have option in SAP to upload the Initial stock i.e opening stock.

Go for transaction code-MB11- select Movement type 561-Receipt per initial entry of stock balances into unr.-use and upload the opening stock whenever u want.

Rewards ..

Regards

sanjay L