Skip to main content

Notifications

Microsoft Dynamics RMS forum

Resetting Inventory Stock Levels

Posted on by Microsoft Employee
Anyone know how to reset stock levels for all items to 0?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Resetting Inventory Stock Levels

     This will work ? it seems that you still get negative entries as the movements history is confusing the numbers...

     

    how can we ERASE all the items including history , but without erasing SALES

     

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Resetting Inventory Stock Levels

     Thanks!!

     

    I'll try it out tomorrow. =)

  • Tristan Kramers Profile Picture
    Tristan Kramers 100 on at
    Re: Re: Re: Resetting Inventory Stock Levels

     Yes, all stock items in your database.

    So make sure you make a backup!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Resetting Inventory Stock Levels

     Hi Tristan,

     

    Thanks for the quick reply!! I really appreciate it. Will that update all items? 

  • Tristan Kramers Profile Picture
    Tristan Kramers 100 on at
    Re: Resetting Inventory Stock Levels

    Open SO Administrator and connect to the database.

    Select Query >> New

    Type:

    Update item

    set quantity = 0

     

    Press F5

     

    Type in exacly as shon above.

    Remember to make a backup before proceeding, just in case.

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 Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans