Open Forum

Expand all | Collapse all

Fields emptying themselves? NAV2018

  • 1.  Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted Mar 14, 2019 05:03 PM
    Edited by Samuel Champoux Mar 19, 2019 07:50 AM
    Change log is setup and activated on my Customer table.
    I have a log of the initial modification to set a value, about a month ago.
    Then, today, they say the value is gone. It is now really empty in the Customer card. No logs.
    We put it back in, save. Still no log of that.

    I put something else and put back the original value, now I have a log of both these modifications.
    How can a value be lost like that without logs, and without creating a log of the correction either?
    It's really weird!

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------
    ​​


  • 2.  RE: Fields emptying themselves? NAV2018

    Posted Mar 15, 2019 03:12 AM
    Changes done from the SQL level are not being logged in change log.

    ------------------------------
    Katarzyna Rola
    IT.integro sp. z o. o.
    ------------------------------



  • 3.  RE: Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted Mar 15, 2019 08:40 AM

    The change log relies on validation triggers being called. If you have customizations or add-ons, it is possible that the changes are being made without validation.

    Finally, you mentioned setting up change log on the Customer Table, then not seeing changes logged a Vendor.



    ------------------------------
    Andrew Good
    President
    Liberty Grove Software
    Toronto ON
    ------------------------------



  • 4.  RE: Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted Mar 15, 2019 08:45 AM
    Just to be clear, is it the Customer or the Vendor?

    While anything is possible, I haven't experienced many issues with the Change Log. From the first reply, about the only way to get around it is by updating data outside of NAV. That said, I did go look at the code behind logging modifications for the change log, and I believe if the value is changed to be empty/blank that that does not get logged. Not sure why.

    As for not creating a log of the correction, it would be important to see your exact steps moving through the system to check as to why that might have happened.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



  • 5.  RE: Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted Mar 17, 2019 07:31 PM
    If you are making changes to this field using processing only reports (no field validation) or using SQL queries then those are not captured in the Change Log table. Is that what's happening?

    Also, are you looking at the customer table in the changelog and changing the value on the vendor card?

    ------------------------------
    Meenakshi Singh
    Manager of Business Applications
    Home Market Foods, Inc.
    Norwood MA
    ------------------------------



  • 6.  RE: Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted Mar 19, 2019 07:56 AM
    ​Hi, sorry for the confusion, it is really on a Customer.
    The field is the Tax ID, which prints on their customs invoices.
    I am the only one who has access to SQL and I did not change anything there, we want everything logged.

    I do not have any custom code or add-ons that touch the Customer, other than the report itself that (should) only print the data.
    Next time it happens I'll try to make more tests before we put back the value in.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



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