Open Forum

SL2011 - Aged AP Report

  • 1.  SL2011 - Aged AP Report

    Posted 08-09-2018 10:45 AM

    Hi,

    My Aged AP report is duplicating each vendor and amount due. Has anyone ever seen this?

    Thanks in advance,



    ------------------------------
    Hana King
    Cherokee Enterprises, Inc
    Miami Lakes FL
    ------------------------------


  • 2.  RE: SL2011 - Aged AP Report

    SILVER CONTRIBUTOR
    Posted 08-10-2018 07:14 AM
    Hana,

    I have seen the in the past on a few different reports and it has been attributed to records not properly cleared from the report tables in the databases, generally when a user clicks more than once to generate the report.  Make sure that the report and user records are removed from these tables:
    Application Database - ROIDetail, ROIHeader, RptCompany, RptExtra, RptRuntime
    System Database - Rptextra, RptRuntime

    ------------------------------
    David Callery
    Consultant
    Coe & Company, LLC
    New Orleans LA
    ------------------------------



  • 3.  RE: SL2011 - Aged AP Report

    Posted 08-10-2018 08:40 AM
    You probably have another instance of the rptruntime, rptcompany and rptextra that did not clear out from the last time it was running because the report is linked to these tables. This can happen if the report did not close properly previously.

    Try to restart sql first to see if that fixes the problem.  If you are comfortable with SQL, you can run these statements select statements in the application database to see what is hung up.  Then they need to be deleted.  Make sure you know what you are deleting

    Select * from rptextra where RI_id not in (select ri_id from rptruntime)
    Select * from rptcompany where RI_id not in (select ri_id from rptruntime)
    select * from rptruntime where userid='xxxx'

    ------------------------------
    Jenny Dinh
    Noble Resources Corp
    Tampa FL
    ------------------------------



  • 4.  RE: SL2011 - Aged AP Report

    Posted 08-10-2018 05:00 PM
    Thanks Jenny & David!

    ------------------------------
    Hana King
    Cherokee Enterprises, Inc
    Miami Lakes FL
    ------------------------------