Are you struggling to remove Reserved Stock in Sage 200? There may be a time when you are trying to allocate stock, but are unable to as it is saying that there is no stock available when you know that there is but you cannot find it anywhere. At some point, the stock may have been ‘set aside’ by Sage for future orders.
These orders that may never came through but Sage has put it into Reserved Stock. Therefore, you or no one else will have access to this stock, as it has been saved by Sage.
In an ideal world, this would be a good thing, but sometimes orders fall through and you need to release that ‘saved stock’. This is what we are going to be looking at in this blog, let’s get started…
First things first…
To start with, you need to have the Stock Code at hand.
Then, go into System Admin to get the name of the database that you are going to looking for:
When you have the Database name log onto your SQL server > Double click on the Database tab
Find the database in question, open up the database > Tables > Double click on tables and find the Stock Item Table – (named dbo.stockitem)
Scroll to the Stock Item Table > right click and click on Edit Top 200 Rows
In the toolbar along the top there is a table icon:
Click this and the Stock Item Code table will appear
Go to the Code field and scroll along to the ‘Filter’ column > add the Stock Code.
In the toolbar: Click on the button as indicated on the screenshot below:
(depending on the version of SQL that you are running, you may get a message saying that it could not be parsed: If you get this message then type in = ‘then enter the code‘: ie. =’.test’) .
This will then give you the Stock Item ID, which is displayed in a new table, which will appear below…
(ensure you make a note of this number)
With the Stock Item ID: displayed, scroll along to Quantity Reserved Column.
Change this to zero but do not press enter.
Using the keyboard arrows: Click the down arrow 1st followed by the right arrow, this will save any changes.
Go back into tables listed on the left of the screen, scroll to the ‘Bin Item Table’.
Right-click on this > Edit Top 200 > enter the Stock Item ID
Then it is just a case of repeating from Step 1
Go back to the list of tables on the left of the screen, scroll to ‘Warehouse Item’.
Right-click on this > Edit Top 200 > Then repeat from Step 2
Now to check that the changes have been made in Sage:
Go into Sage > Stock Control > Stock List.
Then, we need to add another column to do this you go to the top of the table, in the title bar of the list (‘the name bar’), right-click to add a column. This is for filtering purposes later.
You then need to put your Stock Code, the original one from Sage, into the search , (this is the filter you added) and it will search the tables:
The amount in the Quantity Reserved will now be zero:
You have now removed your Reserved Stock!
Congratulations. We absolutely love feedback here at itas, so if you enjoyed this blog… or didn’t, please let us know!