Just wondering if someone might have an idea how this happens.
The SLS document shows as OPEN in the selection window, when selected and the Document Number hyperlink is selected, the error as shown is displayed.
Any suggestions?
*This post is locked for comments
Unfortunately, I am not sure of the status of the SOP document when this might have happened. I am also not clear with the client who or even if someone did run a Remove transaction - these are locked actions to certain users.
So, no way to really test.
There real is no error - just a 'coment' from GP that the record is not available.
If this document was not deleted from Sales History, please check the description value of the sales document in "Edit Transaction information" window. The invoice document number and description both should be same, otherwise it will through the error. I dont know exact reason for this behavior. But, I faced same issue for one time and sort out by following below link.
sandipdjadhav.blogspot.ae/.../error-this-document-has-been-removed.html
Hope this helps!!!
Bill,
Its seems like that transaction was removed from "Remove Sales History" window (Tools-->Utilities-->Sales-->Remove Sales History) . Please check this on any test environment to delete any sales transaction from this window and inquire from the same document. You can see the same error.
Hope this helps!!!
Bill -
Very interesting indeed, or not so much. Is it possible you're using Invoicing and not Sales Order Processing with Advanced Invoicing?
The SOP10100 table is the SOP Open Header Table and the SOP30200 is the SOP History Header Table (paraphrasing there)... I have seen situations where documents failed to delete during transfer/posting and wound up in both tables, requiring one of them to be removed using SQL, which is why I sent you the query.
I fully expected you to see two records appear in these tables. I can think of one very good reason... If I am looking in the wrong tables.
Try this query:
select 'OPEN' Source, DOCNUMBR, convert(varchar(10),DOCDATE,101),TRXSORCE from RM20101
union all
select 'HISTORY' Source, DOCNUMBR, CONVERT(varchar(10),DOCDATE,101),TRXSORCE from RM30101
where DOCNUMBR = 'IVC017038'
I would set SQLLogSQLStmt = TRUE in the DEX.ini file to see what statement shows in the DEXSQL file when this error occurs.
What an interesting suggestion.
But a more interesting result is that both queries return nothing at all.
Bill,
It is possible the transaction in question is present in whole or in part in both the Open and History table. Try running this query, to see if this is the matter:
select 'HISTORY' Source,SOPTYPE,SOPNUMBE,DOCID,CONVERT(varchar(10),DOCDATE,101) DOC_DATE from SOP30200
union all
select 'OPEN' Source,SOPTYPE,SOPNUMBE,DOCID,CONVERT(varchar(10),DOCDATE,101) DOC_DATE from SOP10100
where SOPNUMBE = 'IVC017038'
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,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156