Validate field to UDT

SOLVED

Created a UDT for customer type and now trying to set validation on CustomerType field in AR_Customer to my UDT for customer type. It will only let me do this if I choose all users, all companies in advanced field settings. I don't want this validation in other companies only one company. Is there a way around this?

Parents Reply Children
  • +1 in reply to Kevin M
    verified answer

    I think the issue is that they are wanting to set the validation on the standard CustomerType field, not a UDF, although this brings up another way to handle this, create a UDF to hold the customer type but only add it to Customer Maintenance in Customizer for the target company.  Could then use a simple post validate script on the UDF to mirror the UDF value to the CustomerType field so it can be leveraged throughout Sage 100 where the CustomerType is used.

  • 0 in reply to David Speck

    Good catch.  I didn't notice it was a Sage field (not a UDF).

    I like the mirror script too... perhaps coupled with a company specific panel to show either the UDF or regular field.

  • 0 in reply to Kevin M

    Thank you everyone. I'm not the best at scripting but will give it a try. We would like to use the standard customer type field rather than a udf so these suggestions are great! Much appreciated!