Historical Aged Trial Balance

  • Historical Aged Trial Balance

    Posted by DSC Communities on February 9, 2017 at 10:59 am
    • Katie Easton

      Member

      February 9, 2017 at 10:59 AM

      I have a document with a posting date of 1/25/2017, a document date of 1/31/2017, that was paid on 2/2/2017.

      This document is not showing up on a historical aged trial balance run as of 1/31/2017.  Anyone have any ideas as to why it’s not showing up?

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————

    • Steve Burney

      Member

      February 9, 2017 at 11:20 AM

      Hi Katie,
      If you could provide a screen shot of your Payables Trial Balance Report Options screen that you are running then we could help you look further.
      Some of the drop down box options at the top of the screen and under the “Exclude” area could determine why you are not getting the information on the report.

      We look forward to seeing more information.
      Steve

      ——————————
      Steve Burney
      Senior Financial Systems Administrator
      Correct Care Solutions
      Nashville, TN United States
      sburney@correctcaresolutions.com
      615-312-7272
      Twitter @SteveBurney
      ——————————
      ——————————————-

    • Katie Easton

      Member

      February 9, 2017 at 1:15 PM

      HNvS93Q8Kydmp2a7vgVQ_Screenshot - Hist Aged TB.JPG
      This is the report that I’m trying to use.

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————
      ——————————————-

    • Shari Bruno

      Member

      February 9, 2017 at 1:46 PM

      Hi Katie,

      Is it possible that the 2/2/17 payment was back posted to 1/31?

      ——————————
      Shari Bruno
      Accounts Payable Specialist
      Bible League International
      Crete, IL
      ——————————
      ——————————————-

    • Katie Easton

      Member

      February 9, 2017 at 2:01 PM

      Nope.  The posting date on the check is 2/2/2017.  I’m wondering if having the posting date (1/25/2017) earlier than the document date (1/31/2017), would make any difference. 

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————
      ——————————————-

    • Steve Burney

      Member

      February 9, 2017 at 2:49 PM

      Hey Katie, Let us know what happens if you put the date to include 2/2/17.

      ——————————
      Steve Burney
      Senior Financial Systems Administrator
      Correct Care Solutions
      Nashville, TN United States
      sburney@correctcaresolutions.com
      615-312-7272
      Twitter @SteveBurney
      ——————————
      ——————————————-

    • Katie Easton

      Member

      February 9, 2017 at 3:14 PM

      Changing the aging date to 2/2/2017, still doesn’t show me the outstanding 1/2017 document.  The only thing it does show is the payment dated 2/6/2016, that was for the invoice dated 1/31/2016 – a year ago.

      I’ve checked & don’t have any batches that aren’t posted, so that’s not the issue.

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————
      ——————————————-

    • Shari Bruno

      Member

      February 9, 2017 at 3:29 PM

      Just a thought, but have you checked Master Posting and Batch Recovery?

      One more thought, have you tried taking out the date restriction and putting a vendor restriction instead?  I run my Historical Aged Trial Balance that way, by a specific Print Age/As of date, and all of the vendors.

      ——————————
      Shari Bruno
      Accounts Payable Specialist
      Bible League International
      Crete, IL
      ——————————
      ——————————————-

    • Katie Easton

      Member

      February 9, 2017 at 4:06 PM

      I checked both Batch Recovery & Master Posting – no batches unposted.  I ran the Hist. Aged TB with all vendors from AAAAAAA – ZZZZZZZ and that vendor did not show at all.

      I

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————
      ——————————————-

    • Shari Bruno

      Member

      February 9, 2017 at 5:04 PM

      Wow!  That transaction is a mystery.  When you find it I would be interested to see where it was hiding.

      ——————————
      Shari Bruno
      Accounts Payable Specialist
      Bible League International
      Crete, IL
      ——————————
      ——————————————-

    • Katie Easton

      Member

      February 9, 2017 at 5:16 PM

      I’ll let you know if & when I find it.  If all else fails, I will call our support company for help.  A year ago, I had a transaction that was posted – no problems – and it never hit the GL.  We never did figure out what happened. 

      ——————————
      Katie Easton
      Theodore Roosevelt Medora Foundation
      Medora ND
      ——————————
      ——————————————-

    • Victoria Yudin

      Member

      February 10, 2017 at 9:56 AM

      Hi Katie,

      In case it helps, here is a little blog post I wrote about missing GL transactions: https://victoriayudin.com/2009/04/11/where-did-my-transaction-go/

      ——————————
      Victoria Yudin
      Microsoft Dynamics GP MVP 2005-2016
      Flexible Solutions, Inc.
      http://www.GPReportsViewer.com
      http://victoriayudin.com
      ——————————
      ——————————————-

    • Anne Provost

      Member

      February 10, 2017 at 12:28 PM

      I’ve seen invoices bypass the trial balance if the voucher was entered along with the payment in Payables Transaction Entry.  For example, the utility bill is entered into January with the payment coming out in February.  No payable “exists” according to GP.  You have to accrue a reversing entry to balance. 

      ——————————
      Anne Provost
      Chief Financial Officer
      TNR Technical, Inc.
      Sanford FL
      ——————————
      ——————————————-

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

Sorry, there were no replies found.

The discussion ‘Historical Aged Trial Balance’ 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!