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
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
Hi Leslie,
Thank you for this tip.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156