Skip to main content
Question

Daily cycle counting setup

  • April 26, 2023
  • 9 replies
  • 964 views
  • Translate All

Forum|alt.badge.img+1

Our use case: we house 5k+ products in our warehouse and need to perform daily cycle counting. Our goal is to count every product in the warehouse at least 8 times over the course of the year. In theory this should give us 150-200 products to count per day and products would get counted once ever 6 weeks.

Does anyone have any suggestions regarding the best method to accomplish this? We have ended up creating 30 individual cycles and are rotating through these cycles in succession. However, this is not a great experience as it requires any new products to be added to one of the 30 cycles and there isn’t a great way to make sure they’re evenly distributed across all 30 cycles. 

9 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @mikeho 

How are our Physical Inventory Types setup? Have you looked at the Last Count on or Before? That may reduce some of those counts. 

 

Translate

meganfriesen37
Captain II
Forum|alt.badge.img+13

@mikeho - we had built a custom daily cycle count process for a customer last year that randomly selects “X” items daily to ensure that all items are counted “X” times per year.  We couldn’t find a way to do it using stock functionality.

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • April 28, 2023

Hi @kandybeatty49. We are currently doing it by cycle. I haven’t tried it by last count on or before, that could be an option for us.

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi @kandybeatty49. We are currently doing it by cycle. I haven’t tried it by last count on or before, that could be an option for us.

Hi @mikeho 

I would try those and test to see if you get less options and what the results are. 

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • April 28, 2023

@meganfriesen37 - that’s disheartening. I’m definitely finding the cycle counting features in Acumatica a bit lacking.

Another big issue we are running into is if we include items with Zero book quantity, Acumatica will list products with past locations instead of the current location to which the product has been set as the Primary Item.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 20, 2023

Hi @mikeho were you able to find a solution? Thank you!

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • June 22, 2023

Hi @Chris Hackett - no, this is still an issue for us.

Translate

bheyns05
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • July 31, 2024

Hi @mikeho 

 

Have you tried using the ABC codes to help with frequency counting? Have a look at this video on how to set this up: https://www.youtube.com/watch?v=II2AU_WsS2w. Products are linked to ABC code and ABC code dictates the frequency in which it needs to be counted.

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • August 2, 2024

@bheyns05 I haven’t tried that yet, mainly because I’m not sure how that would work in our case where we want all products counted 8 times a year. Do you think that’s possible with ABC codes?

Translate