Discrepency in Stock reports - Request for quick help!

[former_member406718]

Hi All,

Below is the description of the issue -

Initially we had differences in stock values (Transaction MB5L) between MM values & GL stock values (Inventory GL) & we found out certain GR documents got posted without corresponding FI Documents -This was due to a custom user exit, which got fixed now

So, in order to correct this difference say of Rs 5000 manual FI postings were done on Inventory account directly - This fixed the issue with MB5L report but now the issue is that valuated stock report MCBE or MC.9 is showing a valuated amount (- Rs 5000) which is different than Inventory GL balance because of those manual FI postings

Is there any good resolution for this?

Thanks in Advance

[former_member406718]

Let me start at the beginning to make everything clear.

Due to some customization (User Exit in MIGO) we had a scenario where the GR was only creating a MM document (MSEG) and no FI Document. This led to discrepancies in the stock values between FI and MM (MB5L). To fix this descrepancy the accounting folks made Journal entries to replicate the FI document from GR -

Debit Inventory

Credit GRIR

This Journal entry solved the problem for the MB5l descrepancies but the valuated stock reports are still off balance. We realize that the Journal entries were not the right choice and have reversed these documents.

Now we are left with the original issue where we have GR documents with no subsequent FI documents.

Is there a way that we can have the FI documents created for these using a special program? Or just be able to reverse these documents without impacting FI in the reversal. (Note that when we reverse the document, the reversal document has a FI document for it)

Thanks

[former_member406718]

Thanks for your response but this might not help me

Here is my basic issue - I have certain GR documents which did not generate FI ( due to user exit issue), *Is there a way to reverse these documents with 1 sided entry (impacting just MM & not FI) ?

Thanks

[JL23]

you said you fixed your postings. but because of this fix you had wrong values in LIS.

I asked how did you fix. You just repeat your question, but dont give an answer.

if you want reverse your initial wrong postings, then you have to reverse your fix first.

[former_member406718]

Thanks for your response, can you pls elaborate on this?

Just to make it clear - the GR documents were supposed to create corresponding FI documents but some of them did not because of custom user exit, which was not tested properly.....now we have fixed this custom user exit to prevent future errors

But the existing issue GR documents (with no FI) created inconsistency in report MB5L - To fix this manual FI posting was forced onto Inventory GL account but we overlooked the fact that this FI only postings do not update Valuated stock value, which shows on MC.9 or MCBE ....now these 2 reports have valuated stock value which is different than Inventory GL balance (Difference is the amount posted thru FI only postings)

Thanks in advance

[JL23]

Manual FI postings do not have any impact on MM history.

follow instrcutions of OSS Note 64636 - Procedure for statistical data setup in LIS

[JL23]

how did you fix?

You may have regenerate your infostructures that are used in the information system transactions MC.9 and MCBE.