Dynamics Community Forum Thread Details

Deleting Multiple inventory items

I am about to start a multiple item deletion of items set up with no transactions (NAV2009 RTC SP1). I have run the item table 27 and can filter to home in on those items as best I can with the available fields. I have noticed if I try to delete an item through the table where there are transactions, there is a system safeguard (error/warning message) which stops me doing this which offers a degree of comfort. However, in one test on the live system, I was allowed to delete an item which had had transactions on, which is somewhat alarming. I presume this is because the item had transactions only in a closed fiscal year and there were also no outstanding balances, orders, quotes on the system. Does anyone know if there are any other circumstances where I could delete a formerly active item inadvertently. I was of the opinion I would never be able to delete an item if there were any historic transactions on whatsoever, but this is obviously not the case

Many thanks

John

Hello John,

Thank you for posting on the Forum.

You are correct in your conclusion and understanding. Microsoft Dynamics NAV will allow for the deletion of Item records, even if the Item has activity, as long as the activity is posted in a closed year and no activity exists in open periods. The Item Card may be deleted from Table 27, like other Master Record Tables in NAV, but the system includes an OnDelete trigger, which controls the validations that the system goes through to confirm that an Item can in fact be deleted.

Specific validations (but not all-inclusive) are :

No entries (ILE, Value Entry, etc.) posted in an unclosed period.

All Entries fully applied (Open = FALSE) and adjusted fully by Adjust Cost process

No Journal Lines (Item, Consumption, Output, Requsition, Planning, etc)

No Document Lines (Orders, Invoices, Transfers, etc.)

Please note that you can work with your partner to prevent allowing deletion of records from any Table. An alternative I always communicate is to renumber the Item No. field for Items that are no longer going to be used to ZZZ- or some similar nomenclature to still include the Item and data, but to also be able to easily filter the Items out from reporting. The Item record can then just be Blocked for activity on the Item Card through the boolean field on the General Tab.

I hope this helps.

Best Regards

Tom

Quick Links

Leaderboard