Could anyone help me to understand generic feature or alternate solution for below cycle count req.
JD Edwards E1 9.2.5.6
Client has a large amount of inventory in warehouse, and they need to count it all as per frequency. However, trying to do this in just one or two days at Quarter end/ Half year End/ Financial year End is a tough task. So, they've come up with a plan to simplify the process. They'll count items every week/Fortnightly/Monthly respective to frequency.
1. Random Item selection based on frequency and periodicity irrespective of any predefined cat code. User will run R41411 weekly based on the GL class and planning family (these fields are available in F4102 table). system should select the bunch of items for the week randomly and cover all item in weeks for that Quarter.