Skip to main content

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. 

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. 

 

@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.

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 @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. 

@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.

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

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

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.

@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?

Reply


Terms & ConditionsCookie settings