Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

SLS Document show OPEN with Error

Posted on by 22,647

Just wondering if someone might have an idea how this happens.

BCHydro_5F00_Error.GIF

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

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    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 Profile Picture
    Bill Campbell 22,647 on at
    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 Profile Picture
    soma 24,406 on at
    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 Profile Picture
    soma 24,406 on at
    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 Profile Picture
    Redbeard 12,931 on at
    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 Profile Picture
    Don Wisch 660 on at
    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 Profile Picture
    Bill Campbell 22,647 on at
    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 Profile Picture
    Redbeard 12,931 on at
    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'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans