Attention: Please take a moment to consider our terms and conditions before posting.

Stock Control - Help me please

Swisdom
Swisdom Posts: 14,977
in Not Sports Related
Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

thanks in advance

Comments

  • Cafc43v3r
    Cafc43v3r Posts: 21,600
    You can get a cheap bar code scanner and use a lap top and ms access if your looking for a cheap and quick solution. 
  • Swisdom
    Swisdom Posts: 14,977
    Cafc43v3r said:
    You can get a cheap bar code scanner and use a lap top and ms access if your looking for a cheap and quick solution. 
    I know but I am working with people who aren't technologically gifted...MS Access will flip their noodles

    I'm wondering what sort of things other people use.  Not scared to invest in something robust but want to make sure it can do exactly what I want...and probably a few things I don't even know I want
  • EastStand
    EastStand Posts: 4,109
    If you want something really easy you can just use excel to log numbers. I’m sure there are tonnes of templates out there. 
  • i_b_b_o_r_g
    i_b_b_o_r_g Posts: 18,948
    And you can buy bar codes off eBay 
  • SuedeAdidas
    SuedeAdidas Posts: 7,740
    Are there any Apps you can use to do this?!?
  • LenGlover
    LenGlover Posts: 31,651
    Your stock room 'with stuff in it:'

    Is that stuff general stuff you might need sometime or do you buy in for specific jobs?

    If you buy in for specific jobs then a job costing system might do what you appear to want.


  • i_b_b_o_r_g
    i_b_b_o_r_g Posts: 18,948
    SuedeAdidas said:
    Are there any Apps you can use to do this?!?
    I'll look into it, but there weren't when I had my sweet shop up next to Grove Park BR Station. 
  • Huskaris
    Huskaris Posts: 9,848
    Swisdom said:
    Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

    I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

    So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

    Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

    thanks in advance

    Do you log your jobs? Could you not have someone move the picklists for each job as they move as per their incoterms? 

    It's difficult to answer this question without knowing what kind of things you are moving, what size your company is, and what kind of admin staff you have behind you.

    From what I can understand though, it looks like you want something like this. 

    https://www.barcoding.co.uk/stock-control-solutions/

    It should help you accurately track your stock, as well as your moving stock for Year end and month end reconciliations. 
  • Baldybonce
    Baldybonce Posts: 9,641
    Swisdom said:
    Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

    I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

    So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

    Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

    thanks in advance
    Do you suspect some of your staff are up to no good?

    I have a problem of stores allegedly being used at a much faster rate than they should be.
  • i_b_b_o_r_g
    i_b_b_o_r_g Posts: 18,948
    Baldybonce said:
    Swisdom said:
    Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

    I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

    So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

    Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

    thanks in advance
    Do you suspect some of your staff are up to no good?

    I have a problem of stores allegedly being used at a much faster rate than they should be.
    I suspected some skulduggery going on with certain stock items (Mars, Chuppa Chups and Marathons) going missing from my sweet shop up next to Grove Park BR Station, and I too, put it down to staff, but I was the only employee I had on the books.
  • Sponsored links:



  • Clem_Snide
    Clem_Snide Posts: 11,737
    I recently implemented Impress Stock at work for the repairs department. Operatives hate it (stops them nicking stuff) managers love it.

    Overview here:


  • Baldybonce
    Baldybonce Posts: 9,641
    i_b_b_o_r_g said:
    Baldybonce said:
    Swisdom said:
    Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

    I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

    So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

    Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

    thanks in advance
    Do you suspect some of your staff are up to no good?

    I have a problem of stores allegedly being used at a much faster rate than they should be.
    I suspected some skulduggery going on with certain stock items (Mars, Chuppa Chups and Marathons) going missing from my sweet shop up next to Grove Park BR Station, and I too, put it down to staff, but I was the only employee I had on the books.
    And you now have the franchise to weightwatchers France?
  • Imnot Athletic
    Imnot Athletic Posts: 1,017
    What do you use for your accounts?  You might be able to find something to bolt onto it so that you know not only the location but the value in each location.
  • Swisdom
    Swisdom Posts: 14,977
    Imnot Athletic said:
    What do you use for your accounts?  You might be able to find something to bolt onto it so that you know not only the location but the value in each location.
    I use Sage...will take a look
  • Huskaris
    Huskaris Posts: 9,848
    Swisdom said:
    Imnot Athletic said:
    What do you use for your accounts?  You might be able to find something to bolt onto it so that you know not only the location but the value in each location.
    I use Sage...will take a look
    Sage 50? It has a stock module but I don't think it has locations. We don't track stock in our Sage system because it's awful and track it all offline instead.

    https://www.barcoding.co.uk/

    Something like this might help, seems to be a plugin for sage. If maintained well, I'm sure your accountant will thank you .
  • Covered End
    Covered End Posts: 51,995
    i_b_b_o_r_g said:
    Baldybonce said:
    Swisdom said:
    Boring question but hoping someone on here can give me a bit of advice.  Apologies for noob question but it's a new venture for me.

    I'm looking to invest in some software & hardware that logs my stock.  Essentially we have a stock room with stuff in it.  I want to be able to scan stuff in and out and then monitor where that stock is - is it used on a job OR is it in someone's van stock.  

    So at any given time I know what I have in my stores, what is in each vehicle and what has been used on a job.

    Pretty sure I haven't explained myself as clearly as I could have but if anyone can decipher what I am looking for I would be delighted to know more.

    thanks in advance
    Do you suspect some of your staff are up to no good?

    I have a problem of stores allegedly being used at a much faster rate than they should be.
    I suspected some skulduggery going on with certain stock items (Mars, Chuppa Chups and Marathons) going missing from my sweet shop up next to Grove Park BR Station, and I too, put it down to staff, but I was the only employee I had on the books.
    Rob's on form today.

Categories

“Marketplace”