Open Forum

Expand all | Collapse all

Fields emptying themselves? NAV2018

  • 1.  Fields emptying themselves? NAV2018

    TOP CONTRIBUTOR
    Posted 6 days ago
    Edited by Samuel Champoux 2 days ago
    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 6 days ago
    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 6 days ago

    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 6 days ago
    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 3 days ago
    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 2 days ago
    ​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
    ------------------------------