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
  • 0

    If you are not using the UDF in other company codes, set the validation in UDF maintenance (tab 2) and don't mark it as required.

  • +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.

Reply
  • +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.

Children