Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Cycle Counts in macola ES

Status
Not open for further replies.

testosteclese

Technical User
Joined
Oct 22, 2007
Messages
2
Location
US
Hello All,

I want to create a cycle count schedule that selects random items and allows me to specify the number of tags to create. Can this be done in Macola ES? I will definitely appreciate any assistance and suggestions with using the Cycle Count function in ES?

Thanks
DS
 
Macola does not offer random cycle counts natively. You can choose by cycle count code, but unless this is applied randomly you will not have a true random cycle count.

If true randomness is really important, then you can export the whole item master to excel, randomly select the items there, then write a SQL update query to change the cycle count code on these items to something unique.

From there you can use standard Macola to choose that unique cycle count code.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
While not truly random, you should take a look at the count by frequency days option in ES to see if it will meet your requirement.

Peter Shirley
Macola Consultant, PA and surrounding states.
 
Thanks for the replies. I'll look into both suggestions to see which will work best for us.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top