Inconsistency in FI GL value and stock in inventory books

[Former Member]

Hi Experts,

We have a situation that for 2 finished material stocks quantity in inventory for a particulat plant is nil (checked in MMBE,MB51,MB52,MB5B) whereas it is showing quantity and value in MC.9 & GL account. Value in MC.9 and GL account is matching for 2 materials.

What is the procedure to correct the GL account value and value & qty in MC.9 as we do not have physical stock exisiting in the inventory for this 2 materials.

[JL23]

Mc.9 is a statistic transaction - pure statistic - no update priority - not accounting relevant

So dont get the idea to make accounting relevant data equal to statistic data, the silution is usually the other way around.

if your MM values are not in sync with FI values can be checked in MB5L transaction.

And if it is not in sync, then usually because FI has made direct posting to an account that should only get updated from MM movements. So to get it correct, FI has to reverse its direct postings.

And if MC.9 is incorrect, then you have to regenerate the statistic tables (e.g. OLI3 is one transaction for this, but better search for OSS notes to read instruction how to do it. One preconditon is that nobody must do any postings during regeneration, which can run many hurs to days depending on the data volume)

[Former Member]

Hi

Check that any return of material has been done.

It will come only in (MMBE,MC.9 & G/l account ) it won't come in MB5B.

In MMBe it will be availiable in return (wich is nothing but customer return)

Hope this might solve your issue

Regards

Davey