Totals not matching in Financial module

  • Totals not matching in Financial module

    Posted by Thomas Hill on March 5, 2025 at 10:58 am

    In a separate posting I mentioned that some how “detail” posting changed to “summary” posting. I think that is resolved to go into March 2025.
    To reconcile the ACCRUED ACCOUNTS PAYABLE (2047), I was getting the detail for all of the summary postings. When I was comparing me detail total to the total of the GL in the Card Tab, I get a variance. I have been reconciling this account since 2014 (GP2010, GP2015, and now GP2018). Never a variance.

    But for January 2025, there is a variance. I ‘snipped’ the summary-tab from the Card, Net Change is ($247,320.91). I ‘snipped’ the bottom of the trial balance (for January and February). February is good, but January has the Net Change ($313,264.17).

    I showed to our GP Administrator. He did not have an answer. Is there some utility that corrects this?

    Thomas Hill replied 1 month, 2 weeks ago 2 Members · 5 Replies
  • 5 Replies
  • Devon Southall

    Member
    March 6, 2025 at 11:04 am
    Up
    0
    Down
    ::

    Tom,

    There is reconcile in Financial (under utilities) to recalculate the summary balances from the details. but you only want to do this if you have SQL backup and everyone is out of GP (and generally in a test company)

    There are several ways in GP to delete transactions in the user interface and this utility doesn’t support them all….

    Seeing all your posts…. I would reach out to you GP partner and get some assistance.


    Best,

    Devon

    • Thomas Hill

      Member
      March 7, 2025 at 11:07 am
      Up
      0
      Down
      ::

      I will hand your response to our GP Administrator on Monday, as well as the Controller.

      Side note: I go by TK never Tom. And I really appreciate your help.

  • Thomas Hill

    Member
    March 10, 2025 at 10:27 am
    Up
    0
    Down
    ::

    Just to clarify. The actual total will be corrected to match the detail that is GP2018, not just print a report?

    • Devon Southall

      Member
      March 11, 2025 at 2:04 pm
      Up
      0
      Down
      ::

      Sorry, TK,

      actually – it will ONLY correct the totals… no option to print a report. So best to do in a test company first if you can, or make a backup that you can restore if it is worse after…

      Best,

      Devon

      • Thomas Hill

        Member
        March 12, 2025 at 12:31 pm
        Up
        0
        Down
        ::

        No apologies are needed regarding name. I really appreciate the help on this issue.

        Great Plains has been testing me this week.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!