What's best to way delete the multiple items? I have used Excel to upload the data but it looks like that the items need to be done again. There are no transactions added to any item. I can remove the items one by one but need a way to remove them in bulk to save time.
Thanks in advance for your help!
By using the show more options in the item list, you can chose select more. Mark all items you want to delete and then delete them in bulk.
Definitely the simplest way.
You have to add Code to delete Multiple Item base on condition
Below is the code, you can add some more filters based upon your conditions
CLEAR(Item);
Item.RESET();
Item.SETRANGE(Inventory,0);
IF Item.FINDSET THEN BEGIN
ItemLedgerEntry.RESET();
ItemLedgerEntry.SETRANGE(ItemLedgerEntry."Item No.",Item."No.");
IF NOT ItemLedgerEntry.FINDFIRST THEN
Item.DELETE(TRUE);
END;
Name DataType Subtype Length
Item Record Item
ItemLedgerEntry Record Item Ledger Entry
As far as I know it is not possible to delete part of the data using Edit in Excel and Configuration Package, this may need to be customized.
Hope other experts can give you better advice.
Hope this helps.
Thanks.
ZHU
Hi,
Please use the Configuration Package functionality to define the table ID 27 and then delete them, please follow the below link
Hi
Please see this article that describe all possible method (without development)
Share
Report
All responses (
Answers (
32,718
