Planned

Reorder Low Stock funtionality in .Net

The Reorder Low Stock feature in Linnworks Desktop is very helpful for creating POs.

Can it be replicated in .Net?


10 people like this idea

Hi Ross,

our development team are working on enhanced functionality for .NET in relation to supply chain management which will include work on the reorder low stock functionality


Mark Aldous

Head of Implementation 

Linn Systems Ltd

Any update on this feature?

Hello there,


Our development team is still working on this. This feature will be added as a part of a big Improvement to the Purchase Order functionality in general so it will still take some time as this is not the only module that is being re-written.


Best Regards,

Kirill

Technical Support Team

We are desktop users but got caught short on the road today and thought no worries we will use .net to order our stock on a mobile Absolutely gobsmacked that there was no reorder low stock function. That's an absolute essential for us. Can't believe it's been missed off, how on earth are people managing without?

This is pretty urgently needed, when can we expect to see this?


We are now paying double the amount we were last year with one less user, forced to migrate to .net as the 2D Royal Mail barcode tracking isn't incorporated into the desktop app because "new features are no longer being added to the desktop" and now to top it off we are still having to open the dektop app just to build POs for our suppliers using the reorder low stock system.


Its becoming more confusing as to why we are exactly meant to be keen on staying with linnworks

Hello Sebastian,


We are working hard on this development. As mentioned earlier by my colleagues, it is part of a larger overhaul of Purchase Order functionality in Linnworks.net. Because the development is substantial, it takes longer than usual for the release. 


For this and other reasons, Linnworks Desktop is still available as normal. We always advise moving to Linnworks.net as this is where most of the new functionality will be added indeed. However, you do not need to move completely to Linnworks.net at this point, as you can still print 2-D barcode labels in Linnworks Desktop and the Barcode will be added in Linnworks.net. As long as you make sure you file the manifest via Linnworks.net at the end of the day. 


I have taken a look at your subscription as well and see you have the same number of users as last year, if you have any questions, please raise a support ticket and mention me, so I can assist you further with account-related queries. 


Best regards,
Klaas Schippers

Can't believe some sort of usable Low Stock/Stock Reorder function wasn't implemented when Linnworks.net was launched. This is an absolutely basic function that something like Linnworks needs, it shouldn't be an "improvement" that takes months to release. We have just moved onto Linnworks (having never been on or used Desktop) and now find ourselves with no easy way to check what stock we need to order from any particular supplier, the Primary Dashboard shows low stock but isn't exportable, filterable or easily usable in any way, we'd have to look down every item in the list and manually copy the ones relevant to the supplier we are ordering from to a purchase order.


Just adding a report to the Query Data Dashboard would be a good temporary fix and presumably very quick/easy to implement, it would just need to be a report which only returns SKU's that are at or below minimum level, with columns showing the minimum/current stock levels, Supplier and Category for each SKU, possibly some other useful columns that I can't think of off the top of my head. At least then users could export this and sort it by supplier/category to see what needs ordering from a particular supplier and copy/export this info easily. There are similar reports to this already so you could even just add a couple of columns to the existing reports, there are just none that have all the relevant columns at present.

Hello David,


We are trying our best to implement Reorder Low Stock functionality into Linnworks.net as soon as possible. Hopefully, we will present it about in March this year.


Thank you for the patience and understanding. In the meantime, if you want, you could raise a ticket for our customisation/scripting team - they may help you to create a custom export that will suit your needs.


https://www.linnworks.com/support/scripting-terms-and-conditions


Have a nice day!


Kind regards,

Julietta


Technical Support

The below Custom Script might be useful to others struggling with this, it'll create a report showing only stock at or below Minimum Level sorted by CategoryID so you can use Categories to mark which supplier each SKU comes from if you aren't using Categories for anything else.


SELECT
si.ItemNumber, si.ItemTitle, sLoc.Location, sl.Quantity, sl.InOrderBook, sl.OnOrder, (sl.Quantity+sl.InOrderBook+sl.OnOrder) as TotalQty, sl.MinimumLevel, (sl.MinimumLevel-sl.Quantity+sl.InOrderBook+sl.OnOrder) as QtyToOrder, si.CategoryId, il.BinRackNumber
FROM
StockItem si
LEFT OUTER JOIN StockLevel sl on si.pkStockItemId = sl.fkStockItemId
LEFT OUTER JOIN StockLocation sLoc on sl.fkStockLocationid = sLoc.pkStockLocationId
LEFT OUTER JOIN ItemLocation il on il.fkStockItemId = si.pkStockItemID AND il.fkLocationId = sLoc.pkStockLocationId
WHERE
si.bLogicalDelete = 0
AND
sl.Quantity + sl.InOrderBook + sl.OnOrder <= sl.MinimumLevel
AND
sl.MinimumLevel > -1
ORDER BY
si.CategoryId, si.ItemNumber, sLoc.Location



Thank you David.


That is very good of you to offer this. However, Linnworks really have to look at priorities here. This is absolutely terrible that this does not exist. I think March is just too long. Even if it means the basic functions of what you are working on are available and the low stock per supplier option can be made available this would help.


Please advise.

Have to add my voice to the plethora of users who are absolutely astonished that a stock management system, which forms a part of the Linnworks offer, does not have a low stock reporting facility by Supplier. Having spent 30 years in the logistics business, I can't think of any of my previous employers who would have allowed their WMS designers not to include this - it's basic functionality, and you shouldn't have to pay for a custom script to be written for such fundamentals. Perhaps time to review our commitment to Linnworks as the solution to our needs.

Hello John, this thread is for the development for re-order Low Stock functionality in Linnworks.net, this development is a part of a larger overhaul of the PO functionality and is in its final stages currently, meaning that it is due to be released soon. As for your personal situation, I see that you have access to Linnworks Desktop and are also using the desktop application from time to time. Did you know that Linnworks Desktop has this functionality for you ready to use? If you have any questions on how to use it, please reach out to support and they will be happy to help you. 

Hello Klaas

Thanks for your input, but there's a slight flaw in your solution - we can't get Linnworks Desktop to downloa. We keep getting an error. I've tried installing with the help of the chat support team, but they are obsessed with it being related to a firewall, even though they can't tell me what firewall stops the download happening or why. It doesn't seem to be stopping the download anyway, that completes normally. The error message refers to a check current version number, and an inaccessible server. Any suggestions how we address this. Your solution may be good, but we can't implement it because of this.

John

I hope that also the ability to add item specific discount and invoice level discount - so we can account for early settlement on invoice rather than having to calculate each SKU of export, adjust and reimport. A needed function please.


Login to post a comment