web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Setting all Lines in i...
Microsoft Dynamics GP (Archived)

Setting all Lines in inventory to zero

(0) ShareShare
ReportReport
Posted on by Community Member

Hi i was wondering if anyone knows a quick way of making all items in inventory to zero, 

i know you can do it through a stock count mark it as counted as zero, ---- however this is long winded as we have over 1000 sku's

i also know that you can do it through transaction entry and giving it + or - the quantity to make it zero. but for the same reason as above there are over 1000 lines that it will take a long while to complete.

any help would be great

*This post is locked for comments

I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Before setting out to answer this - I have to ask - why you want this done?

    Are you just wanting to start over?  Do you have a specific reason?

    Why I ask is that the reason will influence how I answer.

  • Community Member Profile Picture
    Community Member on at

    Hi Bill it is because i have created a new site, and have basically copied data off a an existing site, my interneions for this new site is to turn on  multi-bins, but want it to be activated with no stock on the system.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    If you are going to continue to use the data in the database and simply need to reset the value of items at a specific location to ZERO I would recommend using the application to complete this, since it will update all the tables at the correct time and provide the most complete and secure solution.

    I know that you can update the values of XXX inventory table in SQL Server, but the problem is making sure you get all the right tables - some of them are not so obevious and would likely be the ones you miss.

    Doing the Stock Count and then recording that you counted ZERO of each of the items will be the best solution - in my opinion.

    Good luck.

  • Community Member Profile Picture
    Community Member on at

    i think it will thanks for you help

  • Community Member Profile Picture
    Community Member on at

    Hi Bill

    I have a situation - where I want to start over - i want to zeroise all my current stock inventory items - of which I have more that 2500 - and I will start again with new stock figures.

    Is there a way to do this in SQL, quickly?

    Thanks

    Ray

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans