Community: Inventory and MRP mailing list archives

expert-inventory@mail.odoo.com

Re: Cycle counts

by
matt crouch
- 11/10/2016 15:49:16
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. 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.  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).

On Thu, Nov 10, 2016 at 1:37 PM, Jordi Ballester Alomar
<jordi.ballester@eficent.com> 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
> <joel.grandguillaume@camptocamp.com> wrote:
>
> Hi Jordi,
>
> You might want to look at this work from Numerigraphe:
>
> https://github.com/OCA/stock-logistics-warehouse/blob/8.0/stock_inventory_location/__openerp__.py
>
> It's linked with some other module.
>
> Regards
>
> Joël
>
>
> Le 10 nov. 2016 18:41, "Jordi Ballester Alomar"
> <jordi.ballester@eficent.com> a écrit :
>
> Dear inventory and MRP experts,
>
> Has anyone worked on the topic of cycle counts in inventory management?
> https://en.wikipedia.org/wiki/Cycle_count
>
> We're planning to work on this topic.
>
> Regards,
> --
> Jordi Ballester Alomar
> CEO & Founder | Eficent
> (+34) 629530707 | jordi.ballester@eficent.com | http://www.eficent.com
> Twitter: https://twitter.com/jbeficent_erp | Linkedin:
> https://www.linkedin.com/in/jordiballesteralomar
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-inventory-and-mrp-66
> Post to: mailto:expert-inventory@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-inventory-and-mrp-66
> Post to: mailto:expert-inventory@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>
>
>
>
> --
> Jordi Ballester Alomar
> CEO & Founder | Eficent
> (+34) 629530707 | jordi.ballester@eficent.com | http://www.eficent.com
> Twitter: https://twitter.com/jbeficent_erp | Linkedin:
> https://www.linkedin.com/in/jordiballesteralomar
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-inventory-and-mrp-66
> Post to: mailto:expert-inventory@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?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.