Skip to Content
author's profile photo Former Member
Former Member

Odd Sales Order Issue

Hi all,

We have a Sales Order ( in SAP 8.8 PL19) which is open- unfortunately we have no option to right click and close or cancel or through data-close. Also right clicking and closing each row has no affect- we can see them close but when we browse away and then back to the sales order they are open again. Show history shows nothing of interest and there are no target or base documents attached?

What can we try next or is this straight off to SAP Support?

Regards,

MB

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2011 at 11:16 AM

    HI

    What happen to the Document status when you post target document?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 10, 2011 at 11:26 AM

    Hi,

    Can you please check these two things and update us :

    1) Is there any message appearing in the System Log when the rows for the Sales Order is closed?

    2) Is there any additional code in SP_transactionNotification?

    Also, do let us know if there are other such SO affected by the issue or this is the only document.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 12:12 PM

    Just for any other users getting this problem this is from SAP support:

    We have investigated on the issue and found that for the affected Sales Order ***,*,*** the Canceled field is Y. That is the reason why the Data #> Cancel/ Close option is grey.

    We have prepared a corrective query for you.

    By using the update query you agree with liability conditions described in the following disclaimer: https://wiki.sdn.sap.com/wiki/display/PEQ/Home

    If you do not agree with the disclaimer, please contact the support organization for further processing of the reported issue.

    The update query:

    update ORDR set canceled = 'N' WHERE DocNum in ('****','***','****')

    • make sure you get 3 results **

    • USE THE ABOVE QUERIES FOR THIS MESSAGE ONLY ***

    In case you receive different results from the above expected results, do not run the queries on the customer productive database. Please return this support message with all related information and t he new database backup to the Global Support Center. Please confirm this message if the issuewas resolved by running the suggested fix.

    After running the update query, you should be able to cancel the Sales Order.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.