Open Forum

  • 1.  Smart List report not balancing

    Posted 20 days ago
    I am running a SmartList Report - SMARTLIST>PURCHASING>PAYABLES TRANSACTIONS>VENDOR OUTSTANDING and all the detail in this report balances perfectly to Dynamics GP 2018 AP Trial Balance just fine.
    But when I run SMARTLIST>PURCHASING>VENDORS>" * "    report, and add the column "Current Balance" all the accounts balance except 1 - which is out by $14,152.01.

    I had been running these SMARTLISTs for years now, and they always balanced until August 2021, and it is the same amount out since August (the $14,152.01)

    Why would the Current Balance in the VENDORS Smartlist be different then the sum of the TRANSACTIONS?  and how can we get this fixed?

    Thank You.

    ------------------------------
    Clay Tait
    Tait Distributors
    Edmonton AB
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Smart List report not balancing

    GPUG ALL STAR
    Posted 12 days ago
    Hi Tait,
    As a first note, you should avoid posting screen shots in open forums where actual customer data is shown. Try with your screen capture tools to obfuscate the part that is not relevant, like below:


    you can still highlight the relevant numbers to compare with other screenshots, but try to leave personal data out of the captures.

    As for your question, have you tried to run a reconcile or checklinks against the Vendors ? It might be a transaction that was not fully posted or is half-half (open / history)..


    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Smart List report not balancing

    Posted 8 days ago
    Thank You Beat Busher for the advise on screen shot (your right), and the suggestion to Reconcile and Check Link (which I did, and the issue is resolved.
    Regards. Clay Tait

    ------------------------------
    Clay Tait
    Tait Distributors
    Edmonton AB
    ------------------------------

    Academy - Online Interactive Learning from Experts


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