Community: Inventory and MRP mailing list archives

Re: Cycle counts

Jordi Ballester Alomar
- 11/10/2016 16:03:04

Hi Matthew,

That is very useful indeed! See my comments below.

El 10 nov. 2016 9:52 p. m., "Matthew Crouch" <> escribió:
> Ive done a lot of work on this in our installation, although my code is embededded with so much other stuff that it is not really release-worthy. Contibuting my thoughts on the off chance they may help. Basically, I added a 'date of last cycle count' for each location. I set up periodic computations (weekly) that analyze the total value of product moved into or out of a location (detemined by looking at the stock moves completed within a specified period of time). This same process then proposes / creates inventory adjustments for the next week, with one half based on highest recent turnover of product (by value), and the remainder simply going down a list of all locations sequentially. In this way, all locations are counted periodically (at least 2-3 times per year before fiscal year end), with special attention devoted to high moving items.

But who do you determine in that weekly process what locations should be counted just twice a year vs. more frequently? Based on your desciption it seems that an inventory adjustment is created for each location, each week.

In some case you may need to decide that items with less moving items being counted on longer periods.

In my setup, a task is also generated and linked to the stock.inventory object, in order to track the time spent on this activity so an analysis of the costing will be available for the analytic charts.

A good idea!

When warehouse staff arrive for work each morning, they will always have at least one cycle count assigned to them to complete, scheduled for a specific starting time according to their job description (also regimented in Odoo, but that is a separate discussion).

Yes, that is useful.

On Thu, Nov 10, 2016 at 1:37 PM, Jordi Ballester Alomar <> wrote:
>  > Thanks Joël! > > This will really help. In fact this module should be a must-have, to ensure > consistency during the physical inventories. > > However the module does not seem to cover the aspect of proposing what items > to count and on what frequency should they be counted, which are important > aspects of the cycle count strategy. > > Cycle counts are very important for warehouse people, because they assist > the warehouse stuff to organize their work of counting, and make it more > effective. For example, it's not really cost effective in terms of labor > work to count every month the quantities of an item that is used once every > year. But you might want to recount montly an item that is used/replenished > every day. > > > > On Thu, Nov 10, 2016 at 7:21 PM, Joël Grand-Guillaume > <> wrote: > > Hi Jordi, > > You might want to look at this work from Numerigraphe: > > > > It's linked with some other module. > > Regards > > Joël > > > Le 10 nov. 2016 18:41, "Jordi Ballester Alomar" > <
> > a écrit : > > Dear inventory and MRP experts, > > Has anyone worked on the topic of cycle counts in inventory management? >
>  > > We're planning to work on this topic. > > Regards, > -- > Jordi Ballester Alomar > CEO & Founder | Eficent > (+34) 629530707 | | > Twitter: | Linkedin: >
>  > > _______________________________________________ > Mailing-List:
>  > Post to: > Unsubscribe: > > _______________________________________________ > Mailing-List: > Post to: > Unsubscribe:
>  > > > > > -- > Jordi Ballester Alomar > CEO & Founder | Eficent > (+34) 629530707 | |
>  > Twitter: | Linkedin: >
>  > > _______________________________________________ > Mailing-List:
>  > Post to: > Unsubscribe:
>   -- - Matt Hydrogen is a colorless, odorless gas, which if left alone in large enough quantities, for long enough, will begin to think about itself.
> _______________________________________________
> Mailing-List:
> Post to:
> Unsubscribe: