Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Delete an order that's already on the history table

Posted on by Microsoft Employee

How do we delete an order that is already on the history table? We have already voided it's invoice.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete an order that's already on the history table

    Hi Leslie,

    Thank you for this tip.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Delete an order that's already on the history table

    Hi Ariel,
    You might consider using the Master ID as part of your report query such that a voided invoice would also remove the order if the Master ID invoice has been voided.
    Kind regards,
    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete an order that's already on the history table

    Hi Leslie,

    The reason is we have custom reports (SSRS and Crystal Reports) that looks at SOP orders vs invoices. Since the amount of that particular order is already in the history (not voided), the numbers that we get is off unless we always remember that there is that particular order that wasn't voided. The invoice that was voided was not posted yet so it was voided in the SOP transaction only.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Delete an order that's already on the history table

    Hi,

    You mentioned it was an Order so I'm going to speak to SOP. I do not think there is any way to remove the order that is in history. I'm curious as to why you would want to do that. You mentioned that you voided the invoice. Since you cannot Void a SOP invoice, I presume you voided the Receivables invoice. If there were inventory items on this order/invoice your inventory numbers will be incorrect. If an invoice originated in SOP, I believe it should be returned in SOP and not voided in RM. 

    Kind regards,

    Leslie

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans