Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jamie Evenson]

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.  

 

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

[Samantha Higdon]

Hi ,

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

[Jamie Evenson]

Hi ,

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