Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

How to delete two A/R items from customer (database)

(0) ShareShare
ReportReport
Posted on by 75

Thanks all who may answer in advance for your time and technical knowledge.  I have two issues;

1) How do I delete two A/R line items from the database so that they would no longer show up on the A/R report. Client really screwed the pooch so the only way out is to delete them

2) What is the best way to handle a A/R accounts that have balances that need to be written off because the customer with the balance is bankrupt?

Again, thanks for all the help

*This post is locked for comments

  • Mycheall Hamlet Profile Picture
    75 on at
    Re: Re: How to delete two A/R items from customer (database)

    Thank you Sam. Here is the problem in more detail. Maybe you can suggest a solution. The client wants the customer off of the Accounts receivable detail report. Although the customer has zero balance and the filter of the report is balance <> 0 it is still showing on the report. I do not know for sure but I think the client did a type "DC" credit  adjustment to the account for the same amount of a "TR"  line item. Then for some reason known only to GOD and themselves they did a credit AND debit adjust again for the full amount. So two debits and two credits for the same amount canceling out everything to zero but it is still showing on the report. 

    Item #2

    the accounts of the two bankrupt customers are no longer recievables. They need to not be in the recievables report. They are uncollectable. How does one move that which was a recievable to somewhere where it will be accounted for but not seen as a recievable. Bankruptcy in the comments line will not remove it from the A/R account.

     Thank you in advance for any help you or anyone else can provide in this matter.

  • Sam Merfi Profile Picture
    45 on at
    Re: How to delete two A/R items from customer (database)

    1) You are attempting to violate a basic accounting rule of never erasing/deleting any records from your books (paper or electronic).  You must "adjust", i.e. reverse the desired transaction.  To add a reverse transaction to the customer's account, "Find" the customer's record (F7 in SO-POS or Database/Customer in SO Manager), Properties, Account Information, Adjust, etc...

    2) Similarly, as above.  May add any text relating to "banckrupcy" under Comments line.

    <Sam Merfi>

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans