Skip to Content

GL Balance amounts mismatches between entry view and GL View

Hi Team,

I have a problem in GL reports FBL3N and FAGLB03.

Document having 3 line items and 2 line items was posted correctly in both Entry view and GL view,but have the problem with one line item.

In entry view its shown like USD 100 and same document shown in GL View its shown USD14000.

I am check with other reports as well and its showing USD 14000 instead of USD 100.

Thanks in Advance

Regards,

Prasad

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 08, 2016 at 01:07 PM

    Hi Prasad

    You should check the following:

    1. If the document exists in both BSEG and FAGLFLEXA for the ledger with the same amounts or not. If yes, than run the comparison for the GL using FAGLB03 and FAGLL03 and check if there is a difference between totals and line item tables. If the amount does not match in BSEG and FAGLFLEXA, than run T Code FAGLF03 to compare the ledger and entry view to identify all such documents and than run the t code GLGCU1 to update the transaction figures. Verify the results for all the ledgers relevant for your company code. I would recommend doing this in a test environment first before executing in production.

    2. Check if you have summation active for your company code and if that is what is causing the issue.

    Also how was this document posted and if it came from other applications like SD or MM or payroll. I did a cursory search on OSS Note and did find couple of notes around this, but cannot point to exact OSS note, since I do not know how the accounting document was posted and transaction used to post the document.

    Thanks & regards


    Sanil Bhandari

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Prasad CH

      Hi,

      Yes of cause there is an impact. You will delete records in fagl* tables. But you will upload it again... Basically 'reuploading' could change document, e.g. if doc. splitting rules were changed. Also not all fields are available in ACCIT during it, e.g. movement type

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.