Stock Count

(0) Share

Report

Posted on by Rosemary

Hello Everyone,

I have two questions 1. when a stock count schedule is created and the count is started, can normal activities continue? i.e. Billing, Transfers, etc...

2. Can anyone recommend a handheld solution for counting stock?

We are coming to the close of our financial year and we will have a stock count which is the most tedious and time consuming activity I have had to endure.

Thanks in advance, we are using GP 2013.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Tim Foster 8,515 on at

Like (2)

Report

1. Normal activities can occur (it just makes handling discrepancies more challenging). When you Start a Stock Count a "snapshot" is taken. Consider some part has 8 on hand and 4 allocated at 8am when you start the count. At 8:15am a picker picks 2. At 8:30am 2 are transferred. At 9am your warehouse guy is there to count (expecting 8) and finds 4. He'll have to dig to confirm there was 8 when the count was started. Another scenario, consider again there are 8 on hand and 4 allocated at 8am when you start the count. At 9 am your warehouse guy is there to count (expecting 8) and finds 2. No transactions. GP should adjust 6 out - but wait, there are 4 allocated - GP will only adjust 4 out. Instead of the mighty Year end Count, have you ever considered cycle counting?

2. We use and like Collect for GP from Highjump. There are lots of other solutions out there (there are other choices from Highjump, Panatrack, WithoutWire,).

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Rosemary,

After Stock count Schedule you should not Bill or Transfer the products from warehouse ti to any other place.

Please ensure that following check is done before physical check:

1. All receipts up to date of the physical verification date/time is received and posted in system.

2. All dispatch from the warehouse up to date of the physical verification date/time is issues and posted in system.

3. After completion of physical verification, please ensure cycle counting order is entered and post the actual quantity in system.

4. After the cycle counting is posted, then continue receiving and issuing the new stocks in system.

Best Regards,

A.Aarif Khan

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

We use cycle count during the year, but a count prior tot he year end is still done. I will take a look at your suggestion.

And yes, I can see how challenging it can be if normal operations continue.

Thanks for your response.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Thanks for your response

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

Hi Rosemary,

I used to work for a larger manufacturing plant with a warehouse of over 200'000 sqft and we did the annual stock count at year end. At the time we had developed an Access Application to either manually enter some of the count sheets that were done manually by teams of worker (the whole process was split into several groups based on sectors and aisles ), but some workers used also handheld devices that we had prior loaded with data from the stock-count schedule of GP. Of course it was more effective as we used bar-codes to identify the locations and products, all they had to do was enter the QTY after the count. Once a run was completed, the data was downloaded directly into the Access Database and at the end of the day, all the data was consolidated into a SQL table and updated the whole cycle count table in GP, set the flag in the table to allow the posting of the adjustments and voilà..

It may sound very simplistic, but in reality there has been a lot of work put into this setup, but once it worked, the stock count schedules took only about a day to perform for over 20k inventory items, whereas before that it took 2-3 days to perform.

I'm pretty sure a solution like Panatrack or WoW for warehouse management would permit such operations too.

Was this reply helpful? Yes No