I am tracking unique serial numbers (text field) in an inventory object and every serialized item has a status (Receiving, Testing...Stocked...Shipped (out of system).
I want to prevent the duplication of serial numbers IF the previous duplicates are NOT "Shipped". In other words, you can never have a duplicate SN in the system at the same time unless the other duplicate(s) are in the "Shipped" status. I can't use the "Unique" setting on the field, as this is too stringent and can't figure out the sequence with VLOOKUP + the additional layer to get my validation to work.
Any help would be greatly appreciated.
Thanks!
Marino
답변 5개
There is a way to get around this but the caveat is your Sales Cloud Edition . Here is link [1] from the Help and Training that explains the idea.
[1] - link (http://help.salesforce.com/HTViewSolution?id=000004212&language=en_US)