Skip to Content
author's profile photo Former Member
Former Member

Difference between AR Ledger Vs GL

Hi,

We have a difference between AR sub-ledger Vs GL account which is correctly reflected in FAGLF03. We had also run the program RGURECGLFLEX to fix the discrepancy with the return message “Doc xxxxxx previously posted in the General Ledger”.

However, the difference still exists! Will appreciate if someone can suggest the miss, if any.

Thanks,

Nirav

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Apr 17, 2012 at 02:11 PM

    check with your system admin for failed updates in the message log

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 06:20 PM

    Hi,

    Will appreciate if anyone can shed light on this situation?

    Thanks,

    Nirav

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2012 at 06:32 PM

    Hi Nirav

    Message clearly stated Document XXXIX Previously Posted in General ledger. That means there is inconsistency FAGL* tables. Now case is AR Sub ledger not matching with General ledger balances.First drill-down the AR Balances with reconciliation GL & Cumulative GL wise Balances in FBL5N report. Check same total is matching with FS10N GL wise. May be some of the entries passed in Down payment recd account GL instead of AR account.

    Rgds

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mani,

      Thanks for your reply. I didn't get your point of "inconsistency FAGL* tables". Could you please elaborate?

      Secondly, you suggested to check the balances of Recon GL vs AR ledger (FBL5N). We already did that and different still exists!

      Now, the questions is how to fix it, as we can NOT post to recon.account directly. It's a catch 22!

      Thanks,

      Nirav

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2012 at 07:50 PM

    Dear Nirav,

    Check if you have posted some entries in different reconciliation GL (other than which is assigned to the vendor) at the time of transaction you might have changed it. As this is possible if we tick "Recon. Account Redy for Input" FS00 under CRETE/BANK/INTEREST tab.

    In such case difference are found, please check.

    Best Regards

    Ruksana Khan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi did you checked the currency of that entry view and GL view.

      Secondly in FBL5N add field GL account and GL amount anc check

      2. Set filter for GL account and enter you recon account in filter and check the balance.

      3. If the balance is different now then may be there is table inconsistency

      4. If balance is same now then either there are down payments, other speacial GL transactions, Other recon acct posted, etc.

      Please try this.

      Also: GL cum balance will contain balance in AR recon since it was created for all years as GL balance carryforward is normal closing activity

      But AR balance will contain only current year balance as most of people do not carry out AR Balance carry forward as year end activity.

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.