Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

NSF Check that is in history tables

Posted on by 55

I have a cash receipt that needs to be marked as an NSF and have the invoice brought back to an open status.  The main problem I have is that paid transaction removal has been run and it is in the history tables.  KB # 857664 says

"If for some reason both the invoice and the payment are in history, the payment cannot be voided or NSF'ed. Remove history on the payment and the invoice using Remove Receivables Transaction History (Utilities|Sales|Remove Transaction History), and reenter them. 

It seems like I need a little bit more direction than that.  If I remove history on this one payment transaction for $311 will that correctly update the checkbook with a decrease of $311.  This seems like a very crude way to handle what I would think is a fairly common problem.

 Can anybody give me some better directions on this.

 Thanks.

 

 

*This post is locked for comments

  • Re: Re: Re: Re: Re: Re: NSF Check that is in history tables

    Then I'm happy to have the tool, as opposed to removing the transaction entirely and having to re-enter it.  Thanks for the clarification!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Re: Re: NSF Check that is in history tables

    Yes!  A very big difference:

    Utilities > Sales > Remove Transaction History will actually DELETE these transactions.  You will not be able to see these transactions in GP again. 

    The RM Transaction Unapply Tool allows you to unapply historical transactions, simply moving them from historical tables to open tables so that you can reapply them or enter an NSF for them.  The only thing deleted by the tool is the apply information.  All the transaction detail remains intact.

  • Re: Re: Re: Re: NSF Check that is in history tables

    Is there any difference between using that "remove transaction history" utility to bring something out of history, or using the professional service tool "RM transaction unapply", which also brings a payment out of history?

     We often have this same situation, use the RM transaction unapply if we've run the paid transaction removal already, then have to go in and separately void the deposit.

     I'm wondering if this is accomplishing the same thing.

     Thanks,

    Palma

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: NSF Check that is in history tables

    I agree.  As far as I am concerned, removing history should always be the very last possible option, only used if there is absolutely no other way to accomplish what you need.

  • Austin Siemens Profile Picture
    Austin Siemens 55 on at
    Re: Re: NSF Check that is in history tables

    That worked and wasn't all that bad.  Removing the history seems like a complicated and unneccessary way to do this.  Thanks!!!!

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: NSF Check that is in history tables

    No, the checkbook will not be adjusted. Once you have removed the transaction to history, you are going to need to make adjusting entries. 

    An entry reversing the deposit (payment) to the checkbook will be required.  Hit cash and an offset account.  Then re-enter the invoice hitting receivables and the offset account.

     Leave the original transactions in History and refer to them in the notes of these transactions.  You will then have a complete audit trail.

     

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans