Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Receivables - Paid Transaction Removal

Posted on by 4,029 Super User 2024 Season 2

Why does this need to be done manually?  Is there a valid reason that a user might not want an AR document to move to history when it's paid or is this just one of those quirky legacy issues from when man carved notes with a chisel?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Receivables - Paid Transaction Removal

    I would just like to add we tell our clients to advance the date on checks one month into the future. This is usually enough to accommodate any NSF checks. So if we are running PTR for June the dates for the invoices will be June and the dates for the checks will be July.

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Receivables - Paid Transaction Removal

    Thanks Frank!

    My typical advice to companies who are not publicly held is to run Paid Transaction removal for the prior month (Cutoff of June 30 when running PTR on July 31) as part of their Month-End Close Checklist.  

    This normally minimizes the white noise created by fully applied transactions.  The problem with running this anytime sooner, is you run the risk of encountering an NSF transaction, or the need to reapply a payment, after you've removed the option.

    I agree wholeheartedly it would be a better approach to move the transactions to history without manual intervention of PTR, and provide the capacity to process NSF/reapply a transaction if necessary, like voiding or correcting a journal entry, instead of entering its inverse transaction.

    Final thought - one of the things that makes Dynamics GP an Enterprise system, is architecture.  There are Work, Open and History tables and overt actions move transactions from one table to another.  Paid Transaction Removal moves cash applications to history tables, improving the performance of related windows and reports.  

    Any "half-measure" like flipping a flag or updating a status field value, might ultimately negatively impact performance, as the cash applications table filled up what are effectively open transactions, because running the PTR process would no longer be a necessity. Think of the future forum posts - Why is cash application so slow? Why does my aging report take forever to run?  LOL. 

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Receivables - Paid Transaction Removal

    Thanks Redbeard - I knew you'd have the answer :)

    However, what about the company who wants to look up Open Invoices by Customer (with the customer on the phone) without running an aged trial balance?  That scenario requires running Paid Transaction Removal daily.  Would it be possible to fire off a macro that would run the PTR automagically when the user logs in to GP?

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Receivables - Paid Transaction Removal

    Frank,

    Once you pull the trigger on this one, you can no longer handle an NSF transaction or reapply a payment to another invoice (in the case someone applied it to the wrong one).

    The only companies I know who must run Paid Transaction removal at Month-End are publicly traded ones who should have their published financial statements frozen in carbonite.  

    I actually had one customer settle on making it part of the year-end process to perform Paid Transaction Removal for the prior year - a lot like how when you close a year in GP Financials, you are actually hard closing the prior year (Last year +1).

    I believe users can un-check the Fully Paid Documents option in Receivables Aged Trial Balance with Options report, which suppresses all the documents that show up on the aging when PTR has not been run.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Receivables - Paid Transaction Removal

    I wish I had an explanation, if I had one ... I would have been more convincing when a debate emerges with clients regarding this unusual process which comes against the general standard and consistent behavior of the other modules.

    I do believe that there are many other similar points which have no proper justification, at least for me, such as:

    • Fixed Asset account group, which is gone with the wind after the asset is saved, why not to have the same similar Parent-child relationship like the item and item class, vendor and vendor class ... In my humble opinion, accounts should be inherited from the class
    • Clear unused receipts ... I may understand the logic, but I do believe it should be among utilities at least, not listed among bank transactions
    • Deposit without receipt ... Would never be convinced about the logic behind it, it is only used to play around with the balances, and keep things tied among the module and GL
    • Post to GL checkbox on the inventory batch ! Why it is even there ?
    • Why the fixed asset module, among all have a staging GL posting ...  !
    • Why the asset id in the GP 2013 R2 update does not allow a "Hyphen" among all other special characters ! Although, it is the one that have been always used when it comes to Fixed Assets
    • ...  etc

    My list could go on and on which could give a bad impression. Although, I should keep the credit that this is a very small portion that would never go beyond 1% of the system processes. So my answer is simply, it is a quirky legacy that we have to deal with.

    Still, just like you Mr. Frank, wishing to hear a proper justification derived from a consistent financial or business process standard as we have always used with Dynamics GP.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans