You’re offline. This is a read only version of the page.
We have a SOP invoice that is corrupt. It has no information listed with it, and is causing a bunch of problems when we try to export data to excel.
If I run a sales document inquiry for the number, it shows up.
But if I try to run a Reconcile-Remove Sales Document utility, it doesn't show up. Any ideas how I can get rid of this thing?
*This post is locked for comments
Usually filling in SOP10100 to the point where you can get in to the order then void it.
Do you by any chance know which table I'm looking at to fill in the missing data?
I too use this method, bring up the order in SQL tool of choice and chose a health donor record, and "transplant" the fields from one to the other until it can be opened and voided.
Hi,
I have dealt with this situation many times in my history. For sure run check links and reconcile and all that, but what I usually end up doing is what I call 'file surgery'. If possible, I'll fill in the missing information so that it can be pulled up in the user interface and deleted. The information doesn't have to be correct, it just needs to be good enough to open the document. For instance, if it has no customer id, any customer will work.
If I cannot get the document open, I search the entire database for the document number. I'll look at the results of that query and determine whether the record needs to be deleted from the table. If there are any inventory items allocated to this document you will need to adjust the IV00102 table and any bin tables if you use multi-bin. I think you'll be good to go if you can get this thing deleted, one way or the other. My preference is always to delete from the user interface if you can.
Kind regards,
Leslie
Do you know which of your users created the document? Sometimes having that person log off can free a document like this.
If the checklinks does not work, then you are going to have little choice to but to excess the item from the SQL Tables. While not complicated, it can be tricky, so be sure before you do anything - including the checklinks - that you have a good working backup.
Good luck.
Everyone needs to be logged out of dynamics before check links is run correct? I could possibly try that later tonight, but we have about 30 people logged in currently. No, the document is not assigned to a batch. Thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (