Skip to main content
Question

Daily cycle counting setup

  • Apr 26, 2023 9:31 PM UTC
  • 9 replies
  • 969 views
  • Translate All

michaelho
Semi-Pro III
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
  • Captain II
  • Apr 27, 2023 12:57 PM UTC

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

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Apr 28, 2023 6:49 PM UTC

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

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Apr 28, 2023 6:54 PM UTC

@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
  • Jun 20, 2023 4:27 PM UTC

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

Translate

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Jun 22, 2023 3:15 AM UTC

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

Translate

bheyns05
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • Jul 31, 2024 6:47 PM UTC

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

michaelho
Semi-Pro III
Forum|alt.badge.img+1
  • Author
  • Semi-Pro III
  • Aug 2, 2024 3:24 PM UTC

@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