mibuso.com
Home› NAV/Navision Classic Client

Change Log Problem...

AngeloAngelo Member Posts: 180
edited 2008-09-03 in NAV/Navision Classic Client
Hi Master,

I have a problem in Change Log. I have already setup up one table in change log Setup ( Creation,Modification, and Deletion for all fields) but why when I delete record in the table and there is no information in Change Log Entry for deleted record?
Please Advice....

Comments

  • kinekine Member Posts: 12,562
    It seems that the record is deleted through some C/AL code. Changes done through C/AL code are not in the change log.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • AsallaiAsallai Member Posts: 141
    Angelo, I think you are using native database. That does not work. I had the same problem, but when I'm changed to SQL that work fine.
  • garakgarak Member Posts: 3,263
    it works also in Native.
    Do you make it right, it works too!
  • AngeloAngelo Member Posts: 180
    I'm using SQL and the problem happened when I cancel reservation. Cancel Reservation means delete Reservation Entry table,right? but why that is not recorded in Change Log Entry?
  • kinekine Member Posts: 12,562
    Angelo wrote:
    I'm using SQL and the problem happened when I cancel reservation. Cancel Reservation means delete Reservation Entry table,right? but why that is not recorded in Change Log Entry?

    Not directly. You are not deleting the reservation entry directly. You are running some C/AL which will delete it... and this is the problem... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • idiotidiot Member Posts: 651
    For cancellation of Reservation you need to check the custom table that is created specially for this purpose :D
    Check with your manger on this :D
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • garakgarak Member Posts: 3,263
    kine's right.
    The change log only log manual changes.
    If you need to update the change log also when the record is changed by code, you must create your own function based on the changelog management codeunit (see CU 1) and CU for Changelog.

    take a look at this post

    Regards
    Do you make it right, it works too!
  • AngeloAngelo Member Posts: 180
    Can help me how to make additional coding to record Canceled Reservation(Deletion Reservation Entry) in CU 1 (OnGlobalDelete Function)?
  • ayhan06ayhan06 Member Posts: 210
    Angelo wrote:
    Can help me how to make additional coding to record Canceled Reservation(Deletion Reservation Entry) in CU 1 (OnGlobalDelete Function)?

    check codeunit 103 "Cust. Entry-Edit".it is called from OnModify trigger of "Customer Ledger Entries" form.
    you should add similar code to the location where reservation entries are deleted.
  • AngeloAngelo Member Posts: 180
    thanks guys for all your clues... \:D/
Sign In or Register to comment.