Clean up AP Subledger

  • Clean up AP Subledger

    Posted by DSC Communities on March 31, 2022 at 4:10 pm
    • Lisa Davis

      Member

      March 31, 2022 at 4:10 PM

      My historical aged trial balance has some old PMTs that are still showing up.Ā  Example: PMT date is 10/07/2021 but this check was applied to an invoice dated 09/14/2033.Ā  Obviously the invoice date was an error but this will continue to show up in my subledger until the year of the invoice.Ā  I have four more like this one that go back as far as 2003 pmt date. I tried to use Utilities-remove transaction history but the system will not allow me to remove an applied invoice or pmt.

      ——————————
      Lisa Davis
      Henry County Water Authority
      McDonough GA
      ——————————

    • Lou Spevack

      Member

      April 1, 2022 at 9:29 AM

      Hi Lisa.

      To remove a payment from your HATB report without affecting the AP control balance, create a debit memo for that vendor and adjust the distribution so that you debit and credit the same account.Ā  Then apply the payment to the posted debit memo.

      ——————————
      Lou Spevack
      American Council on Education
      Washington MD
      ——————————
      ——————————————-

    • Windi Epperson

      Member

      April 14, 2022 at 5:13 PM

      Hey
      If you use multi-currency there was a bug that was fixed with the Oct 2020 release where documents weren’t clearing off the AP trial balance as expected.
      I feel like we had some non multi-currency customers that had this issue as well but it’s be a few covid months so I don’t remember for sure.
      But check out the post and see if it helps any
      https://docs.microsoft.com/en-us/dynamics-gp/whats-new/version-october-2020
      Thanks
      Windi
      ?

      ——————————
      Windi Epperson
      Customer Support Manager
      Njevity, Inc
      Norman OK
      720-870-9700 x104
      ——————————
      ——————————————-

    DSC Communities replied 3 years, 5 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Clean up AP Subledger’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

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!