Notifications
Announcements
No record found.
Hey guyS!
As stated in the Subject, is there a way I can delete multiple items at the same time instead of having to delete them individually?
Thanks!
*This post is locked for comments
You can delete only those items that either did not have any posted activities in non-closed fiscal year. Thus, when you delete an item, the system checks by OnDelete trigger if there has been posted activities with this item, and system asks you on each item if you really want to delete it or not. For mass elimination of item cards we usually use SQL statements, in some cases we can delete item manually from the table 27.
ok, SQL statements, where do I do that? I just want to delete a bunch of items i havent used at all, I uploaded them with rapidtstart at some point
HI,
1. If the items are imported and not used in system you can delete them by Running table and selecting multiple items and delete.
2. If the Items have been used, you can still create a codeunit, and filter the item table based on no. that you plan to do and just call Delete. When you call delete it will not fire the code in Delete Trigger.
ok, so how do I do your first option? how do I run a table?
Run NAV Development Environment, and from that select Table - 27 Item and press 'Run' button.
oh ok, the IT guy has this license, I dont in my computer, so no way this can be done just through the normal navision software then?
Delete used items without using the Delete Trigger is a thing you never should do if you still want to use your NAV in the future.
It leeds to inconsistencies in the related tables (like item prices / BOM / ...) and will create error messages when you try to work again with one of the documents where this item has been used (e.g. function Copy Document)
Hey Rainer,
I agree what you said, but i only suggested that because the issue says that she by mistake imported blank items using rapid start services.
Open Items Table from Development Environment. Run Table 27 (Item).
Select Multiple Items using (Shift + Down Arrow) or (Ctrl + Mouse) that you want to delete and then press delete button.
If you do not have any transactions against any of the selected items, it will get deleted.
Hi Pollux1986! You just need to "run" table 27 from Development Environment (object designer). That will open a list with all the records. Select them and press "delete". You don' need the developer licence, just the development environment (former "classic client").
Good luck!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
