web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Resetting Inventory St...

Microsoft Dynamics RMS (Archived)

Resetting Inventory Stock Levels

(0) Share

Report

Report

Posted on by Community Member

Anyone know how to reset stock levels for all items to 0?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Tristan Kramers 100 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Tristan,

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

Was this reply helpful? Yes No
Tristan Kramers 100 on at

Like (0)

Report
Copy link

Link copied!

Yes, all stock items in your database.
So make sure you make a backup!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks!!

I'll try it out tomorrow. =)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans