Item Master getting deleted

nasheer
nasheer Member Posts: 78
edited 2010-05-19 in NAV/Navision Classic Client
Dear All

Some strange thing happen to the Item Master table some time. Its getting deleted but no change log entry captured.
I added some code in OnDelete trigger of the table 'Item', but no use.

Any suggestion?

Regards
Nasheer. :D

Comments

  • csntor
    csntor Member Posts: 4
    Nasheer
    Which version of NAV you have? Suggest create a dummy item, delete it and check change log. If both the entries exist (creation & deletion) in change log then the issue is not with the change log. If not then Change log / user setups need to be checked. Adding code for recording item change is not required as it exists already in base NAV.
    csntor
    NAV & Web Orders Solution Specialists
    itmgr@compusoftnet.ca
  • nasheer
    nasheer Member Posts: 78
    Thanks for your reply. The problem happened in Version 5.0 SP1.
    As you mentioned, I have already tested create item and delete, the change log captures the entries.

    But difficult to trace out how all the items were deleted without no information captured in the Change Log.
    csntor wrote:
    Nasheer
    Which version of NAV you have? Suggest create a dummy item, delete it and check change log. If both the entries exist (creation & deletion) in change log then the issue is not with the change log. If not then Change log / user setups need to be checked. Adding code for recording item change is not required as it exists already in base NAV.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    If the item is deleted through code, then it's not recorded in the change log.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • Savatage
    Savatage Member Posts: 7,142
    It looks like you're saying it happens alot, since you added code to catch it.
    Is someone using a report to delete mass items?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • FDickschat
    FDickschat Member Posts: 380
    If ALL items are deleted it is probably a report where someone forgot to enable the temporary property for a record variable.

    The name of the variably will probably be TempItem or ItemTemp. Usually the first thing you do with a temporary record is a deletall.

    Try using the Developers Toolkit to find all occurences of a record varaible for T27 with the command deleteall and check whether the property Temporary is set correct.
    Frank Dickschat
    FD Consulting

Categories