Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Delete 40000 Item

Posted on by 875

Good Morning For All

I'm Working In Rms Version 2.0.2000

and i Have 15 Stores

I'm  want Delete 40000 Item From Table Item

Can I Make This From any Work Sheet Or we must  Deleted It from sql server IN Each Store ?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete 40000 Item

    Hello Saudi,

    Thank you for your question.

    Please note that we do not support deleting items from a database, as this can leave orphaned entries on other tables that referenced the deleted items. This can cause to database structure and stability concerns, including the possibility of database corruption.

    The option to inactivate and block sales of those items is the recommended course of action that we recommend.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support engineer

  • Saudi Market Profile Picture
    Saudi Market 875 on at
    RE: Delete 40000 Item

    thanks for help Mr .atef

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete 40000 Item

    Check item dynamic also

  • Saudi Market Profile Picture
    Saudi Market 875 on at
    RE: Delete 40000 Item

    (this item id not in transactions_entry and purchase_entry)

    -------------------------

    i will delete it from item and Alias and kit and supplierlist

    (could you tell me any other tables to delete id_items from it )?

    thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Delete 40000 Item

    No worksheet exist to apply this job.

    The recommendation is deactivate this items and  then block sale.

    If you need to delete you have to do it from SQL, but you have to check first that no movement for this items (sales or inventory transactions)

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.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans