Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AR Paid transaction removal

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

General question:

How often do you run the Paid Transaction Removal routine in AR?

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: AR Paid transaction removal

    Deanne,

    Each customer I have worked with has different requirements for this. For example, I have one customer that constantly needs to go back and unapply/reapply pretty old payments. They use a cut off date that is 6 months prior, so they can easily do this. Other customers move everything to history right away, but then do use the unapply tool once in a while as needed. Yet others issue financials to the board and sometimes the bank that include details of their AR aging. In that case, they really don't want those things to change after the fact and thus don't want to unapply anything for a closed month.

    I don't think there is a wrong or right, but I think the important thing is to be consistent and to keep running the Paid Transaction Removal so your open tables are not bogged down with unnecessary data.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Paid transaction removal

    Thanks, Victoria!  That's what I keep telling accounting to do!  We experience issues sometimes when a customer (like GNC) pays 30+ invoices with one check.  Their payment is processed normally but then there may be issues and accounting needs to unapply and reapply items (baffles me but that's what they say).  When they have to do this and some of the items from that check are 'moved to history', they cannot figure out what to do.  I keep telling them to not unapply but issue debit/credit memos.  It's a learning process for them.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: AR Paid transaction removal

    We run it once a month, to keep consistent and that's what I typically recommend for others.  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Paid transaction removal

    Thank you!  This is exactly the info I need.  

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Paid transaction removal

    This article recommends making it part of your period end process.

    community.dynamics.com/.../receivables-management-period-end-closing-in-dynamics-gp

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: AR Paid transaction removal

    Hi Deanne,

    Since this routine is for purging 'fully paid'/matched payments and invoices from the statement, the frequency of running the routine may depend on your  volumes, and perhaps how frequently the transaction matching is done. Just remember to tick 'Keep History' under Receivables Setup, to ensure that the transaction history remains (in the system), even as the statements are made lean.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans