SLS Document show OPEN with Error

(0) Share

Report

Posted on by Bill Campbell

22,647

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

All responses (8)

Answers (0)

Bill Campbell 22,647 on at

Like (1)

Report

RE: SLS Document show OPEN with Error

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.
Bill Campbell 22,647 on at

Like (0)

Report

RE: SLS Document show OPEN with Error

There real is no error - just a 'coment' from GP that the record is not available.
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: SLS Document show OPEN with Error

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!!!
Suggested answer

soma 24,406 on at

Like (1)

Report

RE: SLS Document show OPEN with Error

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!!!
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: SLS Document show OPEN with Error

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'
Don Wisch 660 on at

Like (1)

Report

RE: SLS Document show OPEN with Error

I would set SQLLogSQLStmt = TRUE in the DEX.ini file to see what statement shows in the DEXSQL file when this error occurs.
Bill Campbell 22,647 on at

Like (0)

Report

RE: SLS Document show OPEN with Error

What an interesting suggestion.

But a more interesting result is that both queries return nothing at all.
Suggested answer

Redbeard 12,931 on at

Like (1)

Report

RE: SLS Document show OPEN with Error

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'