News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Invalid Receivable Tra...

Microsoft Dynamics GP (Archived)

Invalid Receivable Transaction still shows up on The Aged Trial Balance - how can I remove?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

On my Receivables Aged Trial Balance report, a transaction (Sales Invoice) is showing up that was already paid for and is really NOT open. If I try to again process a payment against that invoice, I cannot --- because the system does know it was already paid. However, it still shows as open on my report. I've tried running the various utilities to get it removed, but nothing works. Does anyone have any ideas? Is there a way to remove it in the Query Analyzer - if yes, what field would I remove it from.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Invalid Receivable Transaction still shows up on The Aged Trial Balance - how can I remove?

THANK YOU Frank! I had not yet done the Check Links yet - once I did that, I could re-enter my payment -- it worked!!! Thank you soooo much!
Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Invalid Receivable Transaction still shows up on The Aged Trial Balance - how can I remove?

So, you've run Reconcile and Paid Transaction Removal, right? Have you run Check Links on the SOP Open and History tables? And just to clarify, is this a SOP transaction or an Invoicing module transaction?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans