What is the best way to stop consolidation of a classified item with others
What we have thought of is consolidating standard items in one LPN but keeping the secret item(s) as a separate LPN. This way, we can ensure only cleared employees handle the special material.
(1) In Oracle, the controlled items have an attribute telling us their code.
(2) Moreover, the LPN for classified item will always start with X-.
In the putaway rule, restriction 1 looks like Item Security = Classified. Restriction 2 looks like License Plate Number LIKE X-%. However, I am only wondering how to consolidate these special items separately without commingling with the ordinary ones. Your thoughts would be greatly appreciated.