Skip to Content

Reg Gl account balance varies with Stock accounts(materials)

Hi All,

I got an issue to be solved.IN MB5L The G/L account Balance and the Stock accounts(Materials) varies. The client wants to have a report:

What are the reasons for which this variance occured?

What are the possibilities to solve this problem?

I have to ask them what kind of report they do need

want to.

Kindly revert back asap

Thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 01:37 PM

    The reasons are like this:

    a. Manual entries into the stock accounts

    b. there have been movements where the system has done only material documents and no corresponding accounting documents have been created.

    eg of a situation: You have V price set for the material. But you never maintained any price in the Material master. Then the system will not throw an error, it just creates the materil document without creating the accounting document

    at the time of initial upload, there is high opportunity of such errors.

    rectification:

    a. develop a query linking the material document header and the BKPF reference field.

    b. develop a query to list down the accounting document header information posted in these accounts. the reference procedure should be MKBF (i do not remember exactly?) But it fills with a particular value if its from MM. Check for all the documents that have been posted to these accounts without this parameter in the header. Here you go..

    Regards

    Anantha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 03:21 AM

    do u hav any more clarifications? or the issue is ok with u?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.