Open Forum

Expand all | Collapse all

SOP60100 Errors

  • 1.  SOP60100 Errors

    Posted 2 days ago

    Hello,

    I'm wondering if any one knows what the values of the rctinvcerrors in the SOP60100 table mean.  I have a bunch of entries with the error code of 0x02000000.  It seems the transactions with this error code are not getting the qty's moved out of backordered upon receipt of the item.  To complete the sales transactions in these cases we need to delete the SOP to POP links and update the qty's manually.  I'm wondering if someone may have the sales document open exactly when the receipt is getting posted, preventing GP from updating the qty's on the sales document.  Is there any way to prevent this from happening?

    Any insight would be greatly appreciated.



    ------------------------------
    Chris Giesbrecht
    Manager of IT and Business Analytics
    Penner Farm Services
    Blumenort
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: SOP60100 Errors

    TOP CONTRIBUTOR
    Posted 2 days ago
    Hi @Chris Giesbrecht ,

    If someone has the sales order open while the receipt is being posted that has the SOP/POP link on it (i.e. you're receiving items specifically for that sales order), yes GP will have a problem updating the quantities associated with the sales order on back order.

    I just had this talk with a client actually.  There's not a great way to stop someone from opening a sales order though that i can think of.  If they have access, they have access.​

    In my case, the client was able to find who was the culprit of having the document open (a fairly small group who have access there), and we re-routed them to SmartLists and inquiries for the basic information look up they needed.

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: SOP60100 Errors

    Posted 2 days ago
      |   view attached

    Ok, thanks @Samantha Higdon.

    I was thinking of writing a report that whoever is posting can check if there are any locked documents related to line items on receipts in the batch that they are posting.  At least it would catch most of them (i guess someone could still open a document between running the report and posting)​.

    I also have a bunch showing up with a different error code and was wondering if you know what the cause of those might be?  See attached.  I believe the 0x00000000 code means everything was good.



    ------------------------------
    Chris Giesbrecht
    Manager of IT and Business Analytics
    Penner Farm Services
    Blumenort
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: SOP60100 Errors

    TOP CONTRIBUTOR
    Posted 2 days ago
    0 is normal.
    For sure a user lock on the SOP document will prohibit updates.
    Typically we make a Smartlist that shows the codes not equal to zero for troubleshooting.
    Also a Smartlist showing the locks, docnumber and the users holding the lock. For all docs not just SOP
    Here are the codes:


    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role