Open Forum

Expand all | Collapse all

Historical Aged Trial Balance for Payables

  • 1.  Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 22 days ago
    The Historical Aged Trial Balance is reflecting open transactions from several years ago.  The GL Account is zero and there are no open transactions of any kind.  All the other trial Payable Trial Balance reports reflect no open transactions.  How can this be fixed.  GP10 is the version we are on.  Can someone help me or direct me as to how to fix.

    ------------------------------
    [Brian] [Buhler]
    [Controller CFO]
    [Kelsey National Corporation]
    [Los Angeles] [California]
    ------------------------------


  • 2.  RE: Historical Aged Trial Balance for Payables

    TOP CONTRIBUTOR
    Posted 18 days ago
    If you haven't run Paid Transaction Removal in GP > Tools > Routines > Sales, that might be a good place to start.

    This support link from Microsoft also explains how historical transactions can be removed:

    https://support.microsoft.com/en-us/help/849494/history-removal-options-in-microsoft-dynamics-gp

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------



  • 3.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 18 days ago
    Please note - this really doesn't 'remove' the transactions.  It puts them into history.

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 4.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 18 days ago

    The issue is with Accounts Payable and not sales related.  

     

    Brian K Buhler

    Controller

    Kelsey National Corporation

    3030 S Bundy Drive

    Los Angeles Ca 90066

    Direct 310.437.7222

    Kelsey.com

    DentalInsurance.com

     






  • 5.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 18 days ago
    try to do a reconcile then - under utilities.  You can test it on one vendor first to see if it fixes your issue

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 6.  RE: Historical Aged Trial Balance for Payables

    TOP CONTRIBUTOR
    Posted 18 days ago
    The support link includes options for Payables.

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------



  • 7.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 18 days ago

    I tried to remove as suggested but would as their was apply record conflict.  In our test production company I voided the Applied payment and found that the transactions open amount was double the amount of the actual AP invoiced amount.  The PM30300 Table reflects double the AP invoice amount applied.  Not something I usually like to do but if we updated the PM30300 table to the correct amount applied (equal to the amount of the invoice) would that fix the problem?

     






  • 8.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 18 days ago
    I tried the "Remove Transaction History". received message "Unable to remove this transaction: an open apply record exist or an apply record exist outside the selected range" Transaction are in history.

    ------------------------------
    [Brian] [Buhler]
    [Controller CFO]
    [Kelsey National Corporation]
    [Los Angeles] [California]
    ------------------------------



  • 9.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 17 days ago
    Have you tried checklinks or Utilities - Reconcile?

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 10.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 17 days ago

    yes

     






  • 11.  RE: Historical Aged Trial Balance for Payables

    TOP CONTRIBUTOR
    Posted 15 days ago
    Hi Brian,

    Re: error during Remove Transaction History

    Try unmarking the "Print Historical Aged Trial Balance" checkbox in the Payables Setup window... make sure to put it back when done. Better yet, please do this on a test company first..


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 12.  RE: Historical Aged Trial Balance for Payables

    TOP CONTRIBUTOR
    Posted 11 days ago
    If you have tried all these suggestions, you may need to write a SQL query to fix the historical apply-to file for the hanging transactions.
    I discuss this in this blog:
    https://dynamicsgptipsandtraps.wordpress.com/2018/07/23/fixing-the-pm-rm-historical-trial-balance/

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



  • 13.  RE: Historical Aged Trial Balance for Payables

    SILVER CONTRIBUTOR
    Posted 11 days ago
    Your error message states that the apply record is out of the selected range.  Could you expand the date range?  Maybe the apply date is incorrect somehow.....

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



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