Open Forum

Expand all | Collapse all

Negative POP10110.LineNumber

  • 1.  Negative POP10110.LineNumber

    SILVER CONTRIBUTOR
    Posted 21 days ago
    Good day, everyone!

    I am working with a customer who came across an issue that I am not able to reproduce but have been told has happened before.

    There are a number of PO lines (in the POP10110 table) that show the LineNumber as a negative.  The top query results are from a production database showing the negative number.  The bottom query results are from a backup of that production company.  As you can see, these values were originally what one would expect to see.  There are over 700 POs that this has occurred to.  

    Negative LineNumber

    Has anyone ever seen this before?  If so, do you happen to know what the cause is?  A reconcile does correct the issue but we are trying to understand why it happened in the first place.

    Thank you! 


    ------------------------------
    Jamie Evenson
    CEO
    Najaxa Software
    Fargo, ND
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Negative POP10110.LineNumber

    TOP CONTRIBUTOR
    Posted 17 days ago
    Hi @Jamie Evenson ,

    The only time I've seen something similar happen is when a client had someone else write a custom integration to create and update/modify  the PO.  They were using some wonky calculations in the integration that would cause the "update" part of the run to change the numbers and sometimes they turned negative.

    Any chance you've got customizations that interact with the PO on some level?

    Thanks,

    Samantha​

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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Negative POP10110.LineNumber

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Hi @Samantha Higdon,

    Thank you for your response.  This customer definitely has a customization (written by Microsoft many, many years ago) ​that does update/modify the PO.  I will look into this and see what it might be doing with the Line Number.

    Thank you again for the suggestion!


    ------------------------------
    Jamie Evenson
    CEO
    Najaxa Software
    Fargo, ND
    ------------------------------

    Academy - Online Interactive Learning from Experts


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