Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Katie Easton]

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]

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]

This is the report that I’m trying to use.

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

[Shari Bruno]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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
——————————
——————————————-