Open Forum

Expand all | Collapse all

AP Historical aging report and general ledger do not reconcile

  • 1.  AP Historical aging report and general ledger do not reconcile

    SILVER CONTRIBUTOR
    Posted 8 days ago
    The two do not reconcile any longer - we have run the GL reconciling tool and there are no mismatches - we did not make any manual journal entries to the AP account - we have run check links and it does not help,

    I can narrow it down to one invoice but all the it is in the GL transactions and in the sub ledger but they are still off by that much.

    Can anyone please give me any suggestions or

    I have even tried to run the RSS historical aging report but it is off tremendously


    .

    ------------------------------
    Betty Hall
    Christensen Inc
    Richland WA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: AP Historical aging report and general ledger do not reconcile

    Posted 8 days ago
    Have you made any prepayments?  If so, you likely have set the posting account to another account (such as a deposit account) in the G/L that will have to be included in your reconciliation along with the AP liability account.  Just another possibility to eliminate.

    ------------------------------
    Sharon Dunn
    Combined Systems, Inc.
    Jamestown PA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: AP Historical aging report and general ledger do not reconcile

    GPUG ALL STAR
    Posted 8 days ago
    Hi @Betty Hall

    Your step before you ran check links should have been to run Reconcile in the AP Module.

    The Reconcile ​tool re-totals all of the actual transactions that have occurred and updates the summary tables that all of the reports run off of.  Try running that and it will print out a list of all changes.

    I would grab a backup first.  This one does not change anything in the tables, like Check Links does, but it simply resets everything to what the actuals are.

    For one reason or another GP gets out of sync with it's reporting, this is the way to fix it and it sounds like you've done everything else.

    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: AP Historical aging report and general ledger do not reconcile

    TOP CONTRIBUTOR
    Posted 7 days ago
    I just posted another post that includes the HATB, I am sure I am repeating what @Jo deRuiter has already told you.

    https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MessageKey=9917a746-b088-4ec6-b051-c0f54e18d995&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e&tab=digestviewer&ReturnUrl=%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d4754a624-39c5-4458-8105-02b65a7e929e%26tab%3ddigestviewer​

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Paradise GP Consulting, Inc.
    Sunrise FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: AP Historical aging report and general ledger do not reconcile

    SILVER CONTRIBUTOR
    Posted 8 days ago

    Do you mean this one or the the other one that uses matched transactionbs?




    ------------------------------
    Betty Hall
    Christensen Inc
    Richland WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: AP Historical aging report and general ledger do not reconcile

    SILVER CONTRIBUTOR
    Posted 8 days ago
    We did run that several times - it just came up with no unmatched items

    ------------------------------
    Betty Hall
    Christensen Inc
    Richland WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: AP Historical aging report and general ledger do not reconcile

    GPUG ALL STAR
    Posted 8 days ago
    @Betty Hall,

    No, not Reconcile to GL, the reconcile tool within the purchasing module.



    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: AP Historical aging report and general ledger do not reconcile

    GPUG ALL STAR
    Posted 8 days ago
    @Betty Hall

    That's the one!​

    ------------------------------
    Jo deRuiter
    🌟 GPUG ALL STAR
    💫Granite Award Winner
    Atlanta Chapter Leader
    Aisling Dynamics Business Solutions
    Business Applications Practice Manager
    jo.deruiter@aislingdynamics.com
    9518674366
    aislingdynamics.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role