SLS Document show OPEN with Error

(0) Share

Report

Posted on by Bill Campbell

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (1)

Report

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'

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

What an interesting suggestion.

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

Was this reply helpful? Yes No
Don Wisch 660 on at

Like (1)

Report

I would set SQLLogSQLStmt = TRUE in the DEX.ini file to see what statement shows in the DEXSQL file when this error occurs.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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'

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (1)

Report

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.

Was this reply helpful? Yes No