Share
ReportHey 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’re offline. This is a read only version of the page.
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
Hello, I'm trying to do the same.. When i delete the item, it gives an error that UoM conversions are set up. So I then go to delete those. I can delete all of them except for the Base unit of measure, it errors out when I try to delete that. Is it still possible to delete the Base unit of measure, so that I can then delete the item itself? Or am I stuck? No other transactions exists for my items.. they were loaded via Rapidstart unnecessarily.
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!
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.
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.
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)
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?
Run NAV Development Environment, and from that select Table - 27 Item and press 'Run' button.
ok, so how do I do your first option? how do I run a table?
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, 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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
